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