1 #待处理的
2 array_merge($pay->attributes, $pay_detail);
3 array_column($user,'username')
4
5 $map['id']=explode(',',$arr);
6 $ids=implode(',',$str);
7
8 Yii::t('app','无法删除的用户');
9 Yii::t('app','请不要重复提交')
10
11 ArrayHelper::getColumn($puid, 'pur_user_id');
12
13 \Yii::$app->getSession()->setFlash('success',"恭喜你添加成功！",true); //true和false作用
14
15 preg_match("/[\x7f-\xff]/", $purdesc['supplier_code'])
16
17 strpos($ids, ',')
18
19 mb_convert_encoding(trim($datas[$c]),'utf-8','gbk');
20
21 is_string($id)
22 ------------------------------------------
23 ini_set('display_errors', true);
24 error_reporting(E_ERROR);
25
26 try {
27 try {
28
29 } catch (InvalidParamException $e) {
30 print_r($e->getMessage());
31 }
32 }catch (Exception $e) {
33 print $e->getMessage();
34 exit();
35 }
36 ----------------------------------
37 set_time_limit(0);
38 strip_tags
39 round
40 $b= Vhelper::changeData(Yii::$app->request->post()['PurchaseOrder']);
41 -------------------
42 $PurchaseOrder = Vhelper::changeData($popost);
43 (array)$id;
44
45 $session->set('paytoken','paytoken'.time());
46 Yii::$app->session->get('allpaytoken')
47
48 -------------------
49 set_time_limit(0);
50 ini_set('memory_limit', '1024M');
51
52 =---------------------
53 if(Yii::$app->request->isAjax && Yii::$app->request->isPost){
54 $form = Yii::$app->request->getBodyParams();
55 }
56
57 ---------------------------------
58 #session
59 $session = Yii::$app->session;
60 $session->open();
61 $session->get('paytoken')
62 $session->remove('paytoken');
63 $session->set('paytoken','paytoken'.time());
64 #cookie
65 $cookie_data = \Yii::$app->response->cookies;
66 $cookie_data = array('name'=>'user','value'=>'zhangsi');
67 $cookies->add(new Cookie($cookie_data));
68 --------------------------------------
69 CommonServices::getNumber('PP');
70 ----------------------------
71 $price = ArrayHelper::getColumn($price,'items_totalprice');
72 $price = array_sum($price);
73
74 ------------------------
75 echo Json::encode($data);
76 $pum = array_unique($post['pnum_pto']);
77 ------------------------
78 Yii::$app->request->getBodyParams();
79 ---------------------------
80 header('Content-type:text/html;charset=utf-8');
81 ---------------
82 array_values($val);
83 $whouse = array_unique($wdata);
84 $tem_code = 'B' . rand('100000', '20000');
85 $userGroup = ArrayHelper::getColumn($group,'group_id');
86 !is_numeric($datas[4])
87 Name[$line_number][] = mb_convert_encoding(trim($datas[$c]),'utf-8','gbk');
88 strtoupper($Name[$line_number][1]);
89 ----------------------------------
90 $dir=Yii::getAlias('@app') .'/web/files/' . date('Ymd');
91 if (file_exists($dir)){
92 FileHelper::removeDirectory($dir);
93 }
94 -------------------------------
95 \Yii::$app->session->set('PurchaseOrderConfirmSearchData', $params);
96
97 $id = Yii::$app->request->getQueryParam('id');
98 $select .= Html::tag('option',Html::encode($sale['supervisor_name']),['value'=>$sale['supervisor_name']]);
99
100 ----------------------------
101 if(Yii::$app->cache->get($sku.'_cache1')){
102 Yii::$app->cache->delete($sku.'_cache1');
103 }
104 ----------------------
105 Yii::$app->getSession()->setFlash('success',"恭喜，{$res}条数据操作成功！",true);
106 ----------------
107 $type = Vhelper::getNumber($v->pur_number); //有订单号，判断是国内、海外、FBA
108 isset($v['receipt_number'])?$v['receipt_number']:'';
109 ----------------
110 框架：phalcon
111 laravel 适合 研究 艺术
112 ---------------------------------------
113 /根据当前登录用户获取可见采购员
114 public static function getPurchaseOrderBuyerByRole(){
115 $userRolesArray = Yii::$app->authManager->getRolesByUser(Yii::$app->user->id);
116 $userRoles = array_keys($userRolesArray);
117 if(in_array('超级管理员组',$userRoles)){
118 return true;
119 }elseif(in_array('供应链',$userRoles)){
120 $searchuserIds = Yii::$app->authManager->getUserIdsByRole('供应链');
121 $buyername = User::find()->andWhere(['in','id',$searchuserIds])->andWhere(['status'=>10])->select('username')->asArray()->all();
122 return empty($buyername) ? [] : array_column($buyername,'username');
123 }elseif(in_array('FBA采购组',$userRoles)||in_array('FBA采购经理组',$userRoles)){
124 $searchuserIds = Yii::$app->authManager->getUserIdsByRole('FBA采购组');
125 $searchuserIdsz = Yii::$app->authManager->getUserIdsByRole('FBA采购经理组');
126 $buyername = User::find()->andWhere(['in','id',array_merge($searchuserIds,$searchuserIdsz)])->andWhere(['status'=>10])->select('username')->asArray()->all();
127 return empty($buyername) ? [] : array_column($buyername,'username');
128 }elseif(in_array('采购经理组',$userRoles)||in_array('采购组长',$userRoles)||in_array('采购组-国内',$userRoles)||in_array('浏览权限',$userRoles)){
129 $searchuserIds = Yii::$app->authManager->getUserIdsByRole('采购组长');
130 $searchuserIdsz = Yii::$app->authManager->getUserIdsByRole('采购经理组');
131 $searchuserIdsm = Yii::$app->authManager->getUserIdsByRole('采购组-国内');
132 $searchgylIds = Yii::$app->authManager->getUserIdsByRole('供应链');//排除供应链的人员
133 $buyername = User::find()->andWhere(['in','id',array_diff(array_merge($searchuserIds,$searchuserIdsm,$searchuserIdsz),$searchgylIds)])->andWhere(['status'=>10])->select('username')->asArray()->all();
134 return empty($buyername) ? [] : array_column($buyername,'username');
135 }elseif(in_array('采购组-海外',$userRoles)){
136 $searchuserIds = Yii::$app->authManager->getUserIdsByRole('采购组-海外');
137 $buyername = User::find()->andWhere(['in','id',$searchuserIds])->andWhere(['status'=>10])->select('username')->asArray()->all();
138 return empty($buyername) ? [] : array_column($buyername,'username');
139 }else{
140 return [];
141 }
142 }
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178 ---------------------------------------
179 //设置的上传文件存放路径
180 $file = Yii::$app->basePath.'/web/platform-orders/amazon.csv';
181 if (!is_dir($filePath)) mkdir($filePath,0777,true);
182
183 //加载文件
184 $path= "/Classes/PHPExcel/";
185 set_include_path('.' . PATH_SEPARATOR . Yii::$app->basePath.$path . "PHPExcel.php" . PATH_SEPARATOR . get_include_path());
186
187 require(Yii::getAlias("@phpexcel").'/Classes/PHPExcel.php'); //D:\WWW\purchase/vendor/phpoffice/phpexcel/Classes/PHPExcel.php
188 require(Yii::getAlias("@phpexcel").$path.'IOFactory.php');
189 require(Yii::getAlias("@phpexcel").$path.'Reader/Excel2007.php');
190
191 //require_once $path.'PHPExcel/Reader/Excel5.php';//excel 2003
192
193 /*$filename=explode(".",$file);//把上传的文件名以“.”为准做一个数组。
194 $time=date("Y-m-d-His");//去当前上传的时间
195 $filename [0]=$time;//取文件名替换
196 $name=implode (".",$filename); //上传后的文件名
197 $uploadfile=$filePath.$name;//上传后的文件名地址*/
198
199
200 //将上传的文件移动到新位置。若成功，则返回 true，否则返回 false。
201 //$result=move_uploaded_file($filetempname,$uploadfile);
202
203 if($result=1) //执行导入 excel操作
204 {
205 // $objReader = PHPExcel_IOFactory::createReader('Excel5');//use excel2003
206 \PHPExcel_IOFactory::createReader('Excel2007');//use excel2003 和 2007 format
207 $objPHPExcel = \PHPExcel_IOFactory::load($file);
208 /* $sheet = $objPHPExcel->getSheet(0);
209 $highestRow = $sheet->getHighestRow(); // 取得总行数
210 $highestColumn = $sheet->getHighestColumn(); // 取得总列
211 $total_num=\PHPExcel_Cell::columnIndexFromString($highestColumn);//由列名转为列数('AB'->28)*/
212
213 $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
214
215 if($highestRow>=2){
216 //循环读取excel文件,读取一条,插入一条
217 for($j=2;$j<=$highestRow;$j++)
218 {
219 for($k=0;$k<$total_num;$k++)
220 {
221 $col_name = \PHPExcel_Cell::stringFromColumnIndex($k);//由列数反转列名(0->'A')
222 //$str[$k]= mb_convert_encoding($sheet->getCell($col_name . $j)->getValue(), ''gbk', 'utf8');//转码,读取单元格
223 $str[$k]= $objPHPExcel->getActiveSheet()->getCell($col_name.$j)->getValue();//读取单元格
224
225 }
226 $orderdatas[]=$str;
227 }
228
229 $statu= Yii::$app->db->createCommand()->batchInsert(AmazonOrders::tableName(), ['sdate', 'stime', 'ship_name', 'rs_state', 'sku'], $orderdatas)->execute();
230 unset($orderdatas);
231 if($statu){
232 $msg = '导入成功';
233 } else {
234 $msg = '导入失败';
235 }
236 }
237
238 //unlink ($uploadfile); //删除上传的excel文件
239 }else{
240 $msg = "没有数据！";
241 //unlink ($uploadfile); //删除上传的excel文件
242 }
243 header('Content-type:text/html;charset=utf-8');
244 exit( "$msg" );
245 }
