public function getScdlPlan() { // $ary_scdlplan = DraftPlanDetail::find()->where(['CUST_ID'=>$this->CUST_KD,'STATUS'=>0])->distinct()->one(); $ary_scdlplan = DraftPlanDetail::find()->where('LEFT(TGL,4) ="' . $this->YEAR . '" AND CUST_ID="' . $this->CUST_KD . '" AND STATUS = 0')->distinct()->one(); return $ary_scdlplan; }
/** * Finds the DraftPlandetail count model based on its CUST_KD value AND STATUS equal 1. * @param string $CUST_KD * @return @var ary_scdlplndetail */ protected function findCountStatus($custId, $tgl) { // $ary_scdlplndetail = DraftPlanDetail::find()->where(['CUST_ID'=>$custId,'STATUS' => 1])->count(); $ary_scdlplndetail = DraftPlanDetail::find()->where('LEFT(TGL,4) ="' . $tgl . '" AND CUST_ID="' . $custId . '" AND STATUS = 1')->count(); return $ary_scdlplndetail; }
public function searchEmpty($params) { $query = DraftPlanDetail::find()->where('STATUS=100'); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 0]]); return $dataProvider; }