public function save(OrderData $orderData) { $stmt = $this->pdo->prepare("INSERT INTO `Order` " . "(`OrderNumber`, `TotalAmount`) " . "VALUES (:OrderNumber, :TotalAmount)"); $result = $stmt->execute(array(':OrderNumber' => $orderData->getOrderNumber(), ':TotalAmount' => $orderData->getTotalAmount())); // var_dump(result); return $result; }
public function AddProduct() { // - Creates a Product identified by SKU with a Stock and available quantity of Qty $piece1 = '('; $piece2 = ''; if (isset($SKU)) { $piece1 .= 'ProductSKU,'; $piece2 .= "'" . $this->SKU . "'"; $piece2 .= ','; } else { echo " \n Error: SKU Field Empty \n "; return false; } $productTable = 'Products'; $productPiece = " (SKU) VALUES ('" . $this->SKU . "')"; $productResults = OrderData::InsertData($productTable, $productPiece); if ($productResults === false) { return false; } if (isset($Qty)) { $piece1 .= 'TotalAMT,'; $piece2 .= "" . $this->initialquantityStock . ""; $piece2 .= ','; } else { echo " \n Error: Quantity Field Empty \n "; return false; } $piece1 .= 'CommittedAMT,'; $piece2 .= $this->committedStock . ','; $piece1 .= 'AvailableAMT'; $piece2 .= $this->availableStock . ')'; $piece1 .= ') VALUES ('; $inventoryPiece = $piece1 . $piece2; $inventoryTable = 'Inventory'; $productPiece = " (SKU) VALUES ('" . $this->SKU . "')"; $inventoryResults = OrderData::InsertData($inventoryTable, $inventoryPiece); if ($inventoryResults === false) { return false; } return true; }
/** * 我的订单 */ public function orderAction() { $pageSize = 20; $curPage = intval($this->param('p', 1)); $curPage = $curPage < 1 ? 1 : $curPage; $curUser = $this->getCurrentUser(); $where = "user_id='{$curUser['id']}' and status='1'"; $totalItems = OrderData::count($where); $list = array(); if ($totalItems) { $totalPages = ceil($totalItems / $pageSize); $curPage = $curPage > $totalPages ? $totalPages : $curPage; $start = $pageSize * ($curPage - 1); $sql = "select * from `order` where {$where} order by create_time desc limit {$start},{$pageSize}"; $list = OrderData::sql($sql); if ($list) { $pageHtml = ComTool::pageHtml($curPage, $pageSize, $totalItems, $this->urlroot . 'my/order/p'); } } $this->assign('list', $list); $this->assign('pageHtml', $pageHtml); $this->display(); }
public function afterSave() { if ($this->order_id) { $orderDataModel = new OrderData(); $orderDataModel->order_id = $this->order_id; $orderDataModel->save(false); } }
<?php /** Author(s): Louis Taylor * Creation date: 12/23/2015 */ header('Content-type: text/plain; charset=utf-8'); $IDDir = dirname(__FILE__); include_once $IDDir . "/OrderData.php"; $Amt = -8; $Field = 'AvailableAMT'; $product = 'TSHIRT1−SM'; //$product = utf8_encode($product); //$product = 'TSHIRT1%E2%88%92SM'; $product = urlencode($product); //$obj = DBConn::OpenDB(); OrderData::Update_inventory($Field, $Amt, $product); //print_r($obj);
/** * 删除订单 */ public function delAction() { if (ComTool::isAjax()) { if (!$this->isLogin()) { ComTool::ajax(Cola::getConfig('_error.mustlogin'), '请先登录,即将跳转至登录页面'); } $currUser = $this->getCurrentUser(); $orderId = $this->post('oid', ''); if (!$orderId) { ComTool::ajax(100001, '未知订单'); } $orderId = ComTool::escape($orderId); $updateTime = time(); $sql = "update `order` set `status`=4,update_time='{$updateTime}' where id='{$orderId}' and user_id='{$currUser['id']}'"; $res = OrderData::sql($sql); if ($res === false) { ComTool::ajax(100001, '服务器忙,请重试'); } //暂时不删除订单详情(order_detail表) ComTool::ajax(100000, 'ok'); } }
<?php require_once dirname(__FILE__) . "/../../TransactionsApiClient.class.php"; require_once dirname(__FILE__) . "/../config.php"; $client = new TransactionsApiClient(INVIPAY_API_URL, INVIPAY_API_KEY, INVIPAY_SIGNATURE_KEY, INVIPAY_PARTNER_API_KEY, INVIPAY_PARTNER_SIGNATURE_KEY); Logger::info('Creating new order'); $request = new OrderData(); $request->setDocumentNumber('Test/' . uniqid()); $request->setIssueDate(date('Y-m-d', time())); $request->setPriceGross(123); $request->setCurrency('PLN'); $request->setNote('Test transaction from API'); $request->setNoRisk(true); $contractor = new Contractor(); $contractor->setName('Test contractor ' . uniqid()); $contractor->setTaxPayerNumber('8429067910'); $contractor->setEmail('*****@*****.**'); $contractor->setFax('12312123'); $contractor->setPhone('234234234'); $contractor->setWww('www.esr24.pl'); $contractorAccount = new BankAccount(); $contractorAccount->setBankName('Test bank'); $contractorAccount->setNumber('PL123123123123123123123'); $contractor->setAccount($contractorAccount); $contractorAddress = new AddressData(); $contractorAddress->setStreet('Test street 1/2'); $contractorAddress->setCity('Testville'); $contractorAddress->setPostCode('00-111'); $contractorAddress->setCountryCode('PL'); $contractor->setAddress($contractorAddress); $request->setContractor($contractor);
private function saveBankData($object) { $orderDataModel = new OrderData(); $orderDataModel->order_id = $this->orderModel->order_id; $orderDataModel->IsNewRecord = false; $change = false; foreach (self::$_responseBankFields as $bankField => $modelField) { $bankField = strtoupper($bankField); $fullModelField = 'ps_' . $modelField; if (is_object($object)) { if ($object->{$bankField}) { $orderDataModel->{$fullModelField} = (string) $object->{$bankField}; $change = true; } } elseif (is_array($object)) { if (isset($object[$bankField]) && $object[$bankField]) { $orderDataModel->{$fullModelField} = (string) $object[$bankField]; $change = true; } } } if ($change) { $orderDataModel->save(); } }
public function validSend($data) { require_once DIR_SYSTEM . 'library/stelo/Stelo.php'; $this->load->model('account/customer'); $this->load->model('checkout/order'); $customer = $this->model_account_customer->getCustomer($data['customer_id']); $order_total = $this->model_checkout_order->getOrderTotal($this->session->data['order_id'], 'shipping'); $params = array(); $converter = new Converter(); //OrderData $orderData = new OrderData(); $orderData->setOrderId((string) $this->session->data['order_id']); $params['orderData'] = $converter->convertOrderData($orderData); //PaymentData $paymentData = new PaymentData(); $paymentData->setAmount((double) number_format($data['total'], 2, '.', '')); $paymentData->setDiscountAmount(''); $paymentData->setFreight((double) number_format($order_total['value'], 2, '.', '')); $paymentData->setMaxInstallment('4'); // CartData if ($this->cart->getProducts()) { foreach ($this->cart->getProducts() as $product) { $cartData = new CartDataCollection(); $cartData->setProductName($product['name']); $cartData->setProductPrice((double) number_format($product['price'], 2, '.', '')); $cartData->setProductQuantity($product['quantity']); $cartData->setProductSku(substr($product['model'], 0, 19)); $paymentData->setCartData($cartData); } } $params['paymentData'] = $converter->convertPaymentData($paymentData); //CustomerData $customerData = new CustomerData(); $customerData->setCustomerIdentity(str_replace('/', '', str_replace('-', '', str_replace('.', '', $data['cpf_cnpj'])))); $customerData->setCustomerName($data['firstname'] . ' ' . $data['lastname']); $customerData->setCustomerEmail($data['email']); $customerData->setBirthDay($customer['birthday']); $customerData->setGender($customer['sex']); // Billing Address $billingAddress = new BillingAddress(); $billingAddress->setStreet($data['payment_address_1']); $billingAddress->setNumber($data['payment_number_home']); $billingAddress->setComplement($data['payment_address_2']); $billingAddress->setNeighborhood($data['payment_neighborhood']); $billingAddress->setZipcode($data['payment_postcode']); $billingAddress->setCity($data['payment_city']); $billingAddress->setState($data['payment_zone_code']); $customerData->setBillingAddress($billingAddress); // Shipping Address $shippingAddress = new ShippingAddress(); $shippingAddress->setStreet($data['shipping_address_1']); $shippingAddress->setNumber($data['shipping_number_home']); $shippingAddress->setComplement($data['shipping_address_2']); $shippingAddress->setNeighborhood($data['shipping_neighborhood']); $shippingAddress->setZipcode($data['shipping_postcode']); $shippingAddress->setCity($data['shipping_city']); $shippingAddress->setState($data['shipping_zone_code']); $customerData->setShippingAddress($shippingAddress); // Phone Data $phoneData = new PhoneDataCollection(); $phoneData->setPhoneType("CELL"); $phoneData->setNumber(str_replace('(', '', str_replace(')', '', str_replace('-', '', str_replace(' ', '', $data['cellphone']))))); $customerData->setPhoneData($phoneData); $params['customerData'] = $converter->convertCustomerData($customerData); $params['changeShipment'] = false; //$url = 'http://200.142.203.223/ec/V1/wallet/transactions'; //Homologação $url = 'http://api.stelo.com.br/ec/V1/wallet/transactions'; $stelo = new Stelo(); $response = $stelo->sendRequest($url, $this->config->get('stelo_client_id'), $this->config->get('stelo_client_secret'), $params); $insert = "INSERT INTO " . DB_PREFIX . "transaction_stelo SET order_id = '" . $this->session->data['order_id'] . "', json_encode = '" . json_encode($params) . "', "; if ($response) { $insert .= "link_confirm = '" . $response['link'][0]['@href'] . "', link_cancel = '" . $response['link'][1]['@href'] . "', link_wallet = '" . $response['link'][2]['@href'] . "', order_stelo_id = '" . $response['orderData']['orderId'] . "', "; } $insert .= "date_added = NOW()"; $this->db->query($insert); return true; }