data['systemwigsout'] = $wigsout;
//单项结束
$this->_Template('finance_product',$this->data);
}
public function _ouout() //财务汇总导出
{
if(isset($_GET['excel']))
{
$timetk = $this->input->get('timetk',true);
$timetj = $this->input->get('timetj',true);
$shop = $this->input->get('shop',true);
$source = $this->input->get('source',true);
$library = $this->input->get('library',true);
$warehouse = $this->input->get('warehouse',true);
$orderinfo = $this->input->get('orderinfo',true);
$user = $this->input->get('user',true);
$name = $this->input->get('name',true);
$xztime = $this->input->get('xztime',true);
$country = $this->input->get('country',true);
$fullorder = $this->input->get('fullorder',true);
$timetk = strtotime($timetk);
$timetj = strtotime($timetj);
$where = "mergeid = 0";
if($timetk && $timetj)
{
$where .= " and ".$xztime." > '$timetk' and ".$xztime." < '$timetj'";
}
if($fullorder == 'sd')
{
echo '此功能只能单独导出独立站或速卖通数据';exit;
}
if($shop)
{
$where .= " and shop = '$shop'";
}
if($source)
{
$where .= " and source = '$source'";
}
if($library)
{
$where .= " and library = '$library'";
}
if($warehouse)
{
$where .= " and type = '$warehouse'";
}
if($orderinfo)
{
$where .= " and orderinfo = '$orderinfo'";
}
if($user)
{
$where .= " and user = '$user'";
}
if($name)
{
$where .= " and name = '$name'";
}
if($country)
{
$where .= " and country = '$country'";
}
//数据排序
$order_str = "id desc";
if(empty($page))
{
$start = 0;
$perpage = 1;
}
else
{
$start = ($page - 1)*$perpage;
}
//取得信息列表
$info_list = $this->$fullorder->find_all($where,'fpdata,library');
$rowsc = array();$rowst = array();
foreach ($info_list as $key=>$value)
{
$fpdata = explode(';',rtrim($value['fpdata'],';'));
foreach ($fpdata as $va)
{
$fpdatason = explode('|',$va);
$fpdatason[1] = rtrim($fpdatason[1],' ');
str_replace(array('Peruvian','Indian','Brazilian','Malaysian'),array('','','',''),$fpdatason[1]);
if($value['library'] == 2)
{
$c = 1; $t = 0;
}
else
{
$c = 0; $t = 1;
}
if(isset($rows[$fpdatason[1]]))
{
$rows[$fpdatason[1]]['c'] += $c;
$rows[$fpdatason[1]]['t'] += $t;
}
else
{
$rows[$fpdatason[1]]['a'] = $fpdatason[1];
$rows[$fpdatason[1]]['c'] = $c;
$rows[$fpdatason[1]]['t'] = $t;
}
}
}
$title = date('Y-m-d',$timetk).'至'.date('Y-m-d',$timetj).'汇总详情';
$titlename = "
".$title." |
|---|
| 产品名称 |
销售数量 |
退货数量 |
";
$filename = $title.".xls";
$tail = "";
$this->excel->get_fz2($rows,$titlename,$filename,$tail);
}
}
public function _cksize()
{
if(isset($_GET['excel']))
{
$type = $this->input->get('excel',true);
$category = $this->input->get('category',true);
$size = $this->input->get('size',true);
$grade = $this->input->get('grade',true);
$color = $this->input->get('color',true);
$lowe = $this->input->get('lowe',true);
$sku = $this->input->get('sku',true);
$warehouse = $this->input->get('warehouse',true);
$shop = $this->input->get('shop',true);
$sid = $this->input->get('sid',true);
$ktime = $this->input->get('ktime',true);
$jtime = $this->input->get('jtime',true);
$ktime = strtotime($ktime);
$jtime = strtotime($jtime);
$where = "1=1 and shop != 9 and shop != 26";$gj = "";$ck = "";
if($category)
{
$where .= " and fpdata like '%-$category-%'";
}
if($size)
{
$where .= " and fpdata like '%-$size-%'";
}
if($grade)
{
$where .= " and fpdata like '%-$grade-%'";
}
if($color)
{
$where .= " and fpdata like '%-$color-%'";
}
if($lowe)
{
$where .= " and fpdata like '%-$lowe-%'";
}
if($shop)
{
$shopdata = '';
$sd = explode(',',rtrim($shop,','));
foreach ($sd as $v)
{
$shopdata .= "shop = '$v' or ";
}
$where .= " and (".rtrim($shopdata,'or ').")";
}
if($warehouse)
{
$warehousedata = '';
$wd = explode(',',rtrim($warehouse,','));
foreach ($wd as $v)
{
$warehousedata .= "warehouse = '$v' or ";
}
$where .= " and (".rtrim($warehousedata,'or ').")";
}
if($sku)
{
$where .= " and sku like '%$sku%'";
}
if($ktime && $jtime)
{
$where .= " and librarytime > '$ktime' and librarytime < '$jtime'";
}
$sidwhere = '';
if($sid)
{
$sd = "";
$s = explode(',',trim($sid,','));
foreach ($s as $value)
{
$sd .= " id = ".$value." or";
}
$sidwhere .= " and (".rtrim($sd,'or').")";
}
$typeclass = array();
$tc = $this->typeclass->find_all();
foreach ($tc as $v)
{
$typeclass[$v['id']] = array('ae'=>$v['spare'],'zh'=>$v['zh']);
}
//取得信息列表
$timeread = $ktime;
$timenum = ceil(($jtime - $ktime) / (24*3600));
$timelist = array();
for($i=4;$i<41;$i++)
{
if ($i%2==0)
{
$timelist[$i] = 0;
}
}
$info_lista = $this->fullorder->find_all($where.$sidwhere,'fpdata,number');
$info_listb = $this->fullordersmt->find_all($where.$sidwhere,'fpdata,number');
$info_listc = $this->fullordertt->find_all($where.$sidwhere,'fpdata,number');
$info_list = array_merge($info_lista,$info_listb,$info_listc);
//echo "";
//print_r($info_list);
//exit();
$rows = array();$list = array();$cw = array();
foreach ($info_list as $key=>$value)
{
$thistime = $timelist;
$zdata = explode(';',trim($value['fpdata'],';'));
foreach ($zdata as $v)
{
if(stripos($v,'-131-') !== false || ($category != '' && stripos($v,'-'.$category.'-') === false))
{
continue;
}
$fpdata = explode('|',trim($v,'|'));
$xqdata = explode(',',trim($fpdata[0],','));
$cc = $typeclass[$xqdata[0]]['ae'];
if(!isset($xqdata[1]))
{
$cw[] = array($value['fpdata'],$value['number']);
}
$sku = $xqdata[1];
if(isset($rows[$sku]))
{
$rows[$sku][2][$cc] += 1;
}
else
{
$zh = '';
$zhdata = explode('-',trim($sku,'-'));
foreach ($zhdata as $kk => $vv)
{
if(isset($typeclass[$vv]['zh']) && $kk != 0)
{
$zh .= $typeclass[$vv]['zh'].' ';
}
}
$rows[$sku][0] = preg_replace('/ (\d+)inch/','',$fpdata[1]);
$rows[$sku][1] = trim($zh,' ');
$rows[$sku][2] = $thistime;
$rows[$sku][2][$cc] += 1;
}
}
}
$str = "
";
$str .= "";
$str .="| 英文 | ";
$str .="中文 | ";
foreach ($timelist as $k=>$v)
{
$str .="".$k." | ";
}
$str .= "
";
$str .= "";
foreach ($rows as $key=>$val)
{
$str .= "| ".$val[0]." | ";
$str .= "".$val[1]." | ";
foreach ($val[2] as $k=>$v)
{
$str .= "".$v." | ";
}
$str .= "
";
}
$str .= "
";
$str .= "";
header( "Content-Type: application/vnd.ms-excel; name='excel'" );
header( "Content-type: application/octet-stream" );
header( "Content-Disposition: attachment; filename=".time().'.xls' );
header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" );
header( "Pragma: no-cache" );
header( "Expires: 0" );
exit($str);
}
if(isset($_SESSION['api']))
{
$user = $this->user->get_api($_SESSION['api']);
$usp = $user;
$fgshop = "";$sid = "";
$usersp = explode('|',trim($user['shop'],'|'));
foreach ($usersp as $value)
{
$fgshop .= " shop = ".$value." or";
$sid .= " id = ".$value." or";
}
}
$wlshop = $this->shop->find_all('1=1 and '.rtrim($sid,'or'));
$this->data['wlshop'] = $wlshop;
$this->_Template('finance_cksize',$this->data);
}
}