function ajax_upload_vgoods_sn($filename = "", $rt = array())
{
@set_time_limit(600);
//最大运行时间
$gid = $rt['gid'];
$fop = Import::fileop();
unset($rt);
$vgoods_type = $this->App->findvar("SELECT vgoods_type FROM `{$this->App->prefix()}userconfig` WHERE type = 'basic' LIMIT 1");
if (!empty($_FILES[$filename]['tmp_name'])) {
$yuming = str_replace(array('www', '.'), '', $_SERVER["HTTP_HOST"]);
if (!empty($yuming)) {
$yuming = $yuming . DS;
}
$fn = SYS_PATH . 'cache' . DS . $yuming . 'vgoods' . DS . 'vgoodssn.xls';
if (file_exists($fn)) {
unlink($fn);
}
//删除原来文件
$fop->copyfile($filename, $fn);
//复制文件到服务器
if (!file_exists($fn)) {
$fop->copyfile($filename, $fn);
if (!file_exists($fn)) {
echo '<script> alert("上传时发生意外错误！"); </script>';
return false;
}
}
$data = Import::excel();
$data->read($fn);
//读取文件
$importkey = $data->sheets[0]['cells'][1];
for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
$rD = array();
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
$rD[] = $data->sheets[0]['cells'][$i][$j];
}
if (empty($rD[0])) {
continue;
}
$rtd = array();
$rtd['goods_id'] = $gid;
if ($vgoods_type == '2') {
$rtd['goods_pass'] = $rD[0];
$sn = $rD[0];
} else {
$rtd['goods_pass'] = $rD[1];
$rtd['goods_sn'] = $rD[0];
$sn = $rD[1];
}
$rtd['addtime'] = mktime();
$sql = "SELECT id FROM `{$this->App->prefix()}goods_sn` WHERE goods_id='{$gid}' AND goods_pass='******' LIMIT 1";
$id = $this->App->findvar($sql);
if ($id > 0) {
continue;
}
$this->App->insert('goods_sn', $rtd);
}
echo '<script> alert("上传成功！");</script>';
return false;
}
echo '<script> alert("上传失败！");</script>';
return true;
}
function ajax_upload($filename = "")
{
$uid = $this->Session->read('User.uid');
$rank = $this->Session->read('User.rank');
$active = $this->App->findvar("SELECT active FROM `{$this->App->prefix()}user` WHERE user_id='{$uid}'");
$this->Session->write('User.active', $active);
if ($active != '1') {
echo '<script> alert("抱歉，你账户处于失活状态，请联系管理员激活！"); </script>';
return false;
}
if (!($uid > 0) || $rank != '10') {
echo '<script> alert("抱歉，你没有权限上传！"); </script>';
return false;
}
$fop = Import::fileop();
$fn = SYS_PATH . 'cache' . DS . 'admin-' . $uid . '.php';
$fop->writefile($fn, "");
$tw_s = intval($GLOBALS['LANG']['th_width_s']) > 0 ? intval($GLOBALS['LANG']['th_width_s']) : 200;
$th_s = intval($GLOBALS['LANG']['th_height_s']) > 0 ? intval($GLOBALS['LANG']['th_height_s']) : 200;
$tw_b = intval($GLOBALS['LANG']['th_width_b']) > 0 ? intval($GLOBALS['LANG']['th_width_b']) : 450;
$th_b = intval($GLOBALS['LANG']['th_height_b']) > 0 ? intval($GLOBALS['LANG']['th_height_b']) : 450;
if (!empty($_FILES[$filename]['tmp_name'])) {
$fn = SYS_PATH . 'cache' . DS . 'admin-upload-' . $uid . '.xls';
if (file_exists($fn)) {
unlink($fn);
}
//删除原来文件
$fop->copyfile($filename, $fn);
//复制文件到服务器
if (!file_exists($fn)) {
$fop->copyfile($filename, $fn);
if (!file_exists($fn)) {
echo '<script> alert("上传时发生意外错误！"); </script>';
return false;
}
}
$data = Import::excel();
$data->read($fn);
//读取文件
$importkey = $data->sheets[0]['cells'][1];
for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
//以下注释的for循环打印excel表数据
$this->rtData = array();
//商品数据
$this->rtData_gallery = array();
//商品相册
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
$this->goods_key($importkey[$j], $data->sheets[0]['cells'][$i][$j]);
//传送 键=>值 处理
}
$this->rtData['is_on_sale'] = '0';
$this->rtData['add_time'] = mktime();
$this->rtData['uid'] = $uid;
$inData = $this->rtData;
//print_r($inData); exit;
$goods_id = 0;
//检查该商品已经存在数据库中
$sn = $inData['goods_sn'];
//优先级是商品条形码检查
if (!empty($sn)) {
$sql = "SELECT goods_id FROM `{$this->App->prefix()}goods` WHERE goods_sn='{$sn}'";
$goods_id = $this->App->findvar($sql);
//if(!empty($snvar)) continue;
}
/*else{
$sa = $inData['goods_name']; //商品名称检查是否该商品已经存在
if(!empty($sa)){ //最后更新：2012-12-11 10:26
$sql = "SELECT goods_id FROM `{$this->App->prefix()}goods` WHERE goods_name='$sa'";
$goods_id = $this->App->findvar($sql);
//if(!empty($savar)) continue;
}
}*/
if (!empty($inData['goods_name'])) {
//商品图片
$val = $inData['original_img'];
if (!empty($val)) {
$pa = dirname($val);
$thumb = basename($val);
if (is_file(SYS_PATH . $pa . DS . 'thumb_s' . DS . $thumb)) {
$pp = SYS_PATH . $pa . DS . 'thumb_s' . DS . mktime() . $thumb;
$pps = $pa . '/thumb_s/' . mktime() . $thumb;
} else {
$pp = SYS_PATH . $pa . DS . 'thumb_s' . DS . $thumb;
$pps = $pa . '/thumb_s/' . $thumb;
}
Import::img()->thumb(SYS_PATH . $val, $pp, $tw_s, $th_s);
//小缩略图
$inData['goods_thumb'] = $pps;
if (is_file(SYS_PATH . $pa . DS . 'thumb_b' . DS . $thumb)) {
$pp = SYS_PATH . $pa . DS . 'thumb_b' . DS . mktime() . $thumb;
$pps = $pa . '/thumb_b/' . mktime() . $thumb;
} else {
$pp = SYS_PATH . $pa . DS . 'thumb_b' . DS . $thumb;
$pps = $pa . '/thumb_b/' . $thumb;
}
Import::img()->thumb(SYS_PATH . $val, $pp, $tw_b, $th_b);
//大缩略图
$inData['goods_img'] = $pps;
}
if ($goods_id > 0) {
//更新
//$inData['is_check'] = 0;
if ($this->App->update('goods', $inData, 'goods_id', $goods_id)) {
//更新供应商商品表
$sql = "SELECT sgid FROM `{$this->App->prefix()}suppliers_goods` WHERE goods_id='{$goods_id}' AND suppliers_id='{$uid}'";
$sgid = $this->App->findvar($sql);
$dd = array();
$dd['goods_number'] = $inData['goods_number'] > 0 ? $inData['goods_number'] : 1000;
$dd['warn_number'] = $inData['warn_number'] > 0 ? $inData['warn_number'] : 10;
if ($inData['pifa_price'] > 0) {
$dd['market_price'] = $inData['pifa_price'];
}
if ($inData['pifa_price'] > 0) {
$dd['pifa_price'] = $inData['pifa_price'];
}
if ($inData['shop_price'] > 0) {
$dd['shop_price'] = $inData['shop_price'];
}
$dd['is_check'] = 0;
if (empty($sgid) || !($sgid > 0)) {
$dd['is_on_sale'] = 1;
$dd['goods_id'] = $goods_id;
$dd['suppliers_id'] = $uid;
$dd['addtime'] = mktime();
$this->App->insert('suppliers_goods', $dd);
} else {
$this->App->update('suppliers_goods', $dd, array("suppliers_id='{$uid}'", "goods_id='{$goods_id}'"));
}
unset($dd);
//将原来的相册图片删除
$sql = "SELECT img_url FROM `{$this->App->prefix()}goods_gallery` WHERE goods_id ='{$goods_id}'";
$gallery_img = $this->App->findcol($sql);
if (!empty($gallery_img)) {
foreach ($gallery_img as $img) {
$q = dirname($img);
$h = basename($img);
Import::fileop()->delete_file(SYS_PATH . $q . DS . 'thumb_s' . DS . $h);
Import::fileop()->delete_file(SYS_PATH . $q . DS . 'thumb_b' . DS . $h);
Import::fileop()->delete_file(SYS_PATH . $img);
//
}
unset($gallery_img);
}
$this->App->delete('goods_gallery', 'goods_id', $goods_id);
//重新处理商品相册
$rt_gallery = $this->rtData_gallery;
if (!empty($rt_gallery)) {
foreach ($rt_gallery as $vv) {
$vv = trim($vv);
$pa = dirname($vv);
$thumb = basename($vv);
if (empty($vv) || !is_file(SYS_PATH . $vv)) {
continue;
}
//生成缩略图
if (is_file(SYS_PATH . $pa . DS . 'thumb_s' . DS . $thumb)) {
$p = SYS_PATH . $pa . DS . 'thumb_s' . DS . mktime() . $thumb;
} else {
$p = SYS_PATH . $pa . DS . 'thumb_s' . DS . $thumb;
}
Import::img()->thumb(SYS_PATH . $vv, $p, $tw_s, $th_s);
//小缩略图
if (is_file(SYS_PATH . $pa . DS . 'thumb_b' . DS . $thumb)) {
$p = SYS_PATH . $pa . DS . 'thumb_b' . DS . mktime() . $thumb;
} else {
$p = SYS_PATH . $pa . DS . 'thumb_b' . DS . $thumb;
}
Import::img()->thumb(SYS_PATH . $vv, $p, $tw_b, $th_b);
//大缩略图
//插入商品相册属性表
$dd = array();
$dd['goods_id'] = $goods_id;
$dd['img_url'] = $vv;
$this->App->insert('goods_gallery', $dd);
}
// end foreach
}
//end if 商品相册
} else {
//插入失败，写入日记
$aid = $this->Session->read('adminid');
$fn = SYS_PATH . 'cache' . DS . 'admin-' . $aid . '.php';
$fop->writefile($fn, "批量导入错误：\n" . '商品编号--' . implode('--', array_keys($inData)) . "\n" . $inData['goods_bianhao'] . '--' . implode('--', $inData) . "\n");
}
} else {
//插入数据库
if ($this->App->insert('goods', $inData)) {
$lastid = $this->App->iid();
//添加到供应商商品表
$sql = "SELECT sgid FROM `{$this->App->prefix()}suppliers_goods` WHERE goods_id='{$lastid}' AND suppliers_id='{$uid}'";
$sgid = $this->App->findvar($sql);
$dd = array();
$dd['goods_number'] = $inData['goods_number'] > 0 ? $inData['goods_number'] : 1000;
$dd['warn_number'] = $inData['warn_number'] > 0 ? $inData['warn_number'] : 10;
if ($inData['pifa_price'] > 0) {
$dd['market_price'] = $inData['pifa_price'];
}
if ($inData['pifa_price'] > 0) {
$dd['pifa_price'] = $inData['pifa_price'];
}
if ($inData['shop_price'] > 0) {
$dd['shop_price'] = $inData['shop_price'];
}
$dd['is_check'] = 0;
$dd['is_on_sale'] = 1;
$dd['goods_id'] = $lastid;
$dd['suppliers_id'] = $uid;
$dd['addtime'] = mktime();
$this->App->insert('suppliers_goods', $dd);
unset($dd);
$rt_gallery = $this->rtData_gallery;
//商品相册
//商品相册
if (!empty($rt_gallery)) {
foreach ($rt_gallery as $vv) {
$vv = trim($vv);
$pa = dirname($vv);
$thumb = basename($vv);
if (empty($vv) || !is_file(SYS_PATH . $vv)) {
continue;
}
//生成缩略图
if (is_file(SYS_PATH . $pa . DS . 'thumb_s' . DS . $thumb)) {
$p = SYS_PATH . $pa . DS . 'thumb_s' . DS . mktime() . $thumb;
} else {
$p = SYS_PATH . $pa . DS . 'thumb_s' . DS . $thumb;
}
Import::img()->thumb(SYS_PATH . $vv, $p, $tw_s, $th_s);
//小缩略图
if (is_file(SYS_PATH . $pa . DS . 'thumb_b' . DS . $thumb)) {
$p = SYS_PATH . $pa . DS . 'thumb_b' . DS . mktime() . $thumb;
} else {
$p = SYS_PATH . $pa . DS . 'thumb_b' . DS . $thumb;
}
Import::img()->thumb(SYS_PATH . $vv, $p, $tw_b, $th_b);
//大缩略图
//插入商品属性表
$dd = array();
$dd['goods_id'] = $lastid;
$dd['img_url'] = $vv;
$this->App->insert('goods_gallery', $dd);
}
// end foreach
}
//end if
} else {
//插入失败，写入日记
$aid = $this->Session->read('adminid');
$fn = SYS_PATH . 'cache' . DS . 'admin-' . $uid . '.php';
$fop->writefile($fn, "批量导入错误：\n" . '商品编号--' . implode('--', array_keys($inData)) . "\n" . $inData['goods_bianhao'] . '--' . implode('--', $inData) . "\n");
}
}
//end if
} else {
//写入错误日记
$aid = $this->Session->read('adminid');
$fn = SYS_PATH . 'cache' . DS . 'admin-' . $uid . '.php';
$fop->writefile($fn, "批量导入错误：\n" . implode('--', array_keys($inData)) . "\n" . implode('--', $inData) . "\n");
}
//end if
}
//end for
echo '<script> alert("上传成功！");</script>';
return false;
}
return $_FILES[$filename];
}
