I have a collection from a query called $dataItemregistrationdetail:
$dataItemregistrationdetail = DB::table('itemregistrationdetail')
->join('sections', 'itemregistrationdetail.sectionid', '=', 'sections.sectionid')
->join('categories', 'itemregistrationdetail.categoryid', '=', 'categories.categoryid')
->join('kategori_kursus', 'itemregistrationdetail.kategoriid', '=', 'kategori_kursus.kategoriid')
->join('devices', 'itemregistrationdetail.deviceid', '=', 'devices.deviceid')
->select('itemregistrationdetail.*', 'sections.sectionname', 'categories.categoryname', 'kategori_kursus.kategorikursus', 'devices.kursusname')
->where('itemregistrationdetail.itemregistrationid', $id)
->get();
This collection output this:
Collection {#557 ▼
#items: array:4 [▼
0 => {#552 ▼
+"ItemRegistrationDetailID": 64852
+"ItemRegistrationID": 194
+"SectionID": 1
+"CategoryID": 1
+"KategoriID": 1
+"DeviceID": 1129
+"BrandID": 0
+"ModelID": 0
+"SerialNo": "SEKOLAH MENENGAH"
+"StatusID": 1
+"Imei": "MAKTAB PERGURUAN"
+"No_tel": ""
+"Comments": ""
+"daymula_kursus": 9
+"monthmula_kursus": "May"
+"yearmula_kursus": 2011
+"daytamat_kursus": 28
+"monthtamat_kursus": "July"
+"yeartamat_kursus": 2011
+"sectionname": "I91"
+"categoryname": "GURU BESAR"
+"kategorikursus": "KURSUS (UMUM)"
+"kursusname": "KURSUS ASAS"
}
1 => {#549 ▶}
2 => {#555 ▶}
3 => {#558 ▶}
]
}
I had another array for dates. The value of the array is the date for each element of $dataItemregistration. The date array named $datatarikhMula:
$datatarikhMula = DB::table('itemregistrationdetail')
->select('itemregistrationdetail.daymula_kursus', 'itemregistrationdetail.monthmula_kursus', 'itemregistrationdetail.yearmula_kursus')
->where('itemregistrationdetail.itemregistrationid', $id)
->get();
I had formatted the above collection to this array:
//**************** format the value of the date************************
$dates = json_decode($datatarikhMula, true);
$dataTarikhMula = array();
foreach($dates as $date)
{
$dataTarikhMula[] = implode(' ', array_values($date));
}
The output for array dataTarikhMula is:
array:4 [▼
0 => "9 May 2011"
1 => "24 0 2013"
2 => "12 0 2013"
3 => "7 April 2014"
]
I need to append each date to each dataItemregistrationdetail row so that in dataItemregistrationdetail will contain extra attribute named date containing the value from dataTarikhMula array. So, it will output like this:
Collection {#557 ▼
#items: array:4 [▼
0 => {#552 ▼
+"ItemRegistrationDetailID": 64852
+"ItemRegistrationID": 194
+"SectionID": 1
+"CategoryID": 1
+"KategoriID": 1
+"DeviceID": 1129
+"BrandID": 0
+"ModelID": 0
+"SerialNo": "SEKOLAH MENENGAH"
+"StatusID": 1
+"Imei": "MAKTAB PERGURUAN"
+"No_tel": ""
+"Comments": ""
+"daymula_kursus": 9
+"monthmula_kursus": "May"
+"yearmula_kursus": 2011
+"daytamat_kursus": 28
+"monthtamat_kursus": "July"
+"yeartamat_kursus": 2011
+"sectionname": "I91"
+"categoryname": "GURU BESAR"
+"kategorikursus": "KURSUS (UMUM)"
+"kursusname": "KURSUS ASAS"
+"date": "9 May 2011" <------------------added value
}
1 => {#549 ▶}
2 => {#555 ▶}
3 => {#558 ▶}
]
}
How to append the value into each $dataItemregistrationdetail array element?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire