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