public function getPurchaeOrderAction() { $post = $this->getRequest()->getPost(); if ($post) { $db = new Application_Model_DbTable_DbGlobal(); $getorder = new purchase_Model_DbTable_DbPurchaseAdvance(); $data_staust = array('status' => 3); $db->updateRecord($data_staust, $post['purchase_order'], "order_id", "tb_purchase_order"); $rows = $getorder->getStatusOrder($post['purchase_order']); //for update status in purchase order history if ($rows) { foreach ($rows as $order) { $db->updateRecord($data_staust, $order["history_id"], "history_id", "tb_order_history"); //must update status too } } $check_purchase_tmp = new purchase_Model_DbTable_DbAdvance(); $exist = $check_purchase_tmp->purchaseTMPExist($post); if (!$exist) { $sql_insert = "INSERT INTO tb_purchase_order_item_tmp\n\t\t\t\t\t\t\tSELECT id,order_id,pro_id, sum(qty_order) as qty_order\n\t\t\t\t\t\t\tFROM tb_purchase_order_item WHERE order_id = " . $post['purchase_order'] . " GROUP BY pro_id"; $db->query($sql_insert); //b4 for //after insert get it againt for check condition $result = $getorder->getPurchaseOrderExist($post); } else { $result = $getorder->getPurchaseOrderExist($post); //can select already } } echo Zend_Json::encode($result); exit; }