public function actionGetPricesForAProduct() { $postedData = $this->getPostedData(); $id = $postedData['Productprice_id']; $rowsql = "select invno from productprices where id=$id"; $invno = Yii::app()->db->createCommand( $rowsql )->queryScalar(); $condition = 'invno='.'"'.$invno.'"'; $criteria = new CDbCriteria; $criteria->condition = $condition; $record = Productprice::model()->findAll( $criteria ); $json = new CArJSON; $relations = array('supplier'); // array('product') or array(array('product'=>array('taxrate'))) $attributes = array( 'root' => array(),//null,//array of attribute names 'supplier' => array('id','lookupDisplay'),//null,//array of attribute names ); $isarray = true; $product = $json->toJSON($record, $relations, $attributes, $isarray); // return true; if(empty($product)) { return false; } else{ $RetCode ='success'; return $this->returnJsonResponse($RetCode , $product , 'Success'); } }
public function actionGetPricesForAProduct() { $postedData = $this->getPostedData(); $product_id = $postedData['product_id']; $criteria=new CDbCriteria; $criteria->addCondition('status = 1'); $data = Product::model()->findByPk($product_id, $criteria); if(!empty($data)) { $json = new CArJSON; $relations = array(array('subproductprices'=>array('supplier'))); $attributes = array( 'root' => array('id','name'),//null,//array of attribute names 'subproductprices'=> array(), 'supplier' => array('id','lookupDisplay'),//null,//array of attribute names ); $isarray = true; $data = $json->toJSON($data, $relations, $attributes, $isarray); $rtnCode = Helper::CONST_Error_None; $message = Helper::CONST_PRDPRICES_LIST; } else { $rtnCode = Helper::CONST_Error_None; $message = Helper::CONST_NotFound_Message; } $this->returnJsonResponse($rtnCode, $data, $message); }
public function actionGetOrderProductsForABill() { $postedData = $this->getPostedData(); $qoi_id = $postedData['billnumber']; $criteria=new CDbCriteria; $criteria->with = array('statusmaster'); $criteria->compare('LCASE(qoi_id)',strtolower($qoi_id)); $stsary = array( strtolower(Helper::CONST_REFUNDOLD), strtolower(Helper::CONST_REFUNDNEW), strtolower(Helper::CONST_CANCELOLD), strtolower(Helper::CONST_CANCELNEW) ); $criteria->addNotInCondition('LCASE(statusmaster.name)', $stsary); $data = Order::model()->findAll($criteria); if(!empty($data)) { $json = new CArJSON; // Define which relations do you want to load //$relations = array('product'); $relations = array(array('orderproducts'=>array('productprice'))); // array('product') or array(array('product'=>array('taxrate'))) // Define which attributes, foreach relations do you want to load // root denote attributes for the main model $attributes = array( 'root' => array('id','disc','roundoff'),//null,//array of attribute names 'orderproducts'=> array(), 'productprice' => $this->prdcolumns, //'taxrate' => array(), ); $isarray = true; $data = $json->toJSON($data, $relations, $attributes, $isarray); $rtnCode = Helper::CONST_Error_None; $message = Helper::CONST_ORDERPRD_LIST; } else { $rtnCode = Helper::CONST_Error_None; $message = Helper::CONST_NotFound_Message; } //$edata = $this->getJsonOfData($rtnCode, $data, $message); //$this->writeToCookie(Helper::CONST_orderproducts, $edata); $this->returnJsonResponse($rtnCode, $data, $message); }
public function actionJobs() { $result = null; try { $orderstatus = Helper::CONST_ExceptOpenRejected; $forthedate = (!empty($postedData['slotdate'])?$postedData['slotdate']:null); $result = $this->getMyOrders($orderstatus, $forthedate); if(!empty($result)) { $json = new CArJSON; // Define which relations do you want to load $relations = array('ordrcustomers', 'blngaddresses', 'shpngaddresses', 'ordrreceivers' , 'statusmaster'); // Define which attributes, foreach relations do you want to load // root denote attributes for the main model $attributes = array( 'root' => array('id', 'type', 'qoi_id', 'name', 'desc' , 'addnlinfo', 'addnlinfo1', 'addnlinfo3', 'addnlinfo4', 'remarks','status'), 'ordrcustomers' => array('id', 'name', 'firstname', 'lastname', 'mobile'), 'blngaddresses' => array( 'id', 'street', 'pincode' ), 'shpngaddresses' => array( 'id', 'street', 'pincode' ), 'ordrreceivers' => array( 'name', 'mobile' ), 'statusmaster' => array( 'display'), ); //blngaddresses shpngaddresses ordrcustomers ordrreceivers $isarray = true; $data = $json->toJSON($result, $relations, $attributes, $isarray); $rtnCode = Helper::CONST_Error_None; $message = Helper::CONST_ORDER_LIST; $this->returnJsonResponse($rtnCode, $data, $message); } } catch(Exception $e) { $result = null; } $rtnCode = Helper::CONST_InternalServerError; $message = Helper::CONST_ORDER_FETCH_FAIL; $data = array(); $this->returnJsonResponse($rtnCode, $data, $message); }