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