2387 行
109 KiB
PHP
可执行文件
2387 行
109 KiB
PHP
可执行文件
<?php
|
|
|
|
namespace Retail\Controller;
|
|
|
|
use Think\Controller;
|
|
//[1.2.84]
|
|
class FlowController extends BaseController
|
|
{
|
|
public function index()
|
|
{
|
|
$storeid = session('storeid');
|
|
$catemachantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$cates = M("retail_goods_class")->where(array('storeid' => $storeid, 'merchantid' => $catemachantid, 'status' => 0, 'type' => 3))->select();
|
|
$supplier = M("retail_supplier")->where(array('merchantid' => $catemachantid, 'status' => 1))->select();
|
|
$this->assign('cate', $cates);
|
|
$this->assign('info', $supplier);
|
|
$order = M('retail_floworder')->where(array('audit' => 1, 'status' => 1, 'type' => 1, 'storeid' => $storeid))->find();
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
} else {
|
|
$Ad['storeid'] = $storeid;
|
|
$Ad['audit'] = 1;
|
|
$Ad['type'] = 1;
|
|
$Ad['status'] = 1;
|
|
$ret = M('retail_floworder')->add($Ad);
|
|
$floworderid = $ret;
|
|
}
|
|
session('floworderid', $floworderid);
|
|
$this->assign('floworderid', $floworderid);
|
|
$this->display();
|
|
}
|
|
|
|
public function searchgoods()
|
|
{
|
|
if (IS_POST) {
|
|
$keyword = I('post.keyword');
|
|
$storeid = session('storeid');
|
|
$w['store_id'] = $storeid;
|
|
$w['goods_code|goods_number|goods_name'] = $keyword;
|
|
$w['status'] = array('in','0,1');
|
|
$goods = M('retail_goods')->where($w)
|
|
->field("id as goodsid,goods_name,goods_number as good_number,purchase_price,retail_price,goods_num,company,specifications,goods_code,store_id")
|
|
->find();
|
|
if ($goods) {
|
|
$goods['purch_price'] = $goods['purchase_price'];
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '查询成功';
|
|
$goods['givenum'] = 0;
|
|
$goods['num'] = "";
|
|
$rt['goods'] = $goods;
|
|
} else {
|
|
$rt['status'] = 0;
|
|
$rt['m'] = M()->_sql();
|
|
$rt['msg'] = '未找符合条件的数据';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
public function getgoodsarr()
|
|
{
|
|
if (IS_POST) {
|
|
$floworderid = I('post.floworderid');
|
|
$rt['post'] = I('post.');
|
|
if (!$floworderid) {
|
|
$rt['status'] = 0;
|
|
$rt['msg'] = '查询失败';
|
|
} else {
|
|
$w['floworderid'] = $floworderid;
|
|
$w['status'] = 1;
|
|
$data = M('retail_flow')->where($w)->select();
|
|
if ($data) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '查询成功';
|
|
$rt['data'] = $data;
|
|
} else {
|
|
$rt['status'] = 0;
|
|
$rt['msg'] = '查询失败';
|
|
}
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
public function dostock()
|
|
{
|
|
if (IS_POST) {
|
|
$data = I('post.');
|
|
$data['addtime'] = time();
|
|
$data['storeid'] = $data['store_id'];
|
|
$one = M('retail_flow')
|
|
->where(array('storeid' => $data['storeid'], 'goodsid' => $data['goodsid'], 'status' => 1, 'floworderid' => $data['floworderid']))
|
|
->find();
|
|
if ($one) {
|
|
$rt['status'] = 0;
|
|
$rt['msg'] = '该商品已加入进货单，请确认';
|
|
} else {
|
|
$ret = M('retail_flow')->add($data);
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '加入成功';
|
|
$rt['data'] = M('retail_flow')->where(array('id' => $ret))->find();
|
|
} else {
|
|
$rt['status'] = 0;
|
|
$rt['msg'] = '加入失败';
|
|
}
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
// 修改数量
|
|
public function changenum()
|
|
{
|
|
if (IS_POST) {
|
|
$type = I('post.type');
|
|
$id = I('post.id');
|
|
$num = I('post.num');
|
|
if ($type == 1) {
|
|
$savedata['num'] = $num;
|
|
} else {
|
|
$savedata['givenum'] = $num;
|
|
}
|
|
$ret = M('retail_flow')->where(array('id' => $id))->save($savedata);
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '修改成功';
|
|
} else {
|
|
$rt['status'] = 0;
|
|
$rt['msg'] = '修改成功';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
// 确认订货单
|
|
public function submitfloworder()
|
|
{
|
|
if (IS_POST) {
|
|
$user = session("ls_userinfo");
|
|
$storeid = session('storeid');
|
|
$id = I('post.id');
|
|
$dismoney = I('post.dismoney');
|
|
$allgoods = M('retail_flow')->where(array('floworderid' => $id, 'status' => 1, 'storeid' => $storeid))->select();
|
|
$allmoney = 0;
|
|
$allnum = 0;
|
|
$allgivenum = 0;
|
|
foreach ($allgoods as $k => $v) {
|
|
$allmoney += $v['num'] * $v['purch_price'];
|
|
$allnum += $v['num'];
|
|
$allgivenum += $v['givenum'];
|
|
}
|
|
$q = true;
|
|
$str = date('YmdHis');
|
|
$i = 0;
|
|
while ($q) {
|
|
$ordernum = $str . rand(100000, 999999);
|
|
$one = M('retail_floworder')->where(array('storeid' => $storeid, 'ordernum' => $ordernum))->find();
|
|
if (!$one) {
|
|
$q = false;
|
|
} else {
|
|
$i++;
|
|
if ($i >= 10) {
|
|
$str += 1;
|
|
$i = 0;
|
|
}
|
|
}
|
|
}
|
|
// 供货商
|
|
$supplier_id = I('post.supplier_id');
|
|
$supplier_id = $supplier_id ? $supplier_id : 0;
|
|
if ($supplier_id == -1) {
|
|
$supplier_id = 0;
|
|
}
|
|
$savedata['supplier_id'] = $supplier_id;
|
|
// 调拨目标门店
|
|
$tostoreid = I('post.tostoreid');
|
|
$tostoreid = $tostoreid ? $tostoreid : 0;
|
|
$savedata['tostoreid'] = $tostoreid;
|
|
$savedata['audit'] = 2;
|
|
$savedata['ctime'] = time();
|
|
$savedata['allmoney'] = $allmoney;
|
|
$savedata['dismoney'] = $dismoney;
|
|
$savedata['paymoney'] = $allmoney - $dismoney;
|
|
$savedata['allnum'] = $allnum;
|
|
$savedata['ordernum'] = $ordernum;
|
|
$savedata['allgivenum'] = $allgivenum;
|
|
$savedata['adminid'] = $user['id'];
|
|
$savedata['admintype'] = $user['account_type'];
|
|
$ret = M('retail_floworder')->where(array('id' => $id))->save($savedata);
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '修改成功';
|
|
} else {
|
|
$rt['status'] = 0;
|
|
$rt['msg'] = '修改成功';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
public function myimport()
|
|
{
|
|
if (IS_POST) {
|
|
$upload = new \Think\Upload (); // 实例化上传类
|
|
$upload->maxSize = 1048576 * 10; // 设置附件上传大小10M
|
|
$upload->exts = array(
|
|
'xls'
|
|
); // 设置附件上传类型
|
|
$upload->rootPath = 'Uploads'; // 设置附件上传根目录
|
|
$upload->savePath = '/Temp/'; // 设置附件上传（子）目录
|
|
$upload->saveName = array(
|
|
'uniqid',
|
|
''
|
|
);
|
|
// 上传文件
|
|
$info = $upload->upload();
|
|
if (empty($info)) {
|
|
$rt['status'] = 3;
|
|
$rt['msg'] = '表格类型不正确，应为.xls后缀的数据表格，或者数据表格大于10M';
|
|
$this->ajaxReturn($rt);
|
|
exit;
|
|
}
|
|
$path['path'] = '/' . 'Uploads' . $info['file']['savepath'] . $info['file']['savename'];
|
|
$arr = $this->importExecl("." . $path['path']);
|
|
$myrt['arr'] = $arr;
|
|
if ($arr['error'] == 0) {
|
|
$myrt['status'] = 2;
|
|
$myrt['msg'] = '数据表格格式不正确，请下载导入模板，按模板填入数据。';
|
|
$this->ajaxReturn($myrt);
|
|
exit;
|
|
} else {
|
|
header('Content-Type: text/html; charset=utf-8'); //网页编码
|
|
$goodsarr = $arr['data'][0]['Content'];
|
|
$goodsarr = json_decode(json_encode($goodsarr), true);
|
|
$titlearr = $goodsarr[1];
|
|
$floworderid = session('floworderid');
|
|
$keyarr = array();
|
|
foreach ($titlearr as $k => $v) {
|
|
if ($v == '商品名称') {
|
|
$keyarr['goods_name'] = $k;
|
|
} else if ($v == '条码') {
|
|
$keyarr['goods_code'] = $k;
|
|
} else if ($v == '货号') {
|
|
$keyarr['goods_number'] = $k;
|
|
} else if ($v == '进货量') {
|
|
$keyarr['num'] = $k;
|
|
} else if ($v == '赠送量') {
|
|
$keyarr['givenum'] = $k;
|
|
} else if ($v == '单位') {
|
|
$keyarr['company'] = $k;
|
|
} else if ($v == '进货价') {
|
|
$keyarr['purch_price'] = $k;
|
|
} else if ($v == '规格') {
|
|
$keyarr['specifications'] = $k;
|
|
}
|
|
}
|
|
$faultarr = array();
|
|
$time = time();
|
|
foreach ($goodsarr as $key => $val) {
|
|
if ($key == 1) {
|
|
continue;
|
|
}
|
|
$storeid = session('storeid');
|
|
$w['store_id'] = $storeid;
|
|
$w['goods_code'] = $val[$keyarr['goods_code']];
|
|
if ($val[$keyarr['goods_code']]) {
|
|
$goods = M('retail_goods')->where($w)
|
|
->field("id as goodsid,goods_name,goods_number,purchase_price,retail_price,goods_num,company,specifications,goods_code,storeid")
|
|
->find();
|
|
} else {
|
|
$goods = false;
|
|
}
|
|
|
|
if (!$goods) {
|
|
$w2['store_id'] = $storeid;
|
|
$w2['goods_number'] = $val[$keyarr['good_number']];
|
|
if ($val[$keyarr['good_number']]) {
|
|
$goods = M('retail_goods')->where($w2)
|
|
->field("id as goodsid,goods_name,goods_number,purchase_price,retail_price,goods_num,company,specifications,goods_code,storeid")
|
|
->find();
|
|
} else {
|
|
$goods = false;
|
|
}
|
|
}
|
|
if ($goods) {
|
|
$Ad = array();
|
|
$Ad['storeid'] = $storeid;
|
|
$Ad['goodsid'] = $goods['goodsid'];
|
|
$Ad['good_number'] = $val[$keyarr['good_number']];
|
|
$Ad['goods_num'] = $goods['goods_num'];
|
|
$Ad['goods_name'] = $val[$keyarr['goods_name']] ? $val[$keyarr['goods_name']] : $goods['goods_name'];
|
|
$Ad['purch_price'] = $val[$keyarr['purch_price']] ? $val[$keyarr['purch_price']] : $goods['purchase_price'];
|
|
$Ad['retail_price'] = $goods['retail_price'];
|
|
$Ad['num'] = $val[$keyarr['num']];
|
|
$Ad['givenum'] = $val[$keyarr['givenum']];
|
|
$Ad['company'] = $val[$keyarr['company']] ? $val[$keyarr['company']] : $goods['company'];
|
|
$Ad['specifications'] = $val[$keyarr['specifications']] ? $val[$keyarr['specifications']] : $goods['specifications'];
|
|
$Ad['floworderid'] = $floworderid;
|
|
$Ad['addtime'] = $time;
|
|
$Ad['money'] = $Ad['num'] * $Ad['purch_price'];
|
|
$Ad['goods_code'] = $val[$keyarr['goods_code']];
|
|
$one = M('retail_flow')
|
|
->where(array('storeid' => $Ad['storeid'], 'goodsid' => $Ad['goodsid'], 'status' => 1, 'floworderid' => $Ad['floworderid']))
|
|
->find();
|
|
if ($one) {
|
|
$val['reson'] = '商品重复(已有)，确认条码/货号';// 重复了
|
|
$faultarr[] = $val;
|
|
} else {
|
|
$ret = M('retail_flow')->add($Ad);
|
|
}
|
|
} else {
|
|
$val['reson'] = '商品档案中无该商品';// 未找到正常的
|
|
$faultarr[] = $val;
|
|
}
|
|
}
|
|
if (count($faultarr) > 0) {
|
|
// 生成错误表格，并返回路径。
|
|
$path2 = './Uploads/temp/' . $floworderid . '.txt';
|
|
file_put_contents($path2, json_encode($faultarr));
|
|
$rt['status'] = 1;
|
|
$rt['path'] = $path2;
|
|
$rt['msg'] = '导入成功，但有' . count($faultarr) . '项未导入成功';
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '导入成功';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
exit();
|
|
}
|
|
}
|
|
}
|
|
|
|
// 上传导入文件
|
|
function importExecl($file)
|
|
{
|
|
if (!file_exists($file)) {
|
|
return array("error" => 0, 'message' => 'file not found!');
|
|
}
|
|
Vendor("PHPExcel.PHPExcel.IOFactory");
|
|
$objReader = \PHPExcel_IOFactory::createReader('Excel5');
|
|
try {
|
|
$PHPReader = $objReader->load($file);
|
|
} catch (\Exception $e) {
|
|
}
|
|
if (!isset($PHPReader)) return array("error" => 0, 'message' => 'read error!');
|
|
$allWorksheets = $PHPReader->getAllSheets();
|
|
$i = 0;
|
|
foreach ($allWorksheets as $objWorksheet) {
|
|
$sheetname = $objWorksheet->getTitle();
|
|
$allRow = $objWorksheet->getHighestRow();//how many rows
|
|
$highestColumn = $objWorksheet->getHighestColumn();//how many columns
|
|
$allColumn = \PHPExcel_Cell::columnIndexFromString($highestColumn);
|
|
$array[$i]["Title"] = $sheetname;
|
|
$array[$i]["Cols"] = $allColumn;
|
|
$array[$i]["Rows"] = $allRow;
|
|
$arr = array();
|
|
$isMergeCell = array();
|
|
foreach ($objWorksheet->getMergeCells() as $cells) {//merge cells
|
|
foreach (\PHPExcel_Cell::extractAllCellReferencesInRange($cells) as $cellReference) {
|
|
$isMergeCell[$cellReference] = true;
|
|
}
|
|
}
|
|
for ($currentRow = 1; $currentRow <= $allRow; $currentRow++) {
|
|
$row = array();
|
|
for ($currentColumn = 0; $currentColumn < $allColumn; $currentColumn++) {
|
|
;
|
|
$cell = $objWorksheet->getCellByColumnAndRow($currentColumn, $currentRow);
|
|
$afCol = \PHPExcel_Cell::stringFromColumnIndex($currentColumn + 1);
|
|
$bfCol = \PHPExcel_Cell::stringFromColumnIndex($currentColumn - 1);
|
|
$col = \PHPExcel_Cell::stringFromColumnIndex($currentColumn);
|
|
$address = $col . $currentRow;
|
|
$value = $objWorksheet->getCell($address)->getValue();
|
|
if (substr($value, 0, 1) == '=') {
|
|
return array("error" => 0, 'message' => 'can not use the formula!');
|
|
exit;
|
|
}
|
|
/* if($cell->getDataType()==PHPExcel_Cell_DataType::TYPE_NUMERIC){
|
|
$cellstyleformat=$cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat();
|
|
$formatcode=$cellstyleformat->getFormatCode();
|
|
if (preg_match('/^([$[A-Z]*-[0-9A-F]*])*[hmsdy]/i', $formatcode)) {
|
|
$value=gmdate("Y-m-d", PHPExcel_Shared_Date::ExcelToPHP($value));
|
|
}else{
|
|
$value=PHPExcel_Style_NumberFormat::toFormattedString($value,$formatcode);
|
|
}
|
|
}*/
|
|
if ($isMergeCell[$col . $currentRow] && $isMergeCell[$afCol . $currentRow] && !empty($value)) {
|
|
$temp = $value;
|
|
} elseif ($isMergeCell[$col . $currentRow] && $isMergeCell[$col . ($currentRow - 1)] && empty($value)) {
|
|
$value = $arr[$currentRow - 1][$currentColumn];
|
|
} elseif ($isMergeCell[$col . $currentRow] && $isMergeCell[$bfCol . $currentRow] && empty($value)) {
|
|
$value = $temp;
|
|
}
|
|
$row[$currentColumn] = $value;
|
|
}
|
|
$arr[$currentRow] = $row;
|
|
}
|
|
$array[$i]["Content"] = $arr;
|
|
$i++;
|
|
}
|
|
//spl_autoload_register(array('Think','autoload'));//must, resolve ThinkPHP and //PHPExcel conflicts
|
|
unset($objWorksheet);
|
|
unset($PHPReader);
|
|
unset($PHPExcel);
|
|
unlink($file);
|
|
return array("error" => 1, "data" => $array);
|
|
}
|
|
|
|
// 下载导入模板。
|
|
public function downfile()
|
|
{
|
|
$url = './Public/flow/zip/1.zip';
|
|
if (!file_exists($url)) { //判断文件是否存在
|
|
echo "文件不存在";
|
|
exit();
|
|
}
|
|
ob_clean();
|
|
$file = fopen($url, "r");
|
|
Header("Content-type:application/octet-stream");
|
|
header("Accept-Ranges: bytes");
|
|
header("Accept-Length: " . filesize($url));
|
|
header("Content-Disposition: attachment; filename=导入模板.zip");
|
|
echo fread($file, filesize($url));
|
|
fclose($file);
|
|
}
|
|
|
|
public function delgoodsitem()
|
|
{
|
|
if (IS_POST) {
|
|
$id = I('post.id');
|
|
$savedata['status'] = 2;
|
|
$ret = $ret = M('retail_flow')->where(array('id' => $id))->save($savedata);
|
|
if ($ret !== false) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '删除成功';
|
|
} else {
|
|
$rt['status'] = 0;
|
|
$rt['msg'] = '删除失败';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
// 订货单数据
|
|
public function order()
|
|
{
|
|
$storeid = session('storeid');
|
|
$catemachantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$supplier = M("retail_supplier")->where(array('merchantid' => $catemachantid, 'status' => 1))->select();
|
|
$this->assign('info', $supplier);
|
|
$arr = array(
|
|
'flow_order_export' => '/index.php/Retail/Flow/flow_order_export',
|
|
'showfloworder' => '/index.php/Retail/Flow/showfloworder',
|
|
'doaudit' => '/index.php/Retail/Flow/doaudit',
|
|
'cancelfloworder' => '/index.php/Retail/Flow/cancelfloworder',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
// 订货单数据
|
|
public function orderlist()
|
|
{
|
|
// $user = session("ls_userinfo");
|
|
$ordernum = I('get.ordernum');
|
|
if ($ordernum) {
|
|
$w['ordernum'] = $ordernum;
|
|
}
|
|
$supplier_id = I('get.supplier_id');
|
|
if ($supplier_id) {
|
|
$w['supplier_id'] = $supplier_id;
|
|
}
|
|
$date = I('get.date'); // 时间查询条件
|
|
if (!empty($date)) {
|
|
$time = explode('至', $date);
|
|
$start_time = strtotime(date('Y-m-d', strtotime($time[0])));
|
|
$end_time = strtotime(date('Y-m-d', strtotime($time[1]))) + 86400;
|
|
$w['ctime'] = array('between', array($start_time, $end_time));
|
|
}
|
|
$storeid = session('storeid');
|
|
$w['storeid'] = $storeid;
|
|
$w['status'] = 1;//正常单据。
|
|
$w['type'] = 1;//进货单。
|
|
$w['audit'] = array('in', array(2, 3));
|
|
$p = I('get.page');
|
|
$l = I('get.limit');
|
|
$count = M('retail_floworder')->where($w)->count();
|
|
$data = M('retail_floworder')->where($w)->page($p, $l)->order('ctime desc')->select();
|
|
if ($data) {
|
|
foreach ($data as $k => $v) {
|
|
$data[$k]['ctime'] = date('Y-m-d H:i:s', $v['ctime']);
|
|
$data[$k]['index'] = 1 + $k + ($p - 1) * $l;
|
|
if ($v['supplier_id'] == 0) {
|
|
$data[$k]['supplier'] = '自采/其他';
|
|
} else {
|
|
$data[$k]['supplier'] = M('retail_supplier')->where(array('id' => $v['supplier_id']))->getField('supplier_name');
|
|
}
|
|
if ($v['admintype'] == 2) {
|
|
$data[$k]['adminname'] = M('retail_manager')->where(array('id' => $v['adminid']))->getField('name');
|
|
} else if ($v['admintype'] == 1) {
|
|
$data[$k]['adminname'] = M('retail_merchant')->where(array('id' => $v['adminid']))->getField('name');
|
|
}
|
|
if ($v['audit'] == 1) {
|
|
$data[$k]['auditname'] = '未确认';
|
|
} else if ($v['audit'] == 2) {
|
|
$data[$k]['auditname'] = '未审核';
|
|
} else if ($v['audit'] == 3) {
|
|
$data[$k]['auditname'] = '已审核';
|
|
}
|
|
}
|
|
}
|
|
$rt['code'] = 0;
|
|
$rt['msg'] = '';
|
|
$rt['count'] = $count;
|
|
$rt['data'] = $data;
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
|
|
// 查看进货单详情
|
|
|
|
public function showfloworder()
|
|
{
|
|
$storeid = session('storeid');
|
|
$catemachantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$supplier = M("retail_supplier")->where(array('merchantid' => $catemachantid, 'status' => 1))->select();
|
|
$this->assign('info', $supplier);
|
|
$id = I('get.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id))->find();
|
|
$this->assign('order', $order);
|
|
$arr = array(
|
|
'expUser' => '/index.php/Retail/Flow/expUser',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
// 查看报损单详情
|
|
|
|
public function showdamage()
|
|
{
|
|
$id = I('get.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id))->find();
|
|
$this->assign('order', $order);
|
|
$this->display();
|
|
}
|
|
|
|
public function printflow()
|
|
{
|
|
$storeid = session('storeid');
|
|
$store = M('retail_store')->where(array('id' => $storeid))->find();
|
|
// print_r($store);
|
|
$this->assign('store', $store);
|
|
$id = I('get.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id))->find();
|
|
$supplier = M("retail_supplier")->where(array('id' => $order['supplier_id'], 'status' => 1))->find();
|
|
$manager = M('retail_manager')->where(array('storeid' => $storeid, 'status' => 1))->find();
|
|
$this->assign('manager', $manager);
|
|
$this->assign('supplier', $supplier);
|
|
$this->assign('time', date('Y-m-d H:i:s'));
|
|
$this->assign('order', $order);
|
|
$this->display();
|
|
}
|
|
|
|
//导出excel
|
|
public function expUser()
|
|
{
|
|
$storeid = session('storeid');
|
|
$id = I('get.id');
|
|
$type = I('get.type');
|
|
$w['status'] = 1;
|
|
$w['storeid'] = $storeid;
|
|
$w['floworderid'] = $id;
|
|
$order = M('retail_floworder')->where(array('id' => $id))->find();
|
|
$supplier = M('retail_supplier')->where(array('id' => $order['supplier_id']))->getField('supplier_name');
|
|
$info = M('retail_flow')->where(array('storeid' => $storeid, 'status' => array('in', '0,1'), 'floworderid' => $order['id']))->select();
|
|
foreach ($info as $k => $v) {
|
|
$info[$k]['money'] = round($v['num'] * $v['purch_price'], 2);
|
|
}
|
|
//导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
|
|
import("Vendor.PHPExcel.PHPExcel");
|
|
import("Vendor.PHPExcel.Writer.Excel5");
|
|
import("Vendor.PHPExcel.IOFactory.php");
|
|
if ($type == 'refund') {
|
|
$str = "退货单订单信息:退货给" . $supplier . '供货商,总数量' . $order['allnum'] . ",总金额" . $order['allmoney'] . '(元),结算金额' . $order['paymoney'] . '(元),修改金额' . $order['dismoney'] . '(元)';
|
|
$filename = "退货单明细";
|
|
$headArr = array(
|
|
array('goods_name', '商品名称'),
|
|
array('good_number', '货号'),
|
|
array('goods_code', '条码'),
|
|
array('purch_price', '进货价'),
|
|
array('retail_price', '零售价'),
|
|
array('num', '退货量'),
|
|
array('company', '单位'),
|
|
array('specifications', '规格'),
|
|
array('money', '小计'),
|
|
);
|
|
} else {
|
|
$str = "订单信息:由" . $supplier . '供货商供应,总数量' . $order['allnum'] . ',总赠送量' . $order['allgivenum'] . ",总进价" . $order['allmoney'] . '(元),结算金额' . $order['paymoney'] . '(元),优惠' . $order['dismoney'] . '(元)';
|
|
$filename = "进货单明细";
|
|
$headArr = array(
|
|
array('goods_name', '商品名称'),
|
|
array('good_number', '货号'),
|
|
array('goods_code', '条码'),
|
|
array('purch_price', '进货价'),
|
|
array('retail_price', '零售价'),
|
|
array('num', '进货量'),
|
|
array('givenum', '赠送量'),
|
|
array('company', '单位'),
|
|
array('specifications', '规格'),
|
|
array('money', '小计'),
|
|
);
|
|
}
|
|
|
|
$this->getExcel($filename, $headArr, $info, $str);
|
|
}
|
|
|
|
private function getExcel($expTitle, $expCellName, $expTableData, $str = "")
|
|
{
|
|
|
|
$xlsTitle = iconv('utf-8', 'gb2312', $expTitle);//文件名称
|
|
$fileName = $expTitle . date('_YmdHis');//or $xlsTitle 文件名称可根据自己情况设定
|
|
$cellNum = count($expCellName);
|
|
$dataNum = count($expTableData);
|
|
$common = $str;
|
|
|
|
vendor("PHPExcel.PHPExcel");
|
|
$objPHPExcel = new \PHPExcel();
|
|
$cellName = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM', 'AN', 'AO', 'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ');
|
|
|
|
$objPHPExcel->getActiveSheet(0)->mergeCells('A1:' . $cellName[$cellNum - 1] . '1');//合并单元格
|
|
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $common);
|
|
// $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A1', $str);
|
|
for ($i = 0; $i < $cellNum; $i++) {
|
|
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i] . '2', $expCellName[$i][1]);
|
|
}
|
|
|
|
for ($i = 0; $i < $dataNum; $i++) {
|
|
for ($j = 0; $j < $cellNum; $j++) {
|
|
$objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j] . ($i + 3), ' ' . $expTableData[$i][$expCellName[$j][0]]);
|
|
|
|
}
|
|
}
|
|
foreach ($cellName as $value) {
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension($value)->setWidth(20);
|
|
|
|
}
|
|
header('pragma:public');
|
|
header('Content-type:application/vnd.ms-excel;charset=utf-8;name="' . $xlsTitle . '.xls"');
|
|
header("Content-Disposition:attachment;filename=$fileName.xls");//attachment新窗口打印inline本窗口打印
|
|
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
|
|
$objWriter->save('php://output');
|
|
exit();
|
|
}
|
|
|
|
public function doaudit()
|
|
{
|
|
if (IS_POST) {
|
|
$storeid = session('storeid');
|
|
$merchantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$id = I('post.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id, 'audit' => 2))->find();
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
$w['floworderid'] = $floworderid;
|
|
$w['status'] = 1;
|
|
$data = M('retail_flow')->where($w)->select();
|
|
// 循环添加库存
|
|
$time = time();
|
|
$num = 0;
|
|
foreach ($data as $k => $v) {
|
|
$id = $v['goodsid'];
|
|
$goods_num = $v['num'] + $v['givenum'];
|
|
$supplier_id = $order['supplier_id'];
|
|
$old = M("retail_goods")->where(array('id' => $id))->getField("goods_num");
|
|
|
|
$success = M('retail_goods')->where(array('id' => $id))->setInc('goods_num', $goods_num); // 系统库存添加。
|
|
if(!$success){
|
|
$log['success'] = 2;
|
|
$num ++;
|
|
}
|
|
//首先判断id是否正确
|
|
$log['goods_id'] = $id;//商品id
|
|
$log['original_stock'] = $old;//初始库存
|
|
$log['do_num'] = $goods_num;//操作库存记录
|
|
$log['type'] = 1;//1表示库存增加
|
|
$log['addtime'] = $time;
|
|
$log['merchantid'] = $merchantid;
|
|
$log['storeid'] = $storeid;
|
|
$log['supplier_id'] = $supplier_id;
|
|
$log['present_stock'] = $old + $goods_num;
|
|
$log['floworderid'] = $order['id'];
|
|
$log['ordernum'] = $order['ordernum'];
|
|
$log['remark'] = '进货单审核添加库存';
|
|
$addLog = M("retail_quantity_logs")->add($log); // 添加库存记录
|
|
}
|
|
$ret = M('retail_floworder')->where(array('id' => $floworderid))->save(array('audit' => 3));
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核成功';
|
|
if($num>0){
|
|
$rt['msg'] = '审核成功,但有'.$num.'项库存未添加成功';
|
|
}
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核失败';
|
|
}
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '改单据不能被审核';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
// 取消订单
|
|
public function cancelfloworder()
|
|
{
|
|
if (IS_POST) {
|
|
$id = I('post.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id, 'audit' => 2))->find();
|
|
if ($order) {
|
|
$ret = M('retail_floworder')->where(array('id' => $id, 'audit' => 2))->save(array('status' => 2));
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '作废成功';
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '作废失败';
|
|
}
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '该单据不能作废';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
// 下载导入失败的数据表格
|
|
public function downfaultfile()
|
|
{
|
|
$id = I('get.id');
|
|
$path2 = './Uploads/temp/' . $id . '.txt';
|
|
//导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
|
|
import("Vendor.PHPExcel.PHPExcel");
|
|
import("Vendor.PHPExcel.Writer.Excel5");
|
|
import("Vendor.PHPExcel.IOFactory.php");
|
|
$arr = file_get_contents($path2);
|
|
$arr = json_decode($arr, true);
|
|
$filename = "导入失败单据明细";
|
|
$headArr = array(
|
|
array('0', '商品名称'),
|
|
array('1', '条码'),
|
|
array('2', '货号'),
|
|
array('3', '进货量'),
|
|
array('4', '赠送量'),
|
|
array('5', '单位'),
|
|
array('6', '进货价'),
|
|
array('reson', '失败原因'),
|
|
);
|
|
unlink($path2);
|
|
$this->getExcel($filename, $headArr, $arr);
|
|
}
|
|
|
|
public function damage()
|
|
{
|
|
$arr = array(
|
|
'flow_damage_export' => '/index.php/Retail/Flow/flow_damage_export',
|
|
'showdamage' => '/index.php/Retail/Flow/showdamage',
|
|
'doauditreduce' => '/index.php/Retail/Flow/doauditreduce',
|
|
'cancelfloworder' => '/index.php/Retail/Flow/cancelfloworder',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
public function newdamage()
|
|
{
|
|
$storeid = session('storeid');
|
|
$order = M('retail_floworder')->where(array('audit' => 1, 'status' => 1, 'type' => 4, 'storeid' => $storeid))->find();
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
} else {
|
|
$Ad['storeid'] = $storeid;
|
|
$Ad['audit'] = 1;
|
|
$Ad['type'] = 4;
|
|
$Ad['status'] = 1;
|
|
$ret = M('retail_floworder')->add($Ad);
|
|
$floworderid = $ret;
|
|
}
|
|
session('floworderid', $floworderid);
|
|
$this->assign('floworderid', $floworderid);
|
|
$this->display();
|
|
}
|
|
|
|
public function damageorderlist()
|
|
{
|
|
$ordernum = I('get.ordernum');
|
|
if ($ordernum) {
|
|
$w['ordernum'] = $ordernum;
|
|
}
|
|
$supplier_id = I('get.supplier_id');
|
|
if ($supplier_id) {
|
|
$w['supplier_id'] = $supplier_id;
|
|
}
|
|
$date = I('get.date'); // 时间查询条件
|
|
if (!empty($date)) {
|
|
$time = explode('至', $date);
|
|
$start_time = strtotime(date('Y-m-d', strtotime($time[0])));
|
|
$end_time = strtotime(date('Y-m-d', strtotime($time[1]))) + 86400;
|
|
$w['ctime'] = array('between', array($start_time, $end_time));
|
|
}
|
|
$storeid = session('storeid');
|
|
$w['storeid'] = $storeid;
|
|
$w['status'] = 1;//正常单据。
|
|
$w['type'] = 4;//进货单。
|
|
$w['audit'] = array('in', array(2, 3));
|
|
$p = I('get.page');
|
|
$l = I('get.limit');
|
|
$count = M('retail_floworder')->where($w)->count();
|
|
$data = M('retail_floworder')->where($w)->page($p, $l)->order('ctime desc')->select();
|
|
if ($data) {
|
|
foreach ($data as $k => $v) {
|
|
$data[$k]['ctime'] = date('Y-m-d H:i:s', $v['ctime']);
|
|
$data[$k]['index'] = 1 + $k + ($p - 1) * $l;
|
|
$data[$k]['supplier'] = M('retail_supplier')->where(array('id' => $v['supplier_id']))->getField('supplier_name');
|
|
if ($v['admintype'] == 2) {
|
|
$data[$k]['adminname'] = M('retail_manager')->where(array('id' => $v['adminid']))->getField('name');
|
|
} else if ($v['admintype'] == 1) {
|
|
$data[$k]['adminname'] = M('retail_merchant')->where(array('id' => $v['adminid']))->getField('name');
|
|
}
|
|
if ($v['audit'] == 1) {
|
|
$data[$k]['auditname'] = '未确认';
|
|
} else if ($v['audit'] == 2) {
|
|
$data[$k]['auditname'] = '未审核';
|
|
} else if ($v['audit'] == 3) {
|
|
$data[$k]['auditname'] = '已审核';
|
|
}
|
|
}
|
|
}
|
|
$rt['code'] = 0;
|
|
$rt['msg'] = '';
|
|
$rt['count'] = $count;
|
|
$rt['data'] = $data;
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
|
|
// 报损单审核
|
|
public function doauditreduce()
|
|
{
|
|
if (IS_POST) {
|
|
$storeid = session('storeid');
|
|
$merchantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$id = I('post.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id, 'audit' => 2, 'type' => 4))->find();
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
$w['floworderid'] = $floworderid;
|
|
$w['status'] = 1;
|
|
$data = M('retail_flow')->where($w)->select();
|
|
// 循环添加库存
|
|
$time = time();
|
|
foreach ($data as $k => $v) {
|
|
$id = $v['goodsid'];
|
|
$goods_num = $v['num'] + $v['givenum'];
|
|
$supplier_id = $order['supplier_id'];
|
|
$old = M("retail_goods")->where(array('id' => $id))->getField("goods_num");
|
|
//首先判断id是否正确
|
|
$log['goods_id'] = $id;//商品id
|
|
$log['original_stock'] = $old;//初始库存
|
|
$log['do_num'] = $goods_num;//操作库存记录
|
|
$log['type'] = 2;//1表示库存增加
|
|
$log['addtime'] = $time;
|
|
$log['merchantid'] = $merchantid;
|
|
$log['storeid'] = $storeid;
|
|
$log['supplier_id'] = -1;
|
|
$log['present_stock'] = $old - $goods_num;
|
|
$log['floworderid'] = $order['id'];
|
|
$log['ordernum'] = $order['ordernum'];
|
|
$log['remark'] = '报损单审核减少库存';
|
|
$addLog = M("retail_quantity_logs")->add($log); // 添加库存记录
|
|
M('retail_goods')->where(array('id' => $id))->setDec('goods_num', $goods_num); // 系统库存添加。
|
|
}
|
|
$ret = M('retail_floworder')->where(array('id' => $floworderid))->save(array('audit' => 3));
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核成功';
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核失败';
|
|
}
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '改单据不能被审核';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
// 新建调货单。
|
|
public function newallocating()
|
|
{
|
|
$storeid = session('storeid');
|
|
$merchantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$order = M('retail_floworder')->where(array('audit' => 1, 'status' => 1, 'type' => 2, 'storeid' => $storeid))->find();
|
|
$StoreList = M('retail_store')->where(array('merchantid' => $merchantid, 'store_status' => 0, 'id' => array('neq', $storeid)))->select();
|
|
$this->assign('info', $StoreList);
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
} else {
|
|
$Ad['storeid'] = $storeid;
|
|
$Ad['audit'] = 1;
|
|
$Ad['type'] = 2;
|
|
$Ad['status'] = 1;
|
|
$ret = M('retail_floworder')->add($Ad);
|
|
$floworderid = $ret;
|
|
}
|
|
session('floworderid', $floworderid);
|
|
$this->assign('floworderid', $floworderid);
|
|
$this->display();
|
|
}
|
|
|
|
// 调货单
|
|
public function allocating()
|
|
{
|
|
$arr = array(
|
|
'flow_allocating_export' => '/index.php/Retail/Flow/flow_allocating_export',
|
|
'showallocating' => '/index.php/Retail/Flow/showallocating',
|
|
'doauditallocatingout' => '/index.php/Retail/Flow/doauditallocatingout',
|
|
'cancelfloworder' => '/index.php/Retail/Flow/cancelfloworder',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
public function allocatingorderlist()
|
|
{
|
|
$ordernum = I('get.ordernum');
|
|
if ($ordernum) {
|
|
$w['ordernum'] = $ordernum;
|
|
}
|
|
$date = I('get.date'); // 时间查询条件
|
|
if (!empty($date)) {
|
|
$time = explode('至', $date);
|
|
$start_time = strtotime(date('Y-m-d', strtotime($time[0])));
|
|
$end_time = strtotime(date('Y-m-d', strtotime($time[1]))) + 86400;
|
|
$w['ctime'] = array('between', array($start_time, $end_time));
|
|
}
|
|
$ordertype = I('get.ordertype');
|
|
$ordertype = $ordertype ? $ordertype : 1;
|
|
$storeid = session('storeid');
|
|
if ($ordertype == 1) {
|
|
$w['storeid'] = $storeid;
|
|
$w['audit'] = array('in', array(2, 3));
|
|
} else if ($ordertype == 2) {
|
|
$w['tostoreid'] = $storeid;
|
|
$w['audit'] = 3;
|
|
}
|
|
$w['status'] = 1;//正常单据。
|
|
$w['type'] = 2;//进货单。
|
|
$p = I('get.page');
|
|
$l = I('get.limit');
|
|
$count = M('retail_floworder')->where($w)->count();
|
|
$data = M('retail_floworder')->where($w)->page($p, $l)->order('ctime desc')->select();
|
|
if ($data) {
|
|
foreach ($data as $k => $v) {
|
|
$data[$k]['ctime'] = date('Y-m-d H:i:s', $v['ctime']);
|
|
$data[$k]['index'] = 1 + $k + ($p - 1) * $l;
|
|
$data[$k]['ordertype'] = $ordertype;
|
|
$data[$k]['supplier'] = M('retail_supplier')->where(array('id' => $v['supplier_id']))->getField('supplier_name');
|
|
if ($v['admintype'] == 2) {
|
|
$data[$k]['adminname'] = M('retail_manager')->where(array('id' => $v['adminid']))->getField('name');
|
|
} else if ($v['admintype'] == 1) {
|
|
$data[$k]['adminname'] = M('retail_merchant')->where(array('id' => $v['adminid']))->getField('name');
|
|
}
|
|
if ($ordertype == 1) {
|
|
if ($v['audit'] == 1) {
|
|
$data[$k]['auditname'] = '未确认';
|
|
} else if ($v['audit'] == 2) {
|
|
$data[$k]['auditname'] = '未审核';
|
|
} else if ($v['audit'] == 3) {
|
|
$data[$k]['auditname'] = '已审核';
|
|
if ($v['toaudit'] == 1) {
|
|
$data[$k]['auditname'] = '已审核（未确认）';
|
|
} else if ($v['toaudit'] == 4) {
|
|
$data[$k]['auditname'] = '已审核（已拒绝）';
|
|
} else {
|
|
$data[$k]['auditname'] = '已审核（已接收）';
|
|
}
|
|
}
|
|
$data[$k]['tostoreid'] = M('retail_store')->where(array('id' => $v['tostoreid']))->getField('storetag');
|
|
} else if ($ordertype == 2) {
|
|
if ($v['toaudit'] == 1) {
|
|
$data[$k]['auditname'] = '等待确认';
|
|
} else if ($v['toaudit'] == 2) {
|
|
$data[$k]['auditname'] = '确认未审核';
|
|
} else if ($v['toaudit'] == 3) {
|
|
$data[$k]['auditname'] = '已审核';
|
|
} else if ($v['toaudit'] == 4) {
|
|
$data[$k]['auditname'] = '已拒绝';
|
|
}
|
|
$data[$k]['tostoreid'] = M('retail_store')->where(array('id' => $v['storeid']))->getField('storetag');
|
|
}
|
|
}
|
|
}
|
|
$rt['code'] = 0;
|
|
$rt['msg'] = '';
|
|
$rt['count'] = $count;
|
|
$rt['data'] = $data;
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
|
|
// 展示调货单详情
|
|
public function showallocating()
|
|
{
|
|
$storeid = session('storeid');
|
|
$id = I('get.id');
|
|
$ordertype = I('get.type');
|
|
$merchantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$order = M('retail_floworder')->where(array('status' => 1, 'type' => 2, 'id' => $id))->find();
|
|
$StoreList = M('retail_store')->where(array('merchantid' => $merchantid, 'store_status' => 0, 'id' => array('neq', $storeid)))->select();
|
|
if ($ordertype == 2) {
|
|
$order['tostoreid'] = $order['storeid'];
|
|
$str = '调入单据';
|
|
} else {
|
|
$str = '调出单据';
|
|
}
|
|
$this->assign('str', $str);
|
|
$this->assign('info', $StoreList);
|
|
$this->assign('order', $order);
|
|
$this->display();
|
|
}
|
|
|
|
// 确认审核调出单---不会减少库存
|
|
public function doauditallocatingout()
|
|
{
|
|
if (IS_POST) {
|
|
$id = I('post.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id, 'audit' => 2, 'type' => 2))->find();
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
$ret = M('retail_floworder')->where(array('id' => $floworderid))->save(array('audit' => 3));
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核成功';
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核失败';
|
|
}
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '改单据不能被审核';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
// 确认调入单。---发货门店将减少库存。
|
|
public function toauditallocating()
|
|
{
|
|
if (IS_POST) {
|
|
$storeid = session('storeid');
|
|
$merchantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$id = I('post.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id, 'audit' => 3, 'type' => 2, 'toaudit' => 1))->find();
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
$w['floworderid'] = $floworderid;
|
|
$w['status'] = 1;
|
|
$data = M('retail_flow')->where($w)->select();
|
|
// 循环添加库存
|
|
$time = time();
|
|
$storeid = $order['storeid']; // 发货门店。
|
|
foreach ($data as $k => $v) {
|
|
$id = $v['goodsid'];
|
|
$goods_num = $v['num'] + $v['givenum'];
|
|
$old = M("retail_goods")->where(array('id' => $id))->getField("goods_num");
|
|
//首先判断id是否正确
|
|
$log['goods_id'] = $id;//商品id
|
|
$log['original_stock'] = $old;//初始库存
|
|
$log['do_num'] = $goods_num;//操作库存记录
|
|
$log['type'] = 2;//1表示库存增加
|
|
$log['addtime'] = $time;
|
|
$log['merchantid'] = $merchantid;
|
|
$log['storeid'] = $storeid;
|
|
$log['supplier_id'] = -2;
|
|
$log['present_stock'] = $old - $goods_num;
|
|
$log['floworderid'] = $order['id'];
|
|
$log['ordernum'] = $order['ordernum'];
|
|
$log['remark'] = '调出单被确认-减少库存';
|
|
$addLog = M("retail_quantity_logs")->add($log); // 添加库存记录
|
|
M('retail_goods')->where(array('id' => $id))->setDec('goods_num', $goods_num); // 系统库存添加。
|
|
}
|
|
$ret = M('retail_floworder')->where(array('id' => $floworderid))->save(array('toaudit' => 2));
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核成功';
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核失败';
|
|
}
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '该单据不能被审核';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
// 审核调入商品
|
|
|
|
public function toauditallocatingin()
|
|
{
|
|
$id = I('post.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id, 'type' => 2, 'toaudit' => 2))->find();
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
$ret = M('retail_floworder')->where(array('id' => $floworderid))->save(array('toaudit' => 3));
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核成功';
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核失败';
|
|
}
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '改单据不能被审核';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
|
|
// 拒绝跳入单据
|
|
|
|
public function canceltoauditallocating()
|
|
{
|
|
$id = I('post.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id, 'type' => 2, 'toaudit' => 1))->find();
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
$ret = M('retail_floworder')->where(array('id' => $floworderid))->save(array('toaudit' => 4));
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核成功';
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核失败';
|
|
}
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '改单据不能被审核';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
|
|
// 退货出库------------------
|
|
// 新建退货单
|
|
public function newrefund()
|
|
{
|
|
$storeid = session('storeid');
|
|
$merchantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$order = M('retail_floworder')->where(array('audit' => 1, 'status' => 1, 'type' => 3, 'storeid' => $storeid))->find();
|
|
$supplier = M("retail_supplier")->where(array('merchantid' => $merchantid, 'status' => 1))->select();
|
|
$this->assign('info', $supplier);
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
} else {
|
|
$Ad['storeid'] = $storeid;
|
|
$Ad['audit'] = 1;
|
|
$Ad['type'] = 3;
|
|
$Ad['status'] = 1;
|
|
$ret = M('retail_floworder')->add($Ad);
|
|
$floworderid = $ret;
|
|
}
|
|
session('floworderid', $floworderid);
|
|
$this->assign('floworderid', $floworderid);
|
|
$this->display();
|
|
}
|
|
|
|
// 退货单列表
|
|
public function refund()
|
|
{
|
|
$storeid = session('storeid');
|
|
$catemachantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$supplier = M("retail_supplier")->where(array('merchantid' => $catemachantid, 'status' => 1))->select();
|
|
$this->assign('info', $supplier);
|
|
$arr = array(
|
|
'flow_refund_export' => '/index.php/Retail/Flow/flow_refund_export',
|
|
'showrefund' => '/index.php/Retail/Flow/showrefund',
|
|
'dorefund' => '/index.php/Retail/Flow/dorefund',
|
|
'cancelfloworder' => '/index.php/Retail/Flow/cancelfloworder',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
public function refundlist()
|
|
{
|
|
$ordernum = I('get.ordernum');
|
|
if ($ordernum) {
|
|
$w['ordernum'] = $ordernum;
|
|
}
|
|
$supplier_id = I('get.supplier_id');
|
|
if ($supplier_id) {
|
|
$w['supplier_id'] = $supplier_id;
|
|
}
|
|
$date = I('get.date'); // 时间查询条件
|
|
if (!empty($date)) {
|
|
$time = explode('至', $date);
|
|
$start_time = strtotime(date('Y-m-d', strtotime($time[0])));
|
|
$end_time = strtotime(date('Y-m-d', strtotime($time[1]))) + 86400;
|
|
$w['ctime'] = array('between', array($start_time, $end_time));
|
|
}
|
|
$storeid = session('storeid');
|
|
$w['storeid'] = $storeid;
|
|
$w['status'] = 1;//正常单据。
|
|
$w['type'] = 3;//退货单。
|
|
$w['audit'] = array('in', array(2, 3));
|
|
$p = I('get.page');
|
|
$l = I('get.limit');
|
|
$count = M('retail_floworder')->where($w)->count();
|
|
$data = M('retail_floworder')->where($w)->page($p, $l)->order('ctime desc')->select();
|
|
if ($data) {
|
|
foreach ($data as $k => $v) {
|
|
$data[$k]['ctime'] = date('Y-m-d H:i:s', $v['ctime']);
|
|
$data[$k]['index'] = 1 + $k + ($p - 1) * $l;
|
|
$data[$k]['supplier'] = M('retail_supplier')->where(array('id' => $v['supplier_id']))->getField('supplier_name');
|
|
if ($v['admintype'] == 2) {
|
|
$data[$k]['adminname'] = M('retail_manager')->where(array('id' => $v['adminid']))->getField('name');
|
|
} else if ($v['admintype'] == 1) {
|
|
$data[$k]['adminname'] = M('retail_merchant')->where(array('id' => $v['adminid']))->getField('name');
|
|
}
|
|
if ($v['audit'] == 1) {
|
|
$data[$k]['auditname'] = '未确认';
|
|
} else if ($v['audit'] == 2) {
|
|
$data[$k]['auditname'] = '未审核';
|
|
} else if ($v['audit'] == 3) {
|
|
$data[$k]['auditname'] = '已审核';
|
|
}
|
|
}
|
|
}
|
|
$rt['code'] = 0;
|
|
$rt['msg'] = '';
|
|
$rt['count'] = $count;
|
|
$rt['data'] = $data;
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
|
|
// 审核退款
|
|
public function dorefund()
|
|
{
|
|
if (IS_POST) {
|
|
$storeid = session('storeid');
|
|
$merchantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$id = I('post.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id, 'audit' => 2, 'type' => 3))->find();
|
|
if ($order) {
|
|
$floworderid = $order['id'];
|
|
$w['floworderid'] = $floworderid;
|
|
$w['status'] = 1;
|
|
$data = M('retail_flow')->where($w)->select();
|
|
// 循环添加库存
|
|
$time = time();
|
|
foreach ($data as $k => $v) {
|
|
$id = $v['goodsid'];
|
|
$goods_num = $v['num'] + $v['givenum'];
|
|
$old = M("retail_goods")->where(array('id' => $id))->getField("goods_num");
|
|
//首先判断id是否正确
|
|
$log['goods_id'] = $id;//商品id
|
|
$log['original_stock'] = $old;//初始库存
|
|
$log['do_num'] = $goods_num;//操作库存记录
|
|
$log['type'] = 2;//1表示库存增加
|
|
$log['addtime'] = $time;
|
|
$log['merchantid'] = $merchantid;
|
|
$log['storeid'] = $storeid;
|
|
$log['supplier_id'] = -3;
|
|
$log['present_stock'] = $old - $goods_num;
|
|
$log['floworderid'] = $order['id'];
|
|
$log['ordernum'] = $order['ordernum'];
|
|
$log['remark'] = '退货单审核减少库存';
|
|
$addLog = M("retail_quantity_logs")->add($log); // 添加库存记录
|
|
M('retail_goods')->where(array('id' => $id))->setDec('goods_num', $goods_num); // 系统库存添加。
|
|
}
|
|
$ret = M('retail_floworder')->where(array('id' => $floworderid))->save(array('audit' => 3));
|
|
if ($ret) {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核成功';
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '审核失败';
|
|
}
|
|
} else {
|
|
$rt['status'] = 1;
|
|
$rt['msg'] = '改单据不能被审核';
|
|
}
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
}
|
|
|
|
// 退货单详情
|
|
public function showrefund()
|
|
{
|
|
$storeid = session('storeid');
|
|
$catemachantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$supplier = M("retail_supplier")->where(array('merchantid' => $catemachantid, 'status' => 1))->select();
|
|
$this->assign('info', $supplier);
|
|
$id = I('get.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id))->find();
|
|
$this->assign('order', $order);
|
|
$arr = array(
|
|
'expUser' => '/index.php/Retail/Flow/expUser',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
// 退货单打印页面
|
|
public function printrefundflow()
|
|
{
|
|
$storeid = session('storeid');
|
|
$store = M('retail_store')->where(array('id' => $storeid))->find();
|
|
$this->assign('store', $store);
|
|
$id = I('get.id');
|
|
$order = M('retail_floworder')->where(array('id' => $id))->find();
|
|
$supplier = M("retail_supplier")->where(array('id' => $order['supplier_id'], 'status' => 1))->find();
|
|
$manager = M('retail_manager')->where(array('storeid' => $storeid, 'status' => 1))->find();
|
|
$this->assign('manager', $manager);
|
|
$this->assign('supplier', $supplier);
|
|
$this->assign('time', date('Y-m-d H:i:s'));
|
|
$this->assign('order', $order);
|
|
$this->display();
|
|
}
|
|
|
|
// 货流金额数据列表。
|
|
|
|
public function flowmoneylist()
|
|
{
|
|
$arr = array(
|
|
'exportflowmoney' => '/index.php/Retail/Flow/exportflowmoney',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
public function flowmoneylistinfo()
|
|
{
|
|
$storeid = session('storeid');
|
|
$where2['tostoreid'] = $storeid;
|
|
$where2['toaudit'] = array('in', '2,3');
|
|
$where2['_logic'] = 'and';
|
|
$where['_complex'] = $where2;
|
|
$where['storeid'] = $storeid;
|
|
$where['_logic'] = 'or';
|
|
$map['_complex'] = $where;
|
|
$map['status'] = 1;
|
|
$map['audit'] = 3;
|
|
$type = I('get.type');
|
|
if ($type) {
|
|
$map['type'] = $type;
|
|
}
|
|
$p = I('get.page');
|
|
$l = I('get.limit');
|
|
$data = M('retail_floworder')->where($map)->page($p, $l)->order('ctime desc')->select();
|
|
$count = M('retail_floworder')->where($map)->count();
|
|
foreach ($data as $k => $v) {
|
|
$data[$k]['ctime'] = date('Y-m-d H:i:s', $v['ctime']);
|
|
$data[$k]['index'] = 1 + $k + ($p - 1) * $l;
|
|
$data[$k]['supplier'] = M('retail_supplier')->where(array('id' => $v['supplier_id']))->getField('supplier_name');
|
|
if ($v['admintype'] == 2) {
|
|
$data[$k]['adminname'] = M('retail_manager')->where(array('id' => $v['adminid']))->getField('name');
|
|
} else if ($v['admintype'] == 1) {
|
|
$data[$k]['adminname'] = M('retail_merchant')->where(array('id' => $v['adminid']))->getField('name');
|
|
}
|
|
if ($v['type'] == 1) {
|
|
$data[$k]['type'] = '进货单';
|
|
$data[$k]['allnum'] = $data[$k]['allnum'] + $data[$k]['allgivenum'];
|
|
} else if ($v['type'] == 2) {
|
|
$data[$k]['type'] = '调拨单';
|
|
if ($data[$k]['storeid'] == $storeid) {
|
|
$data[$k]['type'] = '调拨单(调出)';
|
|
} else if ($data[$k]['tostoreid'] == $storeid) {
|
|
$data[$k]['type'] = '调拨单(调入)';
|
|
}
|
|
} else if ($v['type'] == 3) {
|
|
$data[$k]['type'] = '退货单';
|
|
} else if ($v['type'] == 4) {
|
|
$data[$k]['type'] = '报损单';
|
|
}
|
|
$data[$k]['allmoney'] = round(($v['allmoney'] - $v['dismoney']), 2);
|
|
}
|
|
$rt['code'] = 0;
|
|
$rt['msg'] = '';
|
|
$rt['count'] = $count;
|
|
$rt['data'] = $data;
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
|
|
public function money()
|
|
{
|
|
$storeid = session('storeid');
|
|
$map['storeid'] = $storeid;
|
|
$map['status'] = 1;
|
|
$map['audit'] = 3;
|
|
$map['type'] = 1;
|
|
$type1 = M('retail_floworder')->where($map)->sum('allmoney - dismoney');
|
|
$map['type'] = 3;
|
|
$type3 = M('retail_floworder')->where($map)->sum('allmoney - dismoney');
|
|
$map['type'] = 4;
|
|
$type4 = M('retail_floworder')->where($map)->sum('allmoney - dismoney');
|
|
// $map21['storeid'] = $storeid;
|
|
$map21['tostoreid'] = $storeid;
|
|
$map21['status'] = 1;
|
|
$map21['type'] = 2;
|
|
$map21['toaudit'] = array('in', '2,3');
|
|
$map21['audit'] = 3;
|
|
$type21 = M('retail_floworder')->where($map21)->sum('allmoney - dismoney');
|
|
// $map22['tostoreid'] = $storeid;
|
|
$map22['storeid'] = $storeid;
|
|
$map22['status'] = 1;
|
|
$map22['type'] = 2;
|
|
$map22['toaudit'] = array('in', '2,3');
|
|
$map22['audit'] = 3;
|
|
$type22 = M('retail_floworder')->where($map22)->sum('allmoney - dismoney');
|
|
$rt['type1'] = $type1 ? round($type1, 2) : 0;
|
|
$rt['type21'] = $type21 ? round($type21, 2) : 0;
|
|
$rt['type22'] = $type22 ? round($type22, 2) : 0;
|
|
$rt['type3'] = $type3 ? round($type3, 2) : 0;
|
|
$rt['type4'] = $type4 ? round($type4, 2) : 0;
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
|
|
// 按类型导出货流账单
|
|
|
|
public function exportflowmoney()
|
|
{
|
|
$storeid = session('storeid');
|
|
$type = I('get.type');
|
|
if (!$type) {
|
|
$this->error('请选择一种类型再导出');
|
|
}
|
|
$w['status'] = 1;
|
|
$w['storeid'] = $storeid;
|
|
//导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
|
|
import("Vendor.PHPExcel.PHPExcel");
|
|
import("Vendor.PHPExcel.Writer.Excel5");
|
|
import("Vendor.PHPExcel.IOFactory.php");
|
|
if ($type == '1') {
|
|
// 进货单
|
|
$w['audit'] = 3;
|
|
$w['type'] = 1;
|
|
$data = M('retail_floworder')->where($w)->select();
|
|
foreach ($data as $k => $v) {
|
|
$data[$k]['ctime'] = date('Y-m-d H:i:s', $v['ctime']);
|
|
if ($v['supplier_id'] == 0) {
|
|
$data[$k]['supplier'] = '自采/其他';
|
|
} else {
|
|
$data[$k]['supplier'] = M('retail_supplier')->where(array('id' => $v['supplier_id']))->getField('supplier_name');
|
|
}
|
|
if ($v['admintype'] == 2) {
|
|
$data[$k]['adminname'] = M('retail_manager')->where(array('id' => $v['adminid']))->getField('name');
|
|
} else if ($v['admintype'] == 1) {
|
|
$data[$k]['adminname'] = M('retail_merchant')->where(array('id' => $v['adminid']))->getField('name');
|
|
}
|
|
}
|
|
$filename = "进货单账单";
|
|
$headArr = array(
|
|
array('supplier', '供货商'),
|
|
array('ctime', '制单时间'),
|
|
array('allmoney', '总金额'),
|
|
array('dismoney', '优惠金额'),
|
|
array('paymoney', '结算金额'),
|
|
array('allnum', '进货数量'),
|
|
array('allgivenum', '赠送数量'),
|
|
array('ordernum', '单据号'),
|
|
array('adminname', '操作人'),
|
|
);
|
|
} else if ($type == '3') {
|
|
// 进货单
|
|
$w['audit'] = 3;
|
|
$w['type'] = 3;
|
|
$data = M('retail_floworder')->where($w)->select();
|
|
foreach ($data as $k => $v) {
|
|
$data[$k]['ctime'] = date('Y-m-d H:i:s', $v['ctime']);
|
|
if ($v['supplier_id'] == 0) {
|
|
$data[$k]['supplier'] = '自采/其他';
|
|
} else {
|
|
$data[$k]['supplier'] = M('retail_supplier')->where(array('id' => $v['supplier_id']))->getField('supplier_name');
|
|
}
|
|
if ($v['admintype'] == 2) {
|
|
$data[$k]['adminname'] = M('retail_manager')->where(array('id' => $v['adminid']))->getField('name');
|
|
} else if ($v['admintype'] == 1) {
|
|
$data[$k]['adminname'] = M('retail_merchant')->where(array('id' => $v['adminid']))->getField('name');
|
|
}
|
|
}
|
|
$filename = "退货单账单";
|
|
$headArr = array(
|
|
array('supplier', '供货商'),
|
|
array('ctime', '制单时间'),
|
|
array('allmoney', '总金额'),
|
|
array('dismoney', '修改金额'),
|
|
array('paymoney', '结算金额'),
|
|
array('allnum', '退货数量'),
|
|
array('ordernum', '单据号'),
|
|
array('adminname', '操作人'),
|
|
);
|
|
} else if ($type == '4') {
|
|
// 进货单
|
|
$w['audit'] = 3;
|
|
$w['type'] = 4;
|
|
$data = M('retail_floworder')->where($w)->select();
|
|
foreach ($data as $k => $v) {
|
|
$data[$k]['ctime'] = date('Y-m-d H:i:s', $v['ctime']);
|
|
if ($v['supplier_id'] == 0) {
|
|
$data[$k]['supplier'] = '自采/其他';
|
|
} else {
|
|
$data[$k]['supplier'] = M('retail_supplier')->where(array('id' => $v['supplier_id']))->getField('supplier_name');
|
|
}
|
|
if ($v['admintype'] == 2) {
|
|
$data[$k]['adminname'] = M('retail_manager')->where(array('id' => $v['adminid']))->getField('name');
|
|
} else if ($v['admintype'] == 1) {
|
|
$data[$k]['adminname'] = M('retail_merchant')->where(array('id' => $v['adminid']))->getField('name');
|
|
}
|
|
}
|
|
$filename = "报损单账单";
|
|
$headArr = array(
|
|
array('ctime', '制单时间'),
|
|
array('allmoney', '总金额'),
|
|
array('paymoney', '报损金额'),
|
|
array('allnum', '报损数量'),
|
|
array('ordernum', '单据号'),
|
|
array('adminname', '操作人'),
|
|
);
|
|
} else if ($type == '2') {
|
|
// 进货单
|
|
$where2['tostoreid'] = $storeid;
|
|
$where2['toaudit'] = array('in', '2,3');
|
|
$where2['_logic'] = 'and';
|
|
$where['_complex'] = $where2;
|
|
$where['storeid'] = $storeid;
|
|
$where['_logic'] = 'or';
|
|
$map['_complex'] = $where;
|
|
$map['status'] = 1;
|
|
$map['audit'] = 3;
|
|
$map['type'] = 2;
|
|
$data = M('retail_floworder')->where($map)->select();
|
|
foreach ($data as $k => $v) {
|
|
$data[$k]['ctime'] = date('Y-m-d H:i:s', $v['ctime']);
|
|
if ($v['admintype'] == 2) {
|
|
$data[$k]['adminname'] = M('retail_manager')->where(array('id' => $v['adminid']))->getField('name');
|
|
} else if ($v['admintype'] == 1) {
|
|
$data[$k]['adminname'] = M('retail_merchant')->where(array('id' => $v['adminid']))->getField('name');
|
|
}
|
|
if ($data[$k]['storeid'] == $storeid) {
|
|
$data[$k]['type'] = '调拨单(调出)';
|
|
$data[$k]['storetag'] = M('retail_store')->where(array('id' => $v['tostoreid']))->getField('storetag');
|
|
} else if ($data[$k]['tostoreid'] == $storeid) {
|
|
$data[$k]['type'] = '调拨单(调入)';
|
|
$data[$k]['storetag'] = M('retail_store')->where(array('id' => $v['storeid']))->getField('storetag');
|
|
}
|
|
}
|
|
$filename = "报损单账单";
|
|
$headArr = array(
|
|
array('storetag', '调拨门店'),
|
|
array('ctime', '制单时间'),
|
|
array('allmoney', '总金额'),
|
|
array('paymoney', '结算金额'),
|
|
array('allnum', '调拨数量'),
|
|
array('ordernum', '单据号'),
|
|
array('adminname', '操作人'),
|
|
);
|
|
}
|
|
$this->getExcel($filename, $headArr, $data, $str = "");
|
|
}
|
|
|
|
// 进货单导出明细
|
|
public function flow_order_export()
|
|
{
|
|
$date = I('get.date'); // 日期
|
|
$ordernum = I('get.ordernum'); // 单号
|
|
$supplier_id = I('get.supplier_id'); // 供货商
|
|
$storeid = session('storeid');
|
|
if (!empty($date)) { // 时间查询条件 默认当天
|
|
$time = explode('至', $date);
|
|
$start_time = strtotime(date('Y-m-d', strtotime($time[0])));
|
|
$end_time = strtotime(date('Y-m-d', strtotime($time[1]))) + 86400;
|
|
$where['ctime'] = array('between', array($start_time, $end_time));
|
|
} else {
|
|
$start_time = strtotime(date('Y-m-d', time()));
|
|
$end_time = strtotime(date('Y-m-d', time())) + 86400;
|
|
$where['ctime'] = array('between', array($start_time, $end_time));
|
|
}
|
|
if (!empty($ordernum)) { // 单号查询条件
|
|
$where['ordernum'] = $ordernum;
|
|
}
|
|
if (!empty($supplier_id)) {
|
|
$where['supplier_id'] = $supplier_id;
|
|
}
|
|
$where['type'] = 1; // 进货单
|
|
$where['status'] = 1; // 订单状态
|
|
$where['storeid'] = $storeid;
|
|
$where['audit'] = array('in', array(2, 3));
|
|
//根据条件查出收款明细
|
|
$floworder = M('retail_floworder')->where($where)->order('ctime desc')->select();
|
|
if (!empty($floworder)) {
|
|
foreach ($floworder as $key => &$val) {
|
|
$val['key'] = $key + 1;
|
|
$val['ctime'] = date('Y-m-d H:i:s', $val['ctime']);
|
|
if ($val['supplier_id'] == 0) {
|
|
$val['supplier'] = '自采/其他';
|
|
} else {
|
|
$val['supplier'] = M('retail_supplier')->where(array('id' => $val['supplier_id']))->getField('supplier_name');
|
|
}
|
|
if ($val['admintype'] == 2) {
|
|
$val['adminname'] = M('retail_manager')->where(array('id' => $val['adminid']))->getField('name');
|
|
} else if ($val['admintype'] == 1) {
|
|
$val['adminname'] = M('retail_merchant')->where(array('id' => $val['adminid']))->getField('name');
|
|
}
|
|
if ($val['audit'] == 1) {
|
|
$val['audit'] = '未确定';
|
|
} else if ($val['audit'] == 2) {
|
|
$val['audit'] = '未审核';
|
|
} else {
|
|
$val['audit'] = '已审核';
|
|
}
|
|
}
|
|
} else {
|
|
$floworder = array();
|
|
}
|
|
$floworder_name = '进货单明细';
|
|
$headArr = array(
|
|
array('key', '序号'),
|
|
array('ordernum', '进货单号'),
|
|
array('supplier', '供货商'),
|
|
array('ctime', '制单时间'),
|
|
array('adminname', '制单人'),
|
|
array('allnum', '进货量'),
|
|
array('allgivenum', '赠送量'),
|
|
array('allmoney', '总金额'),
|
|
array('dismoney', '优惠金额'),
|
|
array('paymoney', '支付金额'),
|
|
array('audit', '单据状态')
|
|
);
|
|
$str = $floworder_name . '导出时间' . date('Y-m-d H:i:s', time());
|
|
$this->getExcel($floworder_name, $headArr, $floworder, $str);
|
|
}
|
|
|
|
// 退货单导出明细
|
|
public function flow_refund_export()
|
|
{
|
|
$date = I('get.date'); // 日期
|
|
$ordernum = I('get.ordernum'); // 单号
|
|
$supplier_id = I('get.supplier_id'); // 供货商
|
|
$storeid = session('storeid');
|
|
if (!empty($date)) { // 时间查询条件 默认当天
|
|
$time = explode('至', $date);
|
|
$start_time = strtotime(date('Y-m-d', strtotime($time[0])));
|
|
$end_time = strtotime(date('Y-m-d', strtotime($time[1]))) + 86400;
|
|
$where['ctime'] = array('between', array($start_time, $end_time));
|
|
} else {
|
|
$start_time = strtotime(date('Y-m-d', time()));
|
|
$end_time = strtotime(date('Y-m-d', time())) + 86400;
|
|
$where['ctime'] = array('between', array($start_time, $end_time));
|
|
}
|
|
if (!empty($ordernum)) { // 单号查询条件
|
|
$where['ordernum'] = $ordernum;
|
|
}
|
|
if (!empty($supplier_id)) {
|
|
$where['supplier_id'] = $supplier_id;
|
|
}
|
|
$where['type'] = 3; // 退货单
|
|
$where['status'] = 1; // 订单状态
|
|
$where['storeid'] = $storeid;
|
|
$where['audit'] = array('in', array(2, 3));
|
|
//根据条件查出收款明细
|
|
$flow_refund = M('retail_floworder')->where($where)->order('ctime desc')->select();
|
|
if (!empty($flow_refund)) {
|
|
foreach ($flow_refund as $key => &$val) {
|
|
$val['key'] = $key + 1;
|
|
$val['ctime'] = date('Y-m-d H:i:s', $val['ctime']);
|
|
if ($val['supplier_id'] == 0) {
|
|
$val['supplier'] = '自采/其他';
|
|
} else {
|
|
$val['supplier'] = M('retail_supplier')->where(array('id' => $val['supplier_id']))->getField('supplier_name');
|
|
}
|
|
if ($val['admintype'] == 2) {
|
|
$val['adminname'] = M('retail_manager')->where(array('id' => $val['adminid']))->getField('name');
|
|
} else if ($val['admintype'] == 1) {
|
|
$val['adminname'] = M('retail_merchant')->where(array('id' => $val['adminid']))->getField('name');
|
|
}
|
|
if ($val['audit'] == 1) {
|
|
$val['audit'] = '未确定';
|
|
} else if ($val['audit'] == 2) {
|
|
$val['audit'] = '未审核';
|
|
} else {
|
|
$val['audit'] = '已审核';
|
|
}
|
|
}
|
|
} else {
|
|
$flow_refund = array();
|
|
}
|
|
$flow_refund_name = '退货单明细';
|
|
$headArr = array(
|
|
array('key', '序号'),
|
|
array('ordernum', '进货单号'),
|
|
array('supplier', '供货商'),
|
|
array('ctime', '制单时间'),
|
|
array('adminname', '制单人'),
|
|
array('allnum', '退货量'),
|
|
array('allmoney', '总金额'),
|
|
array('dismoney', '修改金额'),
|
|
array('paymoney', '支付金额'),
|
|
array('audit', '单据状态')
|
|
);
|
|
$str = $flow_refund_name . '导出时间' . date('Y-m-d H:i:s', time());
|
|
$this->getExcel($flow_refund_name, $headArr, $flow_refund, $str);
|
|
}
|
|
|
|
// 报损单导出明细
|
|
public function flow_damage_export()
|
|
{
|
|
$date = I('get.date'); // 日期
|
|
$ordernum = I('get.ordernum'); // 单号
|
|
$supplier_id = I('get.supplier_id'); // 供货商
|
|
$storeid = session('storeid');
|
|
if (!empty($date)) { // 时间查询条件 默认当天
|
|
$time = explode('至', $date);
|
|
$start_time = strtotime(date('Y-m-d', strtotime($time[0])));
|
|
$end_time = strtotime(date('Y-m-d', strtotime($time[1]))) + 86400;
|
|
$where['ctime'] = array('between', array($start_time, $end_time));
|
|
} else {
|
|
$start_time = strtotime(date('Y-m-d', time()));
|
|
$end_time = strtotime(date('Y-m-d', time())) + 86400;
|
|
$where['ctime'] = array('between', array($start_time, $end_time));
|
|
}
|
|
if (!empty($ordernum)) { // 单号查询条件
|
|
$where['ordernum'] = $ordernum;
|
|
}
|
|
if (!empty($supplier_id)) {
|
|
$where['supplier_id'] = $supplier_id;
|
|
}
|
|
$where['type'] = 4; // 退货单
|
|
$where['status'] = 1; // 订单状态
|
|
$where['storeid'] = $storeid;
|
|
$where['audit'] = array('in', array(2, 3));
|
|
//根据条件查出收款明细
|
|
$flow_damage = M('retail_floworder')->where($where)->order('ctime desc')->select();
|
|
if (!empty($flow_damage)) {
|
|
foreach ($flow_damage as $key => &$val) {
|
|
$val['key'] = $key + 1;
|
|
$val['ctime'] = date('Y-m-d H:i:s', $val['ctime']);
|
|
if ($val['supplier_id'] == 0) {
|
|
$val['supplier'] = '自采/其他';
|
|
} else {
|
|
$val['supplier'] = M('retail_supplier')->where(array('id' => $val['supplier_id']))->getField('supplier_name');
|
|
}
|
|
if ($val['admintype'] == 2) {
|
|
$val['adminname'] = M('retail_manager')->where(array('id' => $val['adminid']))->getField('name');
|
|
} else if ($val['admintype'] == 1) {
|
|
$val['adminname'] = M('retail_merchant')->where(array('id' => $val['adminid']))->getField('name');
|
|
}
|
|
if ($val['audit'] == 1) {
|
|
$val['audit'] = '未确定';
|
|
} else if ($val['audit'] == 2) {
|
|
$val['audit'] = '未审核';
|
|
} else {
|
|
$val['audit'] = '已审核';
|
|
}
|
|
}
|
|
} else {
|
|
$flow_damage = array();
|
|
}
|
|
$flow_damage_name = '报损单明细';
|
|
$headArr = array(
|
|
array('key', '序号'),
|
|
array('ordernum', '进货单号'),
|
|
array('ctime', '制单时间'),
|
|
array('adminname', '制单人'),
|
|
array('allnum', '报损量'),
|
|
array('allmoney', '报损总金额'),
|
|
array('audit', '单据状态')
|
|
);
|
|
$str = $flow_damage_name . '导出时间' . date('Y-m-d H:i:s', time());
|
|
$this->getExcel($flow_damage_name, $headArr, $flow_damage, $str);
|
|
}
|
|
|
|
// 调拨单导出明细
|
|
public function flow_allocating_export()
|
|
{
|
|
$date = I('get.date'); // 日期
|
|
$ordernum = I('get.ordernum'); // 单号
|
|
$ordertype = I('get.ordertype'); // 订单类型
|
|
$storeid = session('storeid');
|
|
if (!empty($date)) { // 时间查询条件 默认当天
|
|
$time = explode('至', $date);
|
|
$start_time = strtotime(date('Y-m-d', strtotime($time[0])));
|
|
$end_time = strtotime(date('Y-m-d', strtotime($time[1]))) + 86400;
|
|
$where['ctime'] = array('between', array($start_time, $end_time));
|
|
} else {
|
|
$start_time = strtotime(date('Y-m-d', time()));
|
|
$end_time = strtotime(date('Y-m-d', time())) + 86400;
|
|
$where['ctime'] = array('between', array($start_time, $end_time));
|
|
}
|
|
if (!empty($ordernum)) { // 单号查询条件
|
|
$where['ordernum'] = $ordernum;
|
|
}
|
|
|
|
$ordertype = $ordertype ? $ordertype : 1;
|
|
if ($ordertype == 1) {
|
|
$where['storeid'] = $storeid;
|
|
$where['audit'] = array('in', array(2, 3));
|
|
} else if ($ordertype == 2) {
|
|
$where['tostoreid'] = $storeid;
|
|
$where['audit'] = 3;
|
|
}
|
|
$where['type'] = 2; // 退货单
|
|
$where['status'] = 1; // 订单状态
|
|
//根据条件查出收款明细
|
|
$flow_allocating = M('retail_floworder')->where($where)->order('ctime desc')->select();
|
|
if (!empty($flow_allocating)) {
|
|
foreach ($flow_allocating as $key => &$val) {
|
|
$val['key'] = $key + 1;
|
|
$val['ctime'] = date('Y-m-d H:i:s', $val['ctime']);
|
|
$val['ordertype'] = $ordertype;
|
|
if ($val['supplier_id'] == 0) {
|
|
$val['supplier'] = '自采/其他';
|
|
} else {
|
|
$val['supplier'] = M('retail_supplier')->where(array('id' => $val['supplier_id']))->getField('supplier_name');
|
|
}
|
|
if ($val['admintype'] == 2) {
|
|
$val['adminname'] = M('retail_manager')->where(array('id' => $val['adminid']))->getField('name');
|
|
} else if ($val['admintype'] == 1) {
|
|
$val['adminname'] = M('retail_merchant')->where(array('id' => $val['adminid']))->getField('name');
|
|
}
|
|
if ($ordertype == 1) {
|
|
if ($val['audit'] == 1) {
|
|
$val['audit'] = '未确认';
|
|
} else if ($val['audit'] == 2) {
|
|
$val['audit'] = '未审核';
|
|
} else if ($val['audit'] == 3) {
|
|
$val['auditname'] = '已审核';
|
|
if ($val['toaudit'] == 1) {
|
|
$val['audit'] = '已审核（未确认）';
|
|
} else if ($val['toaudit'] == 4) {
|
|
$val['audit'] = '已审核（已拒绝）';
|
|
} else {
|
|
$val['audit'] = '已审核（已接收）';
|
|
}
|
|
}
|
|
$val['tostoreid'] = M('retail_store')->where(array('id' => $val['tostoreid']))->getField('storetag');
|
|
} else if ($ordertype == 2) {
|
|
if ($val['toaudit'] == 1) {
|
|
$val['audit'] = '等待确认';
|
|
} else if ($val['toaudit'] == 2) {
|
|
$val['audit'] = '确认未审核';
|
|
} else if ($val['toaudit'] == 3) {
|
|
$val['audit'] = '已审核';
|
|
} else if ($val['toaudit'] == 4) {
|
|
$val['audit'] = '已拒绝';
|
|
}
|
|
$val['tostoreid'] = M('retail_store')->where(array('id' => $v['storeid']))->getField('storetag');
|
|
}
|
|
}
|
|
} else {
|
|
$flow_allocating = array();
|
|
}
|
|
$flow_allocating_name = '调拨单明细';
|
|
$headArr = array(
|
|
array('key', '序号'),
|
|
array('ordernum', '进货单号'),
|
|
array('ctime', '制单时间'),
|
|
array('adminname', '制单人'),
|
|
array('tostoreid', '调拨门店'),
|
|
array('allnum', '调拨量'),
|
|
array('allmoney', '调拨总金额'),
|
|
array('audit', '单据状态')
|
|
);
|
|
$str = $flow_allocating_name . '导出时间' . date('Y-m-d H:i:s', time());
|
|
$this->getExcel($flow_allocating_name, $headArr, $flow_allocating, $str);
|
|
}
|
|
|
|
//商户进货单列表
|
|
public function purchase()
|
|
{
|
|
$arr = array(
|
|
'purchase_detail' => '/index.php/Retail/Flow/purchase_detail',
|
|
'purchase_examine' => '/index.php/Retail/Flow/purchase_examine',
|
|
'voidorder' => '/index.php/Retail/Flow/voidorder',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
public function purchase_merchant()
|
|
{
|
|
$user = session('ls_userinfo');
|
|
$storeid = session('storeid');
|
|
if (empty($storeid) || empty($user)) {
|
|
$res['code'] = 0;
|
|
$res['msg'] = '';
|
|
$res['count'] = 0;
|
|
$res['data'] = array();
|
|
$this->ajaxReturn($res);
|
|
exit;
|
|
}
|
|
$order_id = I('get.order_id');
|
|
$order_state = I('get.order_state');
|
|
$date = I('get.date');
|
|
if (!empty($order_id)) {
|
|
$where['order_id'] = array('like', '%' . $order_id . '%');
|
|
}
|
|
if (!empty($order_state)) {
|
|
$where['examine'] = $order_state;
|
|
}
|
|
if (!empty($date)) {
|
|
$date = explode('至', $date);
|
|
$start_time = strtotime(date('Y-m-d 00:00:00', strtotime($date[0])));
|
|
$endtime = strtotime(date('Y-m-d 23:59:59', strtotime($date[1])));
|
|
$where['addtime'] = array('between', array($start_time, $endtime));
|
|
}
|
|
$page = I('get.page');
|
|
$limit = I('get.limit');
|
|
$where['target_storeid'] = $storeid;
|
|
$where['merchantid'] = $user['merchantid'];
|
|
$where['type'] = 1;
|
|
$where['status'] = 1;
|
|
$goods_info = M('retail_allocation')->where($where)->order('addtime desc')->page($page, $limit)->select();
|
|
if ($goods_info) {
|
|
$count = M('retail_allocation')->where($where)->count();
|
|
foreach ($goods_info as $key => &$val) {
|
|
$val['index'] = $key + 1;
|
|
$val['addtime'] = date('Y-m-d H:i:s', $val['addtime']);
|
|
if ($val['examine'] == 1) {
|
|
$val['state'] = '未审核';
|
|
} else if ($val['examine'] == 2) {
|
|
$val['state'] = '审核通过';
|
|
} else if ($val['examine'] == 3) {
|
|
$val['state'] = '审核失败';
|
|
}
|
|
}
|
|
$res['code'] = 0;
|
|
$res['msg'] = '';
|
|
$res['count'] = $count;
|
|
$res['data'] = $goods_info;
|
|
} else {
|
|
$res['code'] = 0;
|
|
$res['msg'] = '';
|
|
$res['count'] = 0;
|
|
$res['data'] = array();
|
|
}
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
//查看商户进货详情
|
|
public function purchase_detail()
|
|
{
|
|
$id = I('get.id');
|
|
$this->assign('id', $id);
|
|
$this->display();
|
|
}
|
|
|
|
//查看商户进货详情
|
|
public function purchase_detail_list()
|
|
{
|
|
$id = I('post.floworderid');
|
|
$goods_bank_info = M('retail_allocation_goods_bank')->where(array('allocation_id' => $id))->select();
|
|
if ($goods_bank_info) {
|
|
foreach ($goods_bank_info as $key => &$val) {
|
|
$val['index'] = $key + 1;
|
|
}
|
|
$res['status'] = 1;
|
|
$res['data'] = $goods_bank_info;
|
|
} else {
|
|
$res['status'] = 0;
|
|
$res['data'] = array();
|
|
}
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
//门店进货商户审核
|
|
public function purchase_examine()
|
|
{
|
|
$storeid = session('storeid');
|
|
$merchantid = M('retail_store')->where(array('id' => $storeid))->getField('merchantid');
|
|
$id = I('post.id');
|
|
$stime = time();
|
|
$allocation_info = M('retail_allocation')->where(array('id' => $id))->find(); //商户的出货单
|
|
if ($allocation_info) {
|
|
$goods_bank_info = M('retail_allocation_goods_bank')->where(array('allocation_id' => $allocation_info['id']))->select();
|
|
if ($goods_bank_info) {
|
|
foreach ($goods_bank_info as $key => $val) {
|
|
$store_goods['goods_number'] = $val['good_number'];
|
|
$store_goods['status'] = 0;
|
|
$store_goods['store_id'] = $storeid;
|
|
$store_goods['merchant_id'] = $merchantid;
|
|
$store_goods_info = M('retail_goods')->where($store_goods)->find();
|
|
if ($store_goods_info) {
|
|
//已经存在该商品判断是否存在条码相同的其他商品
|
|
if (!empty($val['goods_code'])) {
|
|
$goods_code['goods_code'] = $val['goods_code'];
|
|
$goods_code['id'] = array('neq', $store_goods_info['id']);
|
|
$goods_code['status'] = 0;
|
|
$goods_code['store_id'] = $storeid;
|
|
$goods_code['merchant_id'] = $merchantid;
|
|
$code_goods_info = M('retail_goods')->where($goods_code)->find();
|
|
if ($code_goods_info) {
|
|
$res['status'] = 0;
|
|
$res['msg'] = '请检查' . $code_goods_info['goods_name'] . '与商户' . $store_goods_info['goods_name'] . '条码重复';
|
|
$this->ajaxReturn($res);
|
|
exit;
|
|
}
|
|
}
|
|
if ($store_goods_info['attribute_state'] != $val['attribute']) {
|
|
$res['status'] = 0;
|
|
$res['msg'] = '请检查商户商品' . $val['goods_name'] . '与门店商品' . $store_goods_info['goods_name'] . '规格不同';
|
|
$this->ajaxReturn($res);
|
|
exit;
|
|
}
|
|
if ($val['attribute'] == 2) {
|
|
//有规格的商品allocat_sku_goods
|
|
$sku_mgoods_ids = M('retail_allocat_sku_goods')->where(array('goods_bannk_id' => $val['id']))->getField('sku_mgoods_id',true);
|
|
$sku_mgoods_ids = $sku_mgoods_ids?$sku_mgoods_ids:array('0');
|
|
$m_sku_goods_info = M('retail_sku_mgoods')->where(array('id' => array('in', $sku_mgoods_ids)))->select();
|
|
$m_sku_goods_info = $m_sku_goods_info?$m_sku_goods_info:array(array('sku_id_list'=>'0'));
|
|
$s_sku_goods_info = M('retail_sku_goods')->where(array('goods_id' => $store_goods_info['id'], 'status' => 1, 'state' => 0))->select();
|
|
$s_sku_goods_info = $s_sku_goods_info?$s_sku_goods_info:array(array('sku_id_list'=>'0'));
|
|
//判断规格是否一致
|
|
$m_sku_attr = M('retail_sku_list')->where(array('id' => array('in', $m_sku_goods_info[0]['sku_id_list'])))->getField('attr_id', true);
|
|
$s_sku_attr = M('retail_sku_list')->where(array('id' => array('in', $s_sku_goods_info[0]['sku_id_list'])))->getField('attr_id', true);
|
|
$m_sku_attr = asort($m_sku_attr);
|
|
$s_sku_attr = asort($s_sku_attr);
|
|
if ((string)$m_sku_attr != (string)$s_sku_attr) {
|
|
$res['status'] = 0;
|
|
$res['msg'] = '商户商品' . $val['goods_name'] . '与门店商品' . $store_goods_info['goods_name'] . '规格不同';
|
|
$this->ajaxReturn($res);
|
|
exit;
|
|
}
|
|
}
|
|
}else{
|
|
if(!empty($val['goods_code'])){
|
|
$goods_code['goods_code'] = $val['goods_code'];
|
|
$goods_code['status'] = 0;
|
|
$goods_code['store_id'] = $storeid;
|
|
$goods_code['merchant_id'] = $merchantid;
|
|
$code_goods_info = M('retail_goods')->where($goods_code)->find();
|
|
if ($code_goods_info) {
|
|
$res['status'] = 0;
|
|
$res['msg'] = '请检查' . $code_goods_info['goods_name'] . '与商户' . $store_goods_info['goods_name'] . '条码重复';
|
|
$this->ajaxReturn($res);
|
|
exit;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
//可以直接存入
|
|
foreach ($goods_bank_info as $key => $val) {
|
|
//因图片管理器所以查询图片
|
|
$goods_image_id = M('retail_mgoods')->where(array('id'=>$val['goodsid']))->getField("goods_image_id");
|
|
$store_goods['goods_number'] = $val['good_number'];
|
|
$store_goods['status'] = 0;
|
|
$store_goods['store_id'] = $storeid;
|
|
$store_goods_info = M('retail_goods')->where($store_goods)->find();
|
|
if ($store_goods_info){
|
|
//存在该商品
|
|
$mgoods_banner = array();
|
|
$mgoods_banner = M('retail_mgoods_banner')->where(array('mgoods_id'=>$val['goodsid']))->field("image,image_id")->select();
|
|
if(!empty($mgoods_banner)){
|
|
$store_goods_bannerid = M('retail_goods_banner')->where(array('goods_id'=>$store_goods_info['id']))->getField('id',true);
|
|
if($store_goods_bannerid){
|
|
M('retail_goods_banner')->where(array('id'=>array('in',$store_goods_bannerid)))->delete();
|
|
}
|
|
$banner_time = time();
|
|
foreach ($mgoods_banner as $keybanner=>&$valbanner){
|
|
$goods_banner['storeid'] = $storeid;
|
|
$goods_banner['goods_id'] = $store_goods_info['id'];
|
|
$goods_banner['image'] = $valbanner['image'];
|
|
$goods_banner['image_id'] = $valbanner['image_id'];
|
|
$goods_banner['addtime'] = $banner_time;
|
|
M('retail_goods_banner')->add($goods_banner);
|
|
}
|
|
}
|
|
$data['goods_img_id'] = $goods_image_id;
|
|
$data['goods_name'] = $val['goods_name'];
|
|
$data['goods_class_id'] = $val['goods_class_id'];
|
|
$data['goods_code'] = $val['goods_code'];
|
|
$data['details'] = $val['details'];
|
|
$data['goods_brand_id'] = $val['goods_brand_id'];
|
|
if ($val['attribute'] == 2){
|
|
//有规格处理规格
|
|
$m_sku_list_ids = M('retail_allocat_sku_goods')->where(array('goods_bannk_id' => $val['id']))->getField('sku_mgoods_id',true);
|
|
$m_sku_list_info = M('retail_sku_mgoods')->where(array('id'=>array('in',$m_sku_list_ids)))->select();
|
|
$m_sku_list_info = $m_sku_list_info?$m_sku_list_info:array(array('sku_id_list'=>'0'));
|
|
$m_sku_id_list_count = count(explode(',',$m_sku_list_info[0]['sku_id_list']));
|
|
$s_sku_list_info = M('retail_sku_goods')->where(array('goods_id'=>$store_goods_info['id'],'state'=>0,'status'=>1))->select();
|
|
foreach ($m_sku_list_info as $ke=>&$va){
|
|
$arrList = array();
|
|
foreach($s_sku_list_info as $k=>&$v){
|
|
$m_sku_id_list_arr = explode(',',$va['sku_id_list']);
|
|
$s_sku_id_list_arr = explode(',',$v['sku_id_list']);
|
|
$sku_list_num = 0;
|
|
foreach ($m_sku_id_list_arr as $mkey=>&$mval){
|
|
if(in_array($mval,$s_sku_id_list_arr)){
|
|
$sku_list_num = $sku_list_num + 1;
|
|
}
|
|
}
|
|
$arrList[] = $sku_list_num;
|
|
if($sku_list_num == $m_sku_id_list_count){
|
|
if($v['sku_id_list'] != $va['sku_id_list']){
|
|
M('retail_sku_goods')->where(array('id'=>$v['id']))->save(array('sku_id_list'=>$va['sku_id_list']));
|
|
}
|
|
M('retail_sku_goods')->where(array('id'=>$v['id']))->save(array('sku_num'=>$va['sku_num']));
|
|
$savenum = M('retail_allocat_sku_goods')->where(array('goods_bannk_id'=>$val['id'],'sku_mgoods_id'=>$va['id']))->getField('shipment_num');
|
|
M('retail_sku_goods')->where(array('id'=>$v['id']))->setInc('goods_num',$savenum);
|
|
break;
|
|
}
|
|
}
|
|
if(!in_array($m_sku_id_list_count,$arrList)){
|
|
$sku_goods_num = M('retail_allocat_sku_goods')->where(array('goods_bannk_id'=>$val['id'],'sku_mgoods_id'=>$va['id']))->getField('shipment_num');
|
|
$s_sku_goods['storeid'] = $storeid;
|
|
$s_sku_goods['goods_id'] = $store_goods_info['id'];
|
|
$s_sku_goods['sku_id_list'] = $va['sku_id_list'];
|
|
$s_sku_goods['purchase_price'] = $va['purch_price'];
|
|
$s_sku_goods['online_price'] = $va['online_price'];
|
|
$s_sku_goods['retail_price'] = $va['retail_price'];
|
|
$s_sku_goods['goods_num'] = $sku_goods_num;
|
|
$s_sku_goods['sku_num'] = $va['sku_num'];
|
|
$s_sku_goods['shop_mem_price'] = $va['shop_mem_price'];
|
|
$s_sku_goods['store_mem_price'] = $va['store_mem_price'];
|
|
$s_sku_goods['add_time'] = $stime;
|
|
$s_sku_goods['status'] = $va['status'];
|
|
$s_sku_goods['state'] = $va['state'];
|
|
$s_sku_goods['type'] = $va['type'];
|
|
$s_sku_goods['sku_code'] = $va['sku_code'];
|
|
$s_sku_goods['goods_img_id'] = $va['goods_img_id'];//图片id
|
|
$add_sku_goods = M('retail_sku_goods')->add($s_sku_goods);
|
|
}
|
|
}
|
|
}
|
|
$store_goods_save = M('retail_goods')->where($store_goods)->save($data);
|
|
//入库明细
|
|
$quantity['original_stock'] = $store_goods_info['goods_num'];
|
|
$quantity['do_num'] = $val['num'];
|
|
$quantity['type'] = 1;
|
|
$quantity['goods_id'] = $store_goods_info['id'];
|
|
$quantity['addtime'] = $stime;
|
|
$quantity['merchantid'] = $merchantid;
|
|
$quantity['storeid'] = $storeid;
|
|
$quantity['supplier_id'] = 1;
|
|
$quantity['present_stock'] = ($store_goods_info['goods_num'] + $val['num']);
|
|
$quantity['remark'] = '商户调拨';
|
|
M('retail_quantity_logs')->add($quantity);
|
|
$goods_num_set = M('retail_goods')->where($store_goods)->setInc('goods_num', $val['num']);
|
|
} else {
|
|
//新增商品
|
|
$sdata['goods_img_id'] = $goods_image_id;
|
|
$sdata['goods_name'] = $val['goods_name'];
|
|
$sdata['goods_class_id'] = $val['goods_class_id'];
|
|
$sdata['goods_number'] = $val['good_number'];
|
|
$sdata['purchase_price'] = $val['purch_price'];
|
|
$sdata['retail_price'] = $val['retail_price'];
|
|
$sdata['online_price'] = $val['online_price'];
|
|
$sdata['vip_online_price'] = $val['online_price'];
|
|
$sdata['vip_retail_price'] = $val['vip_retail_price'];
|
|
$sdata['vip_online_state'] = $val['vip_online_state'];
|
|
$sdata['vip_retail_state'] = $val['vip_retail_state'];
|
|
$sdata['add_time'] = $stime;
|
|
$sdata['status'] = 0;
|
|
$sdata['goods_num'] = $val['num'];
|
|
$sdata['more_num'] = $val['more_num'];
|
|
$sdata['less_num'] = $val['less_num'];
|
|
$sdata['sell_num'] = 0;
|
|
$sdata['company'] = $val['company'];
|
|
$sdata['specifications'] = $val['specifications'];
|
|
$sdata['merchant_id'] = $merchantid;
|
|
$sdata['store_id'] = $storeid;
|
|
$sdata['goods_code'] = $val['goods_code'];
|
|
$sdata['online_state'] = $val['issellonline'];
|
|
$sdata['pricing_method'] = $val['can_exchange_weigh'];
|
|
$sdata['details'] = $val['details'];
|
|
$sdata['check_num'] = '';
|
|
$sdata['supplier_id'] = $val['supplier_id'];
|
|
$sdata['m_goods_id'] = $val['goodsid'];
|
|
$sdata['source_type'] = 2;
|
|
$sdata['attribute_state'] = $val['attribute'];
|
|
$sdata['production_date'] = $val['production_date'];
|
|
$sdata['shelf_life'] = $val['shelf_life'];
|
|
$sdata['shop_mem_status'] = $val['shop_mem_status'];
|
|
$sdata['shop_mem_price'] = $val['shop_mem_price'];
|
|
$sdata['store_mem_status'] = $val['store_mem_status'];
|
|
$sdata['store_mem_price'] = $val['store_mem_price'];
|
|
$sdata['goods_brand_id'] = $val['goods_brand_id'];
|
|
$new_addgoods = M('retail_goods')->add($sdata);
|
|
//入库明细
|
|
$quantity['original_stock'] = 0;
|
|
$quantity['do_num'] = $val['num'];
|
|
$quantity['type'] = 1;
|
|
$quantity['goods_id'] = $new_addgoods;
|
|
$quantity['addtime'] = $stime;
|
|
$quantity['merchantid'] = $merchantid;
|
|
$quantity['storeid'] = $storeid;
|
|
$quantity['supplier_id'] = 1;
|
|
$quantity['present_stock'] = $val['num'];
|
|
$quantity['remark'] = '商户调拨';
|
|
M('retail_quantity_logs')->add($quantity);
|
|
$mgoods_banner = array();
|
|
$mgoods_banner = M('retail_mgoods_banner')->where(array('mgoods_id'=>$val['goodsid']))->field("image,image_id")->select();
|
|
if(!empty($mgoods_banner)){
|
|
$banner_time = time();
|
|
foreach ($mgoods_banner as $key_banner=>&$valbanner){
|
|
$goods_banner['storeid'] = $storeid;
|
|
$goods_banner['goods_id'] = $new_addgoods;
|
|
$goods_banner['image'] = $valbanner['image'];
|
|
$goods_banner['image_id'] = $valbanner['image_id'];
|
|
$goods_banner['addtime'] = $banner_time;
|
|
M('retail_goods_banner')->add($goods_banner);
|
|
}
|
|
}
|
|
if($val['attribute'] == 2){
|
|
//规格处理
|
|
$m_sku_list_ids = M('retail_allocat_sku_goods')->where(array('goods_bannk_id' => $val['id']))->getField('sku_mgoods_id',true);
|
|
$m_sku_list_ids = $m_sku_list_ids?$m_sku_list_ids:array('0');
|
|
$m_sku_list_info = M('retail_sku_mgoods')->where(array('id'=>array('in',$m_sku_list_ids)))->select();
|
|
foreach ($m_sku_list_info as $keysku=>&$valsku){
|
|
$sku_goods_num = M('retail_allocat_sku_goods')->where(array('goods_bannk_id'=>$val['id'],'sku_mgoods_id'=>$valsku['id']))->getField('shipment_num');
|
|
$xzs_sku_goods['store_id'] = $storeid;
|
|
$xzs_sku_goods['goods_id'] = $new_addgoods;
|
|
$xzs_sku_goods['sku_id_list'] = $valsku['sku_id_list'];
|
|
$xzs_sku_goods['purchase_price'] = $valsku['purch_price'];
|
|
$xzs_sku_goods['online_price'] = $valsku['online_price'];
|
|
$xzs_sku_goods['retail_price'] = $valsku['retail_price'];
|
|
$xzs_sku_goods['goods_img_id'] = $valsku['goods_img_id'];
|
|
$xzs_sku_goods['goods_num'] = $sku_goods_num;
|
|
$xzs_sku_goods['sku_num'] = $valsku['sku_num'];
|
|
$xzs_sku_goods['shop_mem_price'] = $valsku['shop_mem_price'];
|
|
$xzs_sku_goods['store_mem_price'] = $valsku['store_mem_price'];
|
|
$xzs_sku_goods['add_time'] = $stime;
|
|
$xzs_sku_goods['status'] = $valsku['status'];
|
|
$xzs_sku_goods['state'] = $valsku['state'];
|
|
$xzs_sku_goods['type'] = $valsku['type'];
|
|
$xzs_sku_goods['sku_code'] = $valsku['sku_code'];
|
|
$add_sku_goods = M('retail_sku_goods')->add($xzs_sku_goods);
|
|
}
|
|
}
|
|
if(!$new_addgoods){
|
|
$res['status'] = 0;
|
|
$res['msg'] = $sdata['goods_name'].'进货失败';
|
|
$this->ajaxReturn($res);
|
|
exit;
|
|
}
|
|
}
|
|
}
|
|
$save = M('retail_allocation')->where(array('id' => $id))->save(array('examine'=>2));
|
|
if($save){
|
|
$res['status'] = 1;
|
|
$res['msg'] = '进货成功';
|
|
}else{
|
|
$res['status'] = 1;
|
|
$res['msg'] = '进货成功,进货单状态修改失败';
|
|
}
|
|
$this->ajaxReturn($res);
|
|
} else {
|
|
$res['status'] = 0;
|
|
$res['msg'] = '进货单有误';
|
|
$this->ajaxReturn($res);
|
|
exit;
|
|
}
|
|
} else {
|
|
$res['status'] = 0;
|
|
$res['msg'] = '商户已删除此出货单';
|
|
$this->ajaxReturn($res);
|
|
exit;
|
|
}
|
|
}
|
|
//作废商户进货单
|
|
public function voidorder()
|
|
{
|
|
$id = I('post.id');
|
|
if(!$id){
|
|
$res['status'] = 0;
|
|
$res['msg'] = '参数错误';
|
|
$this->ajaxReturn($res);exit;
|
|
}
|
|
$agoods_sales = M('retail_allocation')->where(array('id'=>$id))->find(); //出货单
|
|
if($agoods_sales){
|
|
$agoods_info = M('retail_allocation_goods_bank')->where(array('allocation_id'=>$agoods_sales['id']))->select(); //出货单的所有商品
|
|
if($agoods_info){
|
|
foreach ($agoods_info as $key=>&$val){
|
|
if($val['attribute'] == 2){
|
|
//有规格的
|
|
$sku_info = M('retail_allocat_sku_goods')->where(array('goods_bannk_id'=>$val['id'],'goods_num'=>array('neq',0),'shipment_num'=>array('neq',0)))->select();
|
|
if($sku_info){
|
|
foreach ($sku_info as $ke=>&$va){
|
|
M('retail_sku_mgoods')->where(array('id'=>$va['sku_mgoods_id']))->setInc('goods_num',$va['shipment_num']);
|
|
}
|
|
}
|
|
}
|
|
M('retail_mgoods')->where(array('id'=>$val['goodsid']))->setInc('goods_num',$val['num']);
|
|
}
|
|
$save_sales = M('retail_allocation')->where(array('id'=>$id))->save(array('examine'=>3)); //出货单
|
|
if($save_sales){
|
|
$res['status'] = 1;
|
|
$res['msg'] = '操作成功';
|
|
$this->ajaxReturn($res);
|
|
}else{
|
|
$res['status'] = 1;
|
|
$res['msg'] = '货物退还成功,进货单状态修改失败';
|
|
$this->ajaxReturn($res);
|
|
}
|
|
}else{
|
|
$res['status'] = 0;
|
|
$res['msg'] = '该出货单';
|
|
$this->ajaxReturn($res);
|
|
}
|
|
}else{
|
|
$res['status'] = 0;
|
|
$res['msg'] = '出货单错误';
|
|
$this->ajaxReturn($res);
|
|
}
|
|
}
|
|
//规格详情
|
|
public function purchase_sku_details()
|
|
{
|
|
$goods_bank_id = I('post.goods_bank_id');
|
|
if($goods_bank_id){
|
|
$goods_info = M('retail_allocation_goods_bank')->where(array('id'=>$goods_bank_id))->find();
|
|
if($goods_info){
|
|
if($goods_info['attribute'] == 2){
|
|
$sku_ids = M('retail_allocat_sku_goods')->where(array('goods_bannk_id'=>$goods_info['id']))->getField('sku_mgoods_id',true);
|
|
$res['status'] = 1;
|
|
$res['info'] = $this->getMGoodsSkuAttr($sku_ids,$goods_bank_id);
|
|
}else{
|
|
$res['status'] = 0;
|
|
$res['msg'] = '该商品不是规格商品';
|
|
}
|
|
}else{
|
|
$res['status'] = 0;
|
|
$res['msg'] = '未找到该商品';
|
|
}
|
|
}else{
|
|
$res['status'] = 0;
|
|
$res['msg'] = '参数错误';
|
|
}
|
|
$this->ajaxReturn($res);
|
|
}
|
|
//获取商品规格信息
|
|
public function getMGoodsSkuAttr($id,$goods_bank_id)
|
|
{
|
|
$skuList = M('retail_sku_mgoods')->where(array('id'=>array('in',$id)))->select();
|
|
$skuAttr = array();
|
|
if (!empty($skuList)) {
|
|
foreach ($skuList as &$value) {
|
|
$tempId = explode(',', $value['sku_id_list']);
|
|
foreach ($tempId as &$v) {
|
|
$v = intval($v);
|
|
$value['name'][] = M('retail_sku_list')->where(array('id' => $v))->getField('name');
|
|
}
|
|
$value['tempId'] = $tempId;
|
|
if($value['goods_num'] == round($value['goods_num'])){
|
|
$value['goods_num'] = round($value['goods_num']);
|
|
}
|
|
if($value['sku_num'] == round($value['sku_num'])){
|
|
$value['sku_num'] = round($value['sku_num']);
|
|
}
|
|
$value['num'] = M('retail_allocat_sku_goods')->where(array('sku_mgoods_id'=>$value['id'],'goods_bannk_id'=>$goods_bank_id))->getField('shipment_num');//出货量
|
|
}
|
|
//为了保证规格顺序
|
|
$skuAttr = array();
|
|
for ($i = 0; $i < count($skuList[0]['tempId']); $i++) {
|
|
$skuAttr[] = M('retail_sku_attr as s')
|
|
->join('ls_retail_sku_list as l on l.attr_id=s.id')
|
|
->where(array('s.state' => 0, 'l.id' => $skuList[0]['tempId'][$i]))
|
|
->group('l.attr_id')
|
|
->field('s.id,s.name')
|
|
->find();
|
|
}
|
|
}
|
|
$data['attr'] = $skuAttr;
|
|
$data['list'] = $skuList;
|
|
return $data;
|
|
}
|
|
} |