Initialization.php
7.11 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
<?php
namespace app\admin\controller\kuerp;
use app\common\controller\Backend;
use think\Db;
use Exception;
/**
* 重新初始化
*
* @icon fa fa-circle-o
*/
class Initialization extends Backend
{
public function _initialize()
{
parent::_initialize();
$setData = (new Goods())->getSetData();
$this->assign('set', $setData['setList']);
$this->assignconfig('set',$setData['setList']);
$this->assign('nowmenu', $setData['nowmenu']);
}
public function index(){
if ($this->request->isPost()) {
$data = $_POST;
if(isset($data['type']) && $data['type']=='initialization'){
$limitTable = [
'kuerp_accounts','kuerp_accounts_copewith','kuerp_accounts_log','kuerp_accounts_receivable','kuerp_accounts_transfer',
'kuerp_accounts_transfer_info','kuerp_address','kuerp_adjustment','kuerp_adjustment_info','kuerp_allocation',
'kuerp_allocation_info','kuerp_assemble','kuerp_assemble_info','kuerp_assemble_info_temp','kuerp_assemble_temp',
'kuerp_attr_combination','kuerp_attribute','kuerp_aux_combination','kuerp_auxiliary','kuerp_collection','kuerp_collection_account',
'kuerp_collection_sale','kuerp_cost','kuerp_customer_goodscoding','kuerp_customers','kuerp_customers_user',
'kuerp_customertype','kuerp_expend_type','kuerp_expenditure','kuerp_expenditure_info','kuerp_goods','kuerp_goods_attr',
'kuerp_goods_batch','kuerp_goods_batch_exchange_info','kuerp_goods_batch_info','kuerp_goods_batch_log','kuerp_goods_batch_sale_info',
'kuerp_goods_batch_salee_info','kuerp_goods_batch_stock','kuerp_goods_exchange','kuerp_goods_exchange_info','kuerp_goods_excpur',
'kuerp_goods_excpur_info','kuerp_goods_log','kuerp_goods_period','kuerp_goods_price','kuerp_goods_purchase','kuerp_goods_purchase_info',
'kuerp_goods_purchase_order','kuerp_goods_purchase_order_info','kuerp_goods_purchase_summary','kuerp_goods_purord','kuerp_goods_purord_info',
'kuerp_goods_saleexc','kuerp_goods_saleexc_info','kuerp_goods_saleord','kuerp_goods_saleord_info','kuerp_goods_sales','kuerp_goods_sales_exchange',
'kuerp_goods_sales_exchange_info','kuerp_goods_sales_info','kuerp_goods_sales_order','kuerp_goods_sales_order_info','kuerp_goods_sales_profit',
'kuerp_goods_sales_summary','kuerp_goods_serial','kuerp_goods_serial_log','kuerp_goods_stock','kuerp_goods_stock_warning','kuerp_goods_store_info',
'kuerp_goods_type','kuerp_income','kuerp_income_info','kuerp_income_type','kuerp_inventory','kuerp_inventory_info','kuerp_inventory_serial',
'kuerp_inventory_serial_info','kuerp_invoicing','kuerp_invoicing_log','kuerp_payment','kuerp_payment_account','kuerp_payment_log',
'kuerp_payment_sale','kuerp_sales_invoicing','kuerp_sales_invoicing_log','kuerp_sales_payment_log','kuerp_settlementtype','kuerp_spendingtype',
'kuerp_split','kuerp_split_info','kuerp_split_info_temp','kuerp_split_temp','kuerp_staff_member','kuerp_stores','kuerp_suppliers','kuerp_suppliers_user',
'kuerp_supplyertype','kuerp_transfers','kuerp_unit','kuerp_unit_conversion','kuerp_warehouse','kuerp_warehouse_info','kuerp_warehousing',
'kuerp_warehousing_info','kuerp_writeoff','kuerp_writeoff_info','kuerp_writeoff_log','kuerp_writeoff_source',
'kuerp_enclosure','kuerp_enclosure_log',
'kuerp_driver','kuerp_third_account','kuerp_banner',
'kuerp_user','kuerp_user_address','kuerp_user_cart','kuerp_user_history','kuerp_user_oauth','kuerp_user_order',
'kuerp_user_orderinfo','kuerp_user_ordersale','kuerp_user_ordersaleinfo'
];
$result = false;
Db::startTrans();
try {
$data = [
['name'=>'company_name','value'=>'XX公司','is_checked'=>0],
['name'=>'company_address','value'=>'XX公司地址','is_checked'=>0],
['name'=>'company_phone','value'=>'0816-6666666','is_checked'=>0],
['name'=>'company_tax','value'=>NULL,'is_checked'=>0],
['name'=>'company_zipcode','value'=>'123456','is_checked'=>0],
['name'=>'price_decimal','value'=>'1','is_checked'=>0],
['name'=>'number_decimal','value'=>'0','is_checked'=>0],
['name'=>'valuation','value'=>'1','is_checked'=>0],
['name'=>'examine','value'=>'','is_checked'=>1],
['name'=>'taxes','value'=>'13','is_checked'=>0],
['name'=>'price_taxes','value'=>'','is_checked'=>0],
['name'=>'auxiliary','value'=>'','is_checked'=>0],
['name'=>'serial','value'=>'','is_checked'=>0],
['name'=>'batch','value'=>'','is_checked'=>0],
['name'=>'earing','value'=>'','is_checked'=>0],
['name'=>'stores','value'=>'','is_checked'=>0],
['name'=>'no_edittime','value'=>'','is_checked'=>0],
['name'=>'discount','value'=>'','is_checked'=>0],
['name'=>'customer','value'=>'','is_checked'=>0],
['name'=>'last_read','value'=>'','is_checked'=>0],
['name'=>'price_sale','value'=>'','is_checked'=>0],
['name'=>'price_buy','value'=>'','is_checked'=>0],
['name'=>'price_sale_last','value'=>'','is_checked'=>0],
['name'=>'price_buy_last','value'=>'','is_checked'=>0],
['name'=>'secret','value'=>'','is_checked'=>0],
['name'=>'appid','value'=>'','is_checked'=>0],
['name'=>'appsecret','value'=>'','is_checked'=>0],
];
foreach($data as $data_k=>$data_v){
Db::name('kuerp_sets')->where(['name'=>$data_v['name']])->update(['value'=>$data_v['value'],'is_checked'=>$data_v['is_checked']]);
}
foreach ($limitTable as $limitTable_k=>$limitTable_v){
$result = Db::name($limitTable_v)->where((new Goods())->setWhere(['id'=>['>',0]]))->delete();
}
Db::commit();
} catch (Exception $e) {
Db::rollback();
$this->error($e->getMessage());
}
if(isset($result) && $result !== false){
$this->success('初始化成功');
}else{
$this->error('初始化失败');
}
}
$this->error(__('Parameter %s can not be empty', ''));
}
return $this->view->fetch();
}
}