<?php
namespace app \index \controller ;
use think\Hook;
use app\index\controller\Acl;
use app\index\model\Warehouse as Warehouses;
use app\index\controller\Formfield;
class Warehouse extends Acl {
public function main(){
return $this->fetch();
}
public function warehouse_list(){
$input=input('post.');
if(isset_full($input,'page') && isset_full($input,'limit')){
$sql=get_sql($input,[
'name'=>'full_name_py_link',
'number'=>'full_like',
'contacts'=>'full_like',
'tel'=>'full_like',
'add'=>'full_like',
'data'=>'full_like'
],'warehouse') $sql=auth('warehouse',$sql) $count = Warehouses::where ($sql)->count() $arr = Warehouses::where($sql)->page($input['page'],$input['limit'])->order('id desc')->select() $resule=[
'code'=>0,
'msg'=>'获取成功',
'count'=>$count,
'data'=>$arr
] }else{
$resule=['state'=>'error','info'=>'传入参数不完整!'];
}
return json($resule);
}
public function set_warehouse(){
$input=input('post.');
if(isset($input['id'])){
if(empty($input['id'])){
$vali = $this->validate($input,'warehouse');
if($vali===true){
$input['py']=zh2py($input['name']) $create_info=Warehouses::create(syn_sql($input,'warehouse'));
Hook::listen('create_warehouse',$create_info) push_log('新增仓库信息[ '.$create_info['name'].' ]') $resule=['state'=>'success'];
}else{
$resule=['state'=>'error','info'=>$vali];
}
}else{
$vali = $this->validate($input,'warehouse.update');
if($vali===true){
$input['py']=zh2py($input['name']) $update_info=Warehouses::update(syn_sql($input,'warehouse'));
Hook::listen('update_warehouse',$update_info) push_log('更新仓库信息[ '.$update_info['name'].' ]') $resule=['state'=>'success'];
}else{
$resule=['state'=>'error','info'=>$vali];
}
}
}else{
$resule=['state'=>'error','info'=>'传入参数不完整!'];
}
return json($resule);
}
public function get_warehouse(){
$input=input('post.');
if(isset_full($input,'id')){
$resule=Warehouses::where(['id'=>$input['id']])->find();
}else{
$resule=['state'=>'error','info'=>'传入参数不完整!'];
}
return json($resule);
}
public function del_warehouse(){
$input=input('post.');
if(isset_full($input,'arr') && is_array($input['arr'])){
$exist=more_table_find([
['table'=>'allocationinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'cashierinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'exchangeinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'goods','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'otpurchaseinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'otsaleinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'purchaseinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'recashierinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'repurchaseinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'resaleinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'room','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'rpurchaseinfo','where'=>['warehouse'=>['in',$input['arr']]]],
['table'=>'saleinfo','where'=>['warehouse'=>['in',$input['arr']]]]
]);
if(!$exist){
$info=db('warehouse')->where(['id'=>['in',$input['arr']]])->select() foreach ($info as $info_vo) {
push_log('删除仓库信息[ '.$info_vo['name'].' ]') Hook::listen('del_warehouse',$info_vo['id']) }
Warehouses::where(['id'=>['in',$input['arr']]])->delete();
$resule=['state'=>'success'];
}else{
$resule=['state'=>'error','info'=>'存在数据关联,删除失败!'];
}
}else{
$resule=['state'=>'error','info'=>'传入参数不完整!'];
}
return json($resule);
}
public function export_warehouse(){
$input=input('get.');
$sql=get_sql($input,[
'name'=>'full_name_py_link',
'number'=>'full_like',
'contacts'=>'full_like',
'tel'=>'full_like',
'add'=>'full_like',
'data'=>'full_like'
],'warehouse') $sql=auth('warehouse',$sql) $arr = Warehouses::where($sql)->order('id desc')->select() $formfield=get_formfield('warehouse_export','array') $excel=[] array_push($excel,['type'=>'title','info'=>'仓库列表']);
$table_cell=[] foreach ($formfield as $formfield_vo) {
$table_cell[$formfield_vo['key']]=$formfield_vo['text'];
}
$table_data=[] foreach ($arr as $arr_vo) {
$row_data=[];
foreach ($formfield as $formfield_vo) {
$val='nod_initial' foreach (explode('|',$formfield_vo['data']) as $source) {
$val=$val=='nod_initial'?$arr_vo[$source]:(isset($val[$source])?$val[$source]:'');
}
$row_data[$formfield_vo['key']]=$val }
array_push($table_data,$row_data) }
array_push($excel,['type'=>'table','info'=>['cell'=>$table_cell,'data'=>$table_data]]) push_log('导出仓库信息') export_excel('仓库列表',$excel);
}
}