<?php ini_set('log_errors', 'On'); ini_set('error_log', dirname(__FILE__) . '/php_errors.log'); include "../config.php"; include "../core/function.php"; set_time_limit(1000); //include("../core/lib/SQL.class.php"); include_once '../modules/catsrv/catsrv.properties.php'; include "../modules/catsrv/LibCatsrv.class.php"; chdir(ROOT); $ST = new SQL(DB_HOST, DB_LOGIN, DB_PASSWORD, DB_BASE); $r = $ST->select("SELECT UPPER(name) AS name,value FROM sc_config"); while ($r->next()) { if ($r->get('value')) { $CONFIG[$r->get('name')] = $r->get('value'); } } //echo LibCatsrv::export1c(); echo LibCatsrv::makeYandexYML();
static function export1c() { global $CONFIG, $ST; set_time_limit(1000); $data = array('make_date' => date('Y-m-d'), 'make_time' => date('H:i:s'), 'document' => array()); $date_from = date('Y-m-d'); $date_to = date('Y-m-d', time() + 3600 * 24); if (isset($_GET['d']) && ($t = strtotime($_GET['d']))) { $date_from = date('Y-m-d', $t); $date_to = date('Y-m-d', $t + 3600 * 24); } // if($get->get('date_from')){ // $date_from=$get->get('date_from'); // } // // if($get->get('date_to')){ // $date_to=$get->get('date_to'); // } $q = "SELECT u.*,o.* FROM sc_shop_order o\r\n\t\tLEFT JOIN sc_users AS u ON u.u_id=o.userid\r\n\t\tWHERE \r\n\t\t o.create_time>='{$date_from}' AND o.create_time<='{$date_to}'\r\n\t\t"; $rs = $ST->select($q); while ($rs->next()) { $d = array('id' => $rs->get('id'), 'num' => $rs->get('id'), 'date' => dte($rs->get('create_time'), 'Y-m-d'), 'summ' => $rs->get('total_price'), 'contragent' => array('id' => $rs->get('u_id') . '#' . $rs->get('login') . '#' . $rs->get('fullname') . '#' . $rs->get('phone'), 'name' => $rs->get('type') == 'user_jur' && trim($rs->get('company')) ? $rs->get('company') : $rs->get('fullname'), 'address' => $rs->get('address'), 'mail' => $rs->get('mail')), 'time' => dte($rs->get('create_time'), 'H:i:s'), 'additionally' => $rs->get('additionally'), 'goods' => array()); $q = "SELECT *,ec.id AS ext_cat_id, oi.price AS price \t\r\n\t\t\tFROM sc_shop_order_item AS oi, sc_shop_item AS si\r\n\t\t\tLEFT JOIN sc_shop_srv_extcat AS ec ON ec.lnk=si.category\r\n\t\t\tWHERE\r\n\t\t\t\tsi.id=oi.itemid\r\n\t\t\t\tAND oi.orderid={$rs->get('id')} \r\n\t\t\t\t\r\n\t\t\t"; $q = "SELECT *, oi.price AS price \t\r\n\t\t\tFROM sc_shop_order_item AS oi, sc_shop_item AS si\r\n\t\t\t\r\n\t\t\tWHERE\r\n\t\t\t\tsi.id=oi.itemid\r\n\t\t\t\tAND oi.orderid={$rs->get('id')} "; $rs1 = $ST->select($q); while ($rs1->next()) { $g = array('name' => $rs1->get('name'), 'id' => $rs1->get('ext_id'), 'price' => $rs1->get('price'), 'count' => $rs1->get('count'), 'summ' => $rs1->get('price') * $rs1->get('count')); if ($rs1->get('unit_sale') == 2) { if ($rs1->getInt('pack_size') != 0) { //03.02.2013 $g['count'] *= $rs1->getInt('pack_size'); $g['price'] /= $rs1->getInt('pack_size'); $g['price'] = round($g['price'], 2); } } $d['goods'][] = $g; } $data['document'][] = $d; } $file = ROOT . '/' . CATALOG_EXPORT_DIR . '/' . 'order.xml'; if (isset($_GET['d']) && ($t = strtotime($_GET['d']))) { $file = ROOT . '/' . CATALOG_EXPORT_DIR . '/' . date('Y_m_d', $t) . '.xml'; } $out = '<?xml version="1.0" encoding="windows-1251"?>'; $out .= LibCatsrv::render($data, dirname(__FILE__) . '/order1c.xml.php'); if (isset($_GET['get'])) { return $out; } else { file_put_contents($file, $out); exit; } }
<?php ini_set('log_errors', 'On'); ini_set('error_log', dirname(__FILE__) . '/php_errors.log'); include "../../config.php"; include "../../core/function.php"; set_time_limit(1000); include "../../core/lib/SQL.class.php"; include_once '../../modules/catsrv/catsrv.properties.php'; include "../../modules/catsrv/LibCatsrv.class.php"; chdir(ROOT); $ST = new SQL(DB_HOST, DB_LOGIN, DB_PASSWORD, DB_BASE); $r = $ST->select("SELECT UPPER(name) AS name,value FROM sc_config WHERE name LIKE 'SHOP_SRV%'"); while ($r->next()) { if ($r->get('value')) { $CONFIG[$r->get('name')] = $r->get('value'); } } echo LibCatsrv::export1c(); //LibCatsrv::makeYandexYML();
<?php ini_set('memory_limit', '64M'); ini_set('log_errors', 'On'); ini_set('error_log', dirname(__FILE__) . '/php_errors_imp.log'); include dirname(__FILE__) . "/../../config.php"; include dirname(__FILE__) . "/../../core/function.php"; file_put_contents(dirname(__FILE__) . '/last_start.txt', date('Y-m-d H:i;s') . "\n", FILE_APPEND); ?> Импорт каталога <?php set_time_limit(1000); include dirname(__FILE__) . "/../../core/lib/SQL.class.php"; include_once dirname(__FILE__) . '/../../modules/catsrv/catsrv.properties.php'; include dirname(__FILE__) . "/../../modules/catsrv/LibCatsrv.class.php"; chdir(ROOT); $ST = new SQL(DB_HOST, DB_LOGIN, DB_PASSWORD, DB_BASE); $r = $ST->select("SELECT UPPER(name) AS name,value FROM sc_config WHERE name LIKE 'SHOP_%'"); while ($r->next()) { if ($r->get('value')) { $CONFIG[$r->get('name')] = $r->get('value'); } } //echo LibCatsrv::import1c(); //LibCatsrv::makeYandexYML(); $res = LibCatsrv::import('import', 11); echo print_r($res, true); file_put_contents('import.log', "GET-" . print_r($res, true), FILE_APPEND); //33fecdef-0baa-11e2-bc36-00241d3e9178/7858
function actYML() { global $ST, $post, $CONFIG, $get; include 'LibCatsrv.class.php'; LibCatsrv::makeYandexYML(); }
<?php include_once "../config.php"; include_once "../core/function.php"; file_put_contents(dirname(__FILE__) . '/import.log', date('Y-m-d H:i:s') . "\r\n", FILE_APPEND); $filename = date('Ymd_His') . ".xml"; file_put_contents($filename, file_get_contents("php://input")); set_time_limit(1000); include_once "../core/lib/SQL.class.php"; include_once '../modules/catsrv/catsrv.properties.php'; include_once "../modules/catsrv/LibCatsrv.class.php"; chdir(ROOT); $ST = new SQL(DB_HOST, DB_LOGIN, DB_PASSWORD, DB_BASE); $r = $ST->select("SELECT UPPER(name) AS name,value FROM sc_config"); while ($r->next()) { if ($r->get('value')) { $CONFIG[$r->get('name')] = $r->get('value'); } } $res = LibCatsrv::import('import/' . $filename, 4); file_put_contents(dirname(__FILE__) . '/import.log', print_r($res, true), FILE_APPEND); echo print_r($res, true);