root@www:/var/www# cat importXls.php
<?

$path=""; while(!file_exists($path.".System")) $path.="../";
include $path.'.System/.Config/db_server.inc';

require_once '_admin/xls/excel_reader2.php';


$dir =  "_ost/ostatki/";

$filename = "";

if (is_dir($dir)) {
    if ($dh = opendir($dir)) {
        while (($file = readdir($dh)) !== false) {
            if(filetype($dir . $file) == 'file'){
                if(!$filename)
                        $filename = $dir.$file;
                else{
                        //print "\n ".$filename." - ".$file."\n";
                        if(filemtime($filename) < filemtime($dir.$file)){
                                $filename = $dir . $file;
                        }
                }
            }
        }
        closedir($dh);
    }
}


/*print "\n".date("Y-m-d h:i:s",filemtime($dir.'OstatkiMagazinov_20090910.xls'))." - ".date("Y-m-d h:i:s",filemtime($dir.'OstatkiMagazinov_20090915.xls'))."\n";

exit();

*///$excel_file_name    =       "OstatkiMagazinov_".date("Ymd",strtotime('-1 day')).".xls";
$excel_file_name        =       str_replace("_ost/ostatki/","",$filename);

$excel_file = "_ost/ostatki/".$excel_file_name;



if(!is_file($excel_file)){
        error_log('No find such file '.$excel_file.' at '.date("Y-m-d H:i:s"));
        exit();
}

$data = new Spreadsheet_Excel_Reader($excel_file,true);

/*print "rowcount:".$data->rowcount()."; colcount:".$data->rowcount()."\n";
print "rowcount:".$data->rowcount()."; colcount:".$data->rowcount()."\n";
print "value 5:1 - ".$data->value(5,1)."\n";*/
//print "\n*** BEGIN IMPORT***\n";
mysql_connect($db[host],$db[user],$db[password]);
mysql_select_db($db[db]);
mysql_query("SET CHARACTER SET utf8");
mysql_query("TRUNCATE product_balance");
mysql_query("TRUNCATE shop_balance_to_product");

$sqlproductbalance                      = "INSERT INTO product_balance (`shk`, `morecode`, `articul`, `brand`, `shopid`, `num`, `price`, `price_zak`) VALUES";
$sqlshopbalance_to_product      = "INSERT INTO shop_balance_to_product (`shk`, `morecode`, `articul`, `brend`) VALUES";
$shops                                          = array();

$shopproduct                            = array();
$shopproductto                          = array();

for($row=3;$row<=$data->rowcount();$row++) {
        /**
         *
         * ▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ ▒▒▒▒ ▒▒▒▒▒▒▒
         *
         * 1    - ▒▒▒▒▒▒
         * 3    - ▒▒▒▒▒▒▒
         * 15   - ▒▒▒▒▒ ▒▒▒
         * 18   - ▒▒▒▒▒ ▒▒▒▒▒▒▒
         * 19   - 25
         *
         *
         */

        $magstart = 19;
        $magcount = $data->colcount();


        if($row == 3){
                for ($i = $magstart; $i <= $magcount; $i++){
                        $name = htmlspecialchars(addslashes(trim($data->value($row,$i))));

                        $query = mysql_query("SELECT * FROM shop_balance WHERE origName='$name'");
                        if(mysql_num_rows($query) <= 0){
                                $query          = mysql_query("INSERT INTO shop_balance SET origName='$name', name='".substr($name,0,4)."'");
                                $shops[$i]      =       mysql_insert_id();
                        }else{
                                $tmp                    = mysql_fetch_array($query);
                                $shops[$i]      = $tmp['id'];
                        }
                }
        }

        if($row >= 5 ){

                //▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒-▒▒
                for ($i = $magstart; $i <= $magcount; $i++){
                        //$shopproductto[] = "('".$shops[$i]."', '".$data->value($row,15)."', '".$data->value($row,$i)."')";
                        /*if(strchr($data->value($row,15),'773554508123')){
                                print "\n*** ".$data->value($row,15)." ***\n";
                                print "\n*** raw = ".$data->raw($row,15)." ***\n";
                                print "\n*** type = ".$data->type($row,15)." ***\n";
                                print "\n*** ".$data->value($row+1,15)." ***\n";
                                print "\n*** raw = ".$data->raw($row+1,15)." ***\n";
                                print "\n*** type = ".$data->type($row+1,15)." ***\n";
                                exit();
                        }*/
                        $shk = "";
                        $shk = (strlen($data->value($row,15))>=20)?$data->raw($row,15):$data->value($row,15);
            if(!$shk) $shk = $data->value($row,15);
                        //$shk = (strlen($data->value($row,15))>=20)?$data->value($row,15):$data->value($row,15);
                        $shopproduct[]  = "('".addslashes($shk)."', '".addslashes(trim($data->value($row,1)))."', '".addslashes($data->value($row,3))."', '".addslashes($data->value($row,7))."', '".(int)$shops[$i]."', '".(int)$data->value($row,$i)."', '".str_replace(",","",$data->value($row,16))."', '".str_replace(",","",$data->value($row,17))."')";
                }


                if(count($shopproduct)>500){
                        $sqlquery = $sqlproductbalance.implode(",",$shopproduct);
                        mysql_query($sqlquery) or error_log('mysql error: '.mysql_error()."\n".$sqlquery);
                        $shopproduct    =       array();
                }
        }

        if(count($shopproduct)){
                $sqlquery = $sqlproductbalance.implode(",",$shopproduct);
                mysql_query($sqlquery) or error_log('mysql error: '.mysql_error()."\n".$sqlquery);
                $shopproduct    =       array();
        }

}




rename($GLOBALS['php_root']."_ost/ost_".date('Ymd').'.csv',$GLOBALS['php_root']."_ost/ost2_".date('Ymd').'.csv');


// didan - ▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒ ▒ ▒▒▒▒▒▒▒▒▒
$query = mysql_query("UPDATE `product_balance` SET num=0 WHERE `shopid` NOT IN (18,23) AND `price`<1000 AND num>0 AND num<3");
$query = mysql_query("UPDATE `product_balance` SET num=0 WHERE `shopid` = 18 AND `price`<500 AND num=1");

// didan - ▒▒▒▒▒▒▒▒▒ ▒▒▒▒ ▒▒▒▒▒▒▒, ▒▒▒▒▒▒▒ ▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ▒ ▒▒▒▒▒▒▒▒
$query = mysql_query("UPDATE `catalog_products_variants` LEFT JOIN product_balance ON `pv_ExtID`=shk SET pv_Qty=0 WHERE shk IS NULL AND `pv_Qty`>0");

// didan - ▒▒▒▒▒▒ ▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒
// $query = mysql_query("UPDATE `catalog_products` LEFT JOIN catalog_products_variants ON `product_ID`=pv_ProductID SET product_ShowOnMain=0 WHERE pv_Qty=0 AND product_ShowOnMain>0");





$query = "SELECT DISTINCT `shk` , `price` , `price_zak` , SUM( `num` ) AS total FROM `product_balance` INNER JOIN catalog_products_variants ON `shk` = pv_ExtID WHERE `shopid` IN ( 16, 18, 23, 32 ) GROUP BY `shk` HAVING `price_zak` >0 OR `total` =0";
$fp = fopen($GLOBALS['php_root']."_ost/ostnew_".date('Ymd').'.csv','wb');
$res_offers = mysql_query($query);
while ($offer = mysql_fetch_assoc($res_offers)) {
                                fputcsv($fp,array($offer['shk'],$offer["price"],$offer["price_zak"],$offer["total"]),';','"');
                        }

fclose($fp);



//print "\n*** END IMPORT ***\n";
//if all right lets move excel_file to other directory;
//print "\n*** BEGIN COPY $excel_file_name ***\n";




rename($excel_file,'_ost/ostatki/_done/'.$excel_file_name);
//print "\n*** END COPY $excel_file_name ***\n";




?>
root@www:/var/www#

root@www:/var/www# php importXls.php
PHP Notice:  Use of undefined constant host - assumed 'host' in /var/www/importXls.php on line 54
PHP Notice:  Use of undefined constant user - assumed 'user' in /var/www/importXls.php on line 54
PHP Notice:  Use of undefined constant password - assumed 'password' in /var/www/importXls.php on line 54
PHP Notice:  Use of undefined constant db - assumed 'db' in /var/www/importXls.php on line 55
PHP Notice:  Undefined index: php_root in /var/www/importXls.php on line 140
PHP Notice:  Undefined index: php_root in /var/www/importXls.php on line 140
PHP Warning:  rename(_ost/ost_20120511.csv,_ost/ost2_20120511.csv): No such file or directory in /var/www/importXls.php on line 140
PHP Notice:  Undefined index: php_root in /var/www/importXls.php on line 158

rename($_SERVER['DOCUMENT_ROOT']."/_ost/ost_".date('Ymd').'.csv',$_SERVER['DOCUMENT_ROOT']."/_ost/ost2_".date('Ymd').'.csv');

rename($_SERVER['DOCUMENT_ROOT']."/_ost/ost_".date('Ymd').'.csv',$_SERVER['DOCUMENT_ROOT']."/_ost/ost2_".date('Ymd').'.csv');

root@www:/var/www# php importXls.php
PHP Notice:  Use of undefined constant host - assumed 'host' in /var/www/importXls.php on line 54
PHP Notice:  Use of undefined constant user - assumed 'user' in /var/www/importXls.php on line 54
PHP Notice:  Use of undefined constant password - assumed 'password' in /var/www/importXls.php on line 54
PHP Notice:  Use of undefined constant db - assumed 'db' in /var/www/importXls.php on line 55
PHP Warning:  rename(/_ost/ost_20120511.csv,/_ost/ost2_20120511.csv): No such file or directory in /var/www/importXls.php on line 142
PHP Notice:  Undefined index: php_root in /var/www/importXls.php on line 159

mysql_connect($db[host],$db[user],$db[password]);
mysql_select_db($db[db]);

mysql_connect($db['host'],$db['user'],$db['password']);
mysql_select_db($db['db']);

rename($GLOBALS['php_root']."_ost/ost_".date('Ymd').'.csv',$GLOBALS['php_root']."_ost/ost2_".date('Ymd').'.csv');

rename(dirname(__FILE__)."_ost/ost_".date('Ymd').'.csv', dirname(__FILE__)."_ost/ost2_".date('Ymd').'.csv');

rename($GLOBALS['php_root']."_ost/ost_".date('Ymd').'.csv',$GLOBALS['php_root']."_ost/ost2_".date('Ymd').'.csv');

rename(dirname(__FILE__)."_ost/ost_".date('Ymd').'.csv', dirname(__FILE__)."_ost/ost2_".date('Ymd').'.csv');

PHP Warning:  rename(/var/www_ost/ost_20120511.csv,/var/www_ost/ost2_20120511.csv): No such file or directory in /var/www/importXls.php on line 143
PHP Notice:  Undefined index: php_root in /var/www/importXls.php on line 160

rename(dirname(__FILE__)."_ost/ost_".date('Ymd').'.csv', dirname(__FILE__)."_ost/ost2_".date('Ymd').'.csv');

rename(dirname(__FILE__)."/_ost/ost_".date('Ymd').'.csv', dirname(__FILE__)."/_ost/ost2_".date('Ymd').'.csv');

$fp = fopen($GLOBALS['php_root']."_ost/ostnew_".date('Ymd').'.csv','wb');

$fp = fopen(dirname(__FILE__)."/_ost/ostnew_".date('Ymd').'.csv','wb');

PHP Warning:  rename(/var/www/_ost/ost_20120511.csv,/var/www/_ost/ost2_20120511.csv): No such file or directory in /var/www/importXls.php on line 144

rename(dirname(__FILE__)."/_ost/ost_".date('Ymd').'.csv', dirname(__FILE__)."/_ost/ost2_".date('Ymd').'.csv');

Спустя 2 минуты, 41 секунда (11.05.2012 - 13:51) killer8080 написал(а):

Цитата (justbox @ 11.05.2012 - 12:48)

PHP Warning:rename(/var/www/_ost/ost_20120511.csv,/var/www/_ost/ost2_20120511.csv): No such file or directory in /var/www/importXls.php on line 144

в какой паке лежит файл ost_20120511.csv? И какие права на него выставлены?

$fp = fopen(dirname(__FILE__)."/_ost/ostnew_".date('Ymd').'.csv','wb');

$fp = fopen(dirname(__FILE__)."/_ost/ostnew_".date('Ymd').'.csv','wb');

rename(dirname(__FILE__)."/_ost/ost_".date('Ymd').'.csv', dirname(__FILE__)."/_ost/ost2_".date('Ymd').'.csv');