/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model=Milestone::model()->findByPk($id); if($model===null) throw new CHttpException(404,'The requested page does not exist.'); return $model; }
public function getMSTaskChartData($id) { $criteria=new CDbCriteria; $criteria->order='details asc'; $criteria->compare('LCASE(order_id)',strtolower($id),true); $milestones = Milestone::model()->findAll($criteria); $chartData = array(); // $chartRow = array('Ms/Task','Details','Start','End'); // $chartData[] = $chartRow; $chartRow = array(); $dateformat = Yii::app()->controller->datetimemysqlformatDMY; foreach($milestones as $milestone) { $start_at = Yii::app()->controller->getMysqlFormattedDatetime($milestone->start_at, $dateformat, false); //$end_at = Yii::app()->controller->getMysqlFormattedDatetime($milestone->end_at, $dateformat, false); $chartRow[] = $milestone->details; $info = $start_at; $chartRow[] = $info;//this info field. $chartRow[] = $start_at; $chartRow[] = $start_at; $chartData[] = $chartRow; $chartRow = array(); } $criteria=new CDbCriteria; $criteria->with = array('task'); $criteria->order='task.name asc'; $criteria->compare('LCASE(t.order_id)',strtolower($id),true); $ordertasks = Ordertask::model()->findAll($criteria); foreach($ordertasks as $ordertask) { $completed = $ordertask->completed; $start_at = Yii::app()->controller->getMysqlFormattedDatetime($ordertask->start_at, $dateformat, false); $end_at = Yii::app()->controller->getMysqlFormattedDatetime($ordertask->end_at, $dateformat, false); if($start_at === $end_at) { $datetime = new DateTime($ordertask->start_at); $datetime->modify('+24 hour'); $end_at = $datetime->format($dateformat); } $info = ' [ ' . $completed . '% ] '. $start_at . ' - ' . $end_at; $chartRow[] = $ordertask->task->name; $chartRow[] = $info;//this info field. $chartRow[] = $start_at; $chartRow[] = $end_at; $chartData[] = $chartRow; $chartRow = array(); } // $datetime = new DateTime('today'); // $datestr = $datetime->format($this->datetimemysqlformatDMY); // $low = $datestr; // $datetime->modify('+2 day'); // $datestr = $datetime->format($this->datetimemysqlformatDMY); // $high = $datestr; // ["testms1", // 0, // Object { date="2014-08-21 00:00:00", timezone_type=3, // timezone="Singapore"}, Object { date="2014-08-21 00:00:00", timezone_type=3, // timezone="Singapore"} // ] // $chartData = array(); // $chartRow = array(); // $chartRow[] = 'MS-1'; // $chartRow[] = $low; // $chartRow[] = $low; // $chartData[] = $chartRow; // $chartRow = array(); // $chartRow[] = 'MS-2'; // $chartRow[] = $low; // $chartRow[] = $high; // $chartData[] = $chartRow; return $chartData; }