function parseFile($filename) { //@todo: это не красиво :( ini_set('max_execution_time', 300); //ini_set('memory_limit', '512M'); $uri = WDCPREFIX_LOCAL . '/reserves/factura/' . $filename; $list = array(); $ids = array(); $handle = fopen($uri, 'r'); while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) { if ($data[0] == 'order_id' || count($data) != 7) { continue; } //order_id;sf_num;sf_date;sf_summa;pp_num;pp_date;pp_type $res = array('id' => getOrderId($data[0]), 'sf_num' => $data[1], 'sf_date' => $data[2], 'sf_summa' => $data[3], 'pp_num' => $data[4], 'pp_date' => $data[5], 'pp_type' => $data[6]); $ids[] = $res['id']; $list[] = $res; } fclose($handle); //print_r($list); if ($list) { $reserveModel = ReservesModelFactory::getInstance(ReservesModelFactory::TYPE_TSERVICE_ORDER); $empData = $reserveModel->getEmpByReserveIds($ids); print_r($empData); /* foreach ($list as $data) { if (!isset($empData[$data['id']])) { continue; } $data['employer']['login'] = $empData[$data['id']]['login']; $data['employer']['uid'] = $empData[$data['id']]['uid']; try { $doc = new DocGenReserves($data); $doc->generateFactura(); } catch (Exception $e) { require_once($_SERVER['DOCUMENT_ROOT'] . '/classes/log.php'); $log = new log('reserves_docs/' . SERVER . '-%d%m%Y.log'); $log->trace(sprintf("Order Id = %s: %s", $data['id'], $e->getMessage())); } } */ } }
$xOrderId = handleOrderInsertion($transactionId, $paymentSecret, $paymentMethod, $xCustomerId); if (!$xOrderId) { exit('Error: No orderId found.'); } } $configuration = getPaymentModuleConfiguration(); if ($paymentMethod == 'sr') { // Rechnung by Sofort $srOrderStatusArr = array('unconfirmed' => getStatusId($configuration['MODULE_PAYMENT_SOFORT_SR_UNCONFIRMED_STATUS_ID']), 'confirmed' => getStatusId($configuration['MODULE_PAYMENT_SOFORT_SR_ORDER_STATUS_ID']), 'cancelled' => getStatusId($configuration['MODULE_PAYMENT_SOFORT_SR_CANCEL_STATUS_ID']), 'check' => getStatusId($configuration['MODULE_PAYMENT_SOFORT_MULTIPAY_CHECK_STATUS_ID'])); $PnagInvoice = new PnagInvoice(MODULE_PAYMENT_SOFORT_MULTIPAY_APIKEY, $transactionId); if ($PnagInvoice->isError()) { $errors = $PnagInvoice->getErrors(); echo MODULE_PAYMENT_SOFORT_ERROR_TERMINATED . ' - ' . print_r($errors, true); exit; } $orderId = getOrderId($transactionId); $lastOrderStatus = getLastOrderStatus($orderId); $completeInvoiceStatus = $PnagInvoice->getState(); $newTotal = checkIfNewTotal($PnagInvoice, $orderId); $newComments = ''; // Update the order-status switch ($completeInvoiceStatus) { case PnagInvoice::PENDING_CONFIRM_INVOICE: updateShopAdresses($SofortLib_TransactionData->getInvoiceAddress(), $SofortLib_TransactionData->getShippingAddress(), $orderId); $historyComments = getHistoryComments($completeInvoiceStatus, $transactionId); $newComments = updateOrderStatus($PnagInvoice, $orderId, $srOrderStatusArr['unconfirmed'], $historyComments['customer'], $time, $newTotal); break; case PnagInvoice::PENDING_NOT_CREDITED_YET_PENDING: //refunded invoice was just reanimated if (refundedInvoiceWasJustReanimated($orderId, $PnagInvoice->getStatus())) { $newComments = updateOrderStatus($PnagInvoice, $orderId, $srOrderStatusArr['confirmed'], MODULE_PAYMENT_SOFORT_SR_TRANSLATE_INVOICE_REANIMATED, $time, false, true);
$sql = $dbconn->execute($sql); $num = $dbconn->fetch_one($sql); if ($num['num'] > 0) { $sql = "update ph_order set is_delete=0 where recordnumber='{$item['io_ordersn']}'"; $dbconn->execute($sql); echo "\n"; echo $item['io_ordersn'] . "\n"; } else { $sql = "INSERT INTO `ph_order`( `recordnumber`, `addtime`, `aduittime`, `status`, `order_type`, `purchaseuser_id`, `aduituser_id`, `partner_id`, `paymethod`, `paystatus`) VALUES ('{$item['io_ordersn']}','{$item['io_addtime']}','{$item['io_audittime']}','{$status}','{$item['io_type']}','{$purchaseuse_id}','{$aduituser_id}','{$partnerId}','{$item['io_paymentmethod']}','{$item['paystatus']}')"; echo "#############\n"; if ($dbconn->execute($sql)) { $sql = "select * from ebay_iostoredetail where io_ordersn='{$item['io_ordersn']}'"; $sql = $dbconn->execute($sql); $orderInfodetail = $dbconn->getResultArray($sql); foreach ($orderInfodetail as $item) { $po_id = getOrderId($item['io_ordersn']); if (isset($po_id)) { $sql = "INSERT INTO `ph_order_detail`(`po_id`, `sku`, `price`, `count`, `stockqty`, `ungoodqty`, `goods_recommend_count`) VALUES ({$po_id},'{$item['goods_sn']}','{$item['goods_cost']}','{$item['goods_count']}','{$item['stockqty']}','0','{$item['goods_recommend_count']}')"; if ($dbconn->execute($sql)) { echo "{$sql}\n"; echo "添加数据成功。。。。\n"; } } } } } } /* $sql = "SELECT count(*) as totalNum FROM `ebay_iostoredetail` WHERE 1"; $sql = $dbconn->execute($sql);
extract($_SESSION['ship']); // validate post section $card_number = $_POST['card_number']; $card_PID = $_POST['card_PID']; $card_expire = strtotime($_POST['card_expire']); $card_owner = $_POST['card_owner']; // find customer $customerid = getCustomerId($name, $address, $city, $zip_code, $country); if ($customerid == null) { // insert customer into database and return customerid $customerid = setCustomerId($name, $address, $city, $zip_code, $country); } $date = date("Y-m-d H:i:s"); insertIntoOrder($conn, $customerid, $_SESSION['total_price'], $date, $name, $address, $city, $zip_code, $country); // take orderid from order to insert order items $orderid = getOrderId($conn, $customerid); foreach ($_SESSION['cart'] as $isbn => $qty) { $bookprice = getbookprice($isbn); $query = "INSERT INTO order_items VALUES \n\t\t('{$orderid}', '{$isbn}', '{$bookprice}', '{$qty}')"; $result = mysqli_query($conn, $query); if (!$result) { echo "Insert value false!" . mysqli_error($conn2); exit; } } session_unset(); ?> <p class="lead text-success">Your order has been processed sucessfully. Please check your email to get your order confirmation and shipping detail!. Your cart has been empty.</p> <?php
function getTooltip($acc_id) { global $con; $order_id = getOrderId($acc_id); $totalprice = calculateTotalePrice($order_id, $acc_id); $sql = "SELECT * FROM orderDetails WHERE details_accountid = {$acc_id} AND details_orderid = {$order_id}"; $run_data = mysqli_query($con, $sql); $rowcount = mysqli_num_rows($run_data); if ($rowcount == 1) { return "{$rowcount} product, worth {$totalprice} €"; } else { return "{$rowcount} products, worth {$totalprice} €"; } }