/**
* 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;
}
