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);
}
/**
* Return de Details about an Order
**/
public function actionGetDetail($id)
{
$return = array();
if ($id != '') {
$request = Request::model()->findByPk($id);
$models = OrderDetail::model()->findAll('request_id=:request_id', array(':request_id' => $id));
foreach ($models as $item) {
$temp['StockTime'] = $item->StockTime;
$temp['ShipTime'] = $item->ShipTime;
$temp['ManualQty'] = $item->ManualQty;
$Items[] = Item::model()->findByPk($item->item_id);
$params[] = $temp;
}
$reqDet = RequestDetail::getItemDetails($Items, $request->P1Start, $request->P1End, $request->P2Start, $request->P2End, $params);
$return['success'] = true;
// Agregar aca los mismos criterios de busqueda que se apliquen a findAll
$return['totalCount'] = count($reqDet);
//$models["totalCount"]; //Item::model()->count();//$criteria
$return['orderDetails'] = $reqDet;
} else {
$return['success'] = false;
$return['totalCount'] = 0;
//$models["totalCount"]; //Item::model()->count();//$criteria
$return['orderDetails'] = array();
}
echo CJSON::encode($return);
}
