// LEFT JOIN t0001header th on ti.KD_RIB = th.KD_RIB
// LEFT JOIN c0006 c on ti.ID_INVEST = c.ID
// WHERE ti.TERM_ID ='".$model->TERM_ID."'
// AND ti.ID_INVEST ='".$model->INVES_ID."'
// AND ti.STATUS = 102
// AND (ti.KD_RIB LIKE 'RID%' OR ti.KD_RIB LIKE 'RI%')";
// $sql = "SELECT c.INVES_TYPE,ti.PERIODE_START,ti.PERIODE_END,ti.PPN,ti.PPH23,ti.HARGA,ti.INVESTASI_PROGRAM FROM `t0001detail` ti
// LEFT JOIN t0001header th on ti.KD_RIB = th.KD_RIB
// LEFT JOIN c0006 c on ti.ID_INVEST = c.ID
// WHERE ti.TERM_ID ='".$model->TERM_ID."'
// AND ti.ID_INVEST ='".$model->INVES_ID."'
// AND ti.STATUS = 102
// AND (ti.KD_RIB LIKE 'RID%' OR ti.KD_RIB LIKE 'RI%')";
// $hasil = $connect->createCommand($sql)->queryAll();
$searchModel_inves = new RtdetailSearch();
$dataProviderBudgetdetail_inves = $searchModel_inves->searchInvest(Yii::$app->request->queryParams, $model->TERM_ID, $model->INVES_ID);
// $dataProviderBudgetdetail_inves = new ArrayDataProvider([
// 'allModels' => $hasil,
// 'pagination' => [
// 'pageSize' => 10,
// ],
// ]);
/* reviewDataexpandActual || budget_actual */
$sql2 = "SELECT c.INVES_TYPE,ti.PERIODE_START,ti.PERIODE_END,ti.PPN,ti.PPH23,ti.HARGA FROM t0001detail ti\n\t\t\t\t\tLEFT JOIN c0006 c on ti.ID_INVEST = c.ID\n\t\t\t\t\tLEFT JOIN t0001header th on ti.KD_RIB = th.KD_RIB\n\t\t\t\t\tWHERE ti.TERM_ID ='" . $model->TERM_ID . "'\n\t\t\t\t\tAND ti.ID_INVEST ='" . $model->INVES_ID . "'\n\t\t\t\t\tAND ti.STATUS = 102\n\t\t\t\t\tAND (ti.KD_RIB LIKE 'RA%' OR ti.KD_RIB LIKE 'RB%')";
$hasil1 = $connect->createCommand($sql2)->queryAll();
$dataProviderBudgetdetail = new ArrayDataProvider(['allModels' => $hasil1, 'pagination' => ['pageSize' => 10]]);
/*render*/
return Yii::$app->controller->renderPartial('_reviewDataExpand', ['dataProviderBudgetdetail' => $dataProviderBudgetdetail, 'dataProviderBudgetdetail_inves' => $dataProviderBudgetdetail_inves, 'dataProviderBudget' => $dataProviderBudget, 'searchModel_inves' => $searchModel_inves, 'id' => $model->ID]);
}, 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '9pt', 'background-color' => 'rgba(74, 206, 231, 1)']], 'contentOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'height' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '9pt', 'background-color' => 'rgba(231, 183, 108, 0.2)']]];
/*GRIDVIEW ARRAY ACTION*/
/* $actionClass='btn btn-info btn-xs';
