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); }