?> <div class="draft-plan-index"> <?php $data_draft = DraftPlan::find()->all(); $dynamick = new DraftPlan(); // /*converting obejct to array*/ $data = ArrayHelper::toArray($data_draft, ['lukisongroup\\master\\models\\DraftPlan' => ['ID' => function ($dynamick) { return $dynamick->IdDinamikScdl; }, 'GEO_ID', 'LAYER_ID', 'DAY_ID', 'DAY_VALUE']]); foreach ($data as $value) { # code... // echo $value['ID']; $dua[] = Jadwal::getArrayDateCust('2016', 'C', '1', '1', '', $value['ID'], '66'); } // print_r($dynamick->IdDinamikScdl); // die(); // print_r($dua); // die(); // $dua= DraftPlan::getDateVal(); // print_r($dua); // die(); // print_r(\ptrnov\salesforce\Jadwal::getDateOfWeekAndDayname('2016','34','1')); // die(); /* * GRID draft_plan * @author wawan [aditiya@lukison.com] * @since 1.2 */
/** * finds draftplan models. * @var $dynamick draftplan. * @var $data converting obejct to array. * save c0002scdl_plan_group via batch insert. * if success redirect page index * @return mixed * @author wawan * @since 1.2.0 */ public function actionSendDraftX() { /*model draftplan*/ $data_draft = DraftPlan::find()->all(); $dynamick = new DraftPlan(); /*converting obejct to array*/ $data = ArrayHelper::toArray($data_draft, ['lukisongroup\\master\\models\\DraftPlan' => ['ID' => function ($dynamick) { return $dynamick->IdDinamikScdl; }, 'GEO_ID', 'LAYER_ID', 'DAY_ID', 'DAY_VALUE', 'CUST_KD', 'ODD_EVEN']]); // $dua = Jadwal::getArrayDateCust('2016','A','1','1','1','c00.1','66'); // print_r($dua); // die(); // foreach ($data as $value) { // # code... // // echo $value['ID']; // } /*batch insert*/ foreach ($data as $key => $value) { # code... if ($value['ID'] == 'NotSet') { } else { $dua = Jadwal::getArrayDateCust('2016', $value->custlayer->LAYER_NM, $value['ODD_EVEN'], $value['DAY_ID'], $value['GEO_ID'], $value['CUST_KD'], '66'); } foreach ($dua as $val) { # code... $this->conn_esm()->CreateCommand()->batchInsert('c0002scdl_plan_detail', ['CUST_ID', 'TGL', 'SCDL_GROUP'], [[$val['custId'], $val['tg'], $val['scdlGrp']]])->execute(); } } /*batch insert*/ // foreach ($data as $val) { // # code... // $dua = Jadwal::getArrayDateCust('2016','C','1','1','',$val['ID'],'66'); // $array_nilai_uniq = array_unique($dua); // foreach ($array_nilai_uniq as $value) { // # code... // // $this->conn_esm()->CreateCommand() // // ->batchInsert('c0002scdl_plan_group', ['SCDL_GROUP', 'GEO_ID','LAYER_ID','DAY_ID','DAY_VALUE'], [ // // [$value['ID'],$value['GEO_ID'],$value['LAYER_ID'],$value['DAY_ID'],$value['DAY_VALUE']] // // ])->execute(); // // } // $this->conn_esm()->CreateCommand() // ->batchInsert('c0002scdl_plan_group', ['SCDL_GROUP','TGL_START'], [ // [$value['custId'],$value['tg']] // ])->execute(); // } // } // $array_nilai_uniq = array_unique($dua); // foreach ($array_nilai_uniq as $key => $val1) { // # code... // print_r($key); // die(); // // $this->conn_esm()->CreateCommand() // // ->batchInsert('c0002scdl_plan_group', ['SCDL_GROUP','TGL_START'], [ // // [$val1['custId'],$val1['tg']] // // ])->execute(); // } return $this->redirect(['index']); }