public static function findAll($fromDate, $toDate, $periodFrom, $periodTo, $start, $limit, $page, $filters = array())
{
//criteria simple.
$criteria = new CDbCriteria();
$criteria->order = 'Code ASC';
foreach ($filters as $col => $val) {
$criteria->addInCondition($col, $val);
}
//error_log("findAll($fromDate, $toDate, $periodFrom, $periodTo, $start, $limit, $page, $filters=array())");
$dataProvider = new CActiveDataProvider('Item', array('criteria' => $criteria, 'pagination' => array('pageSize' => $limit, 'currentPage' => $page)));
$Items = $dataProvider->getData(true);
$totalCount = $dataProvider->pagination->getItemCount();
// Calculate Items Statistics
$reqDet = RequestDetail::getItemDetails($Items, $fromDate, $toDate, $periodFrom, $periodTo);
return array("orderlist" => $reqDet, "totalCount" => $totalCount);
}
/**
* Creates a new RequestDetail.
**/
public function actionJsonCreate()
{
$params = CJSON::decode($GLOBALS['HTTP_RAW_POST_DATA']);
$ok = true;
foreach ($params['details'] as $p) {
$model = new RequestDetail();
$model->attributes = $p;
$model->item_id = $p['item']['id'];
$model->request_id = $params['request_id'];
if (!$model->save()) {
$ok = false;
}
}
if ($ok) {
echo "{success: true}";
} else {
echo "{success: false}";
}
}
