private function saveOrder($jsonArray = null) { if (is_array($jsonArray) && isset($jsonArray['usr']) && isset($jsonArray['cart'])) { $order = new OrderModel(); $usr = $jsonArray['usr']; $cart = $jsonArray['cart']; // echo '<pre>';print_R($cart);die; // add checks here before saving order $order->setBfname($usr['fname']); $order->setBlname($usr['lname']); $order->setBemail($usr['email']); $order->setBaddressl1($usr['addr1']); $order->setBaddressl2($usr['addr2']); $order->setBaddressl3($usr['addr3']); $order->setBcity($usr['city']); $order->setBcountry($usr['country']); $order->setBstate($usr['state']); $order->setBzipcode($usr['zipcode']); $order->setInserttime(date("Y-m-d H:i:s")); $order->setSfname($usr['sfname']); $order->setSlname($usr['slname']); $order->setSemail($usr['semail']); $order->setSaddressl1($usr['saddr1']); $order->setSaddressl2($usr['saddr2']); $order->setSaddressl3($usr['saddr3']); $order->setScity($usr['scity']); $order->setScountry($usr['scountry']); $order->setSstate($usr['sstate']); $order->setStatus("pending"); $order->setSubtotal($cart['subTotal']); $order->setSzipcode($usr['szipcode']); $order->setDiscount($cart['discount']); $order->setTotal($cart['total']); $order->setQty($cart['qty']); $order->setOrder_type(strtoupper($usr['ordertype'])); $order->setUserid(Session::getInstance()->getSess("userid")); $order->insert(); if ($order->isSuccess() == 1) { $oid = $order->getOrderid(); foreach ($cart['items'] as $k => $itm) { $item = new OrderProdsModel(); $item->setOid($oid); $item->setTid($itm['template']); $item->setPid($itm['product']); $item->setPrice($itm['price']); $item->setQty($itm['qty']); $item->setTotal($itm['total']); $item->insert(); $this->moveTemplate($itm['template']); // converts file urls from temp dir to final destination dir } if ($cart['disId'] != 0) { $du = new DiscountUserModel(); $du->setDiscountId($cart['disId']); $du->setUserId(Session::getInstance()->getSess("userid")); $du->insert(); if ($cart['discountFor'] == 1) { $dis = new DiscountModel(); $dis->setDiscountid($cart['disId']); $dis->setStatus(1); $dis->update_status(); } } if ($usr['ordertype'] == 'cod') { $this->cod_order($oid, $usr, $cart['total']); } $oc = new OrderController(); ob_start(); $oc->printinvoice($oid); $html = ob_get_clean(); if ($usr['ordertype'] != 'payment') { Session::getInstance()->setMessage("Order accepted.", "green"); Session::getInstance()->removeSess('cart'); } mail($usr['email'], "Order Confirmation", $html, "Content-type: text/html; charset=iso-8859-1 \r\nFrom: noreply@snooky.com\r\n"); echo $oid; } else { Session::getInstance()->setMessage("Problem in accepting order, please try again.", "red"); echo "failed"; } } }
$ao = new OrderAO(); //$a=new ConsistentHash($sc_refund_info_multiple_dbroute_config); //$a->explodeString(); // //for($i=0;$i<1024;$i++){ // $db=$a->getDbName($i); // $t=$a->getTableName($i); // echo $i.'=>'.$db."=>$t<br>"; //} //die; $ao->testTransaction(10); //die; $order = new OrderModel(); print_r($order->transactionTest()); //die; $id = $order->insert(); echo "insert<br>"; print_r($id); $result = $order->update(34084, 10); echo "update<br>"; print_r($result); $cityModel = new CityModel(); //print_r($cityModel->getAllCity()); //die; $mop = new cls_sequence(); //$num=$mop->nextValue('user'); //echo $num."<br>"; //die; $id = $order->insert(); echo "insert<br>"; print_r($id);