public function actionDispatchNoWise() { $this->layout = ""; $challan = new Challan(); $sent = array(); $failed = array(); if (!empty($_POST['dispatch'])) { foreach ($_POST['dispatch']['chk'] as $k => $m) { $challan = Challan::model()->with('placeOfOffence')->findByPk($m); $dispatch = new Dispatch(); $dispatch->user_id = Yii::app()->user->id; $dispatch->created = date("Y-m-d H:i:s", time()); $dispatch->challan_id = $m; $dispatch->status = "Dispatched to CJM"; $dispatch->status_id = 3; $dispatch->message = $_POST['dispatch']['message']; $dispatch->court_id = $challan->placeOfOffence->court_id; if ($dispatch->save()) { $sent[] = $challan->id; $challan = Challan::model()->with('placeOfOffence')->findByPk($m); $challan->status_id = 3; $challan->save(); } else { $failed[] = $challan->id; } } Yii::app()->user->setFlash('success1 message1', "Dispatch of following challan(s) was successful"); return $this->render('dispatchReport', array('model' => new Challan(), 'challan' => $challan, 'sent' => $sent, 'failed' => $failed)); } else { $days_ago = date('Y-m-d', strtotime('-1 days', time())); //$challan = Challan::model()->with('placeOfOffence')->findAllByAttributes('status_id = 1 and date_time_offence < "'.$days_ago.'"'); $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status_id = 1 and vehicle_impounded = 1 and date_time_offence < "' . $days_ago . '"'; $criteria->order = "date_time_offence DESC"; $challan = Challan::model()->findAll($criteria); return $this->render('dispatchNoWise', array('model' => new Challan(), 'challan' => $challan)); } return $this->render('dispatchNoWise', array('model' => new Challan(), 'challan' => $challan)); }