123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610 |
- <?php
- namespace app\admin\controller\index;
- use app\admin\controller\BaseController;
- use app\admin\server\index\CardServer;
- use support\Request;
- use support\Db;
- use app\admin\model\User;
- use app\admin\server\sms\VerificationCodeServer;
- use app\admin\server\payment\UnionOrder;
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
- use PhpOffice\PhpSpreadsheet\Style\Alignment;
- /**
- * 储值卡接口
- * Class Users
- * @package app\api\controller\user
- */
- class Card extends BaseController
- {
- /**
- * Notes:获取会员账户
- * @return \support\Response
- * User: yym
- * Date: 2022/7/26
- */
- public function getCardList()
- {
- $mobile = $this->request->get('mobile');
- $core_member_id = "";
- /*
- $core_member_id = DB::table('user')->where('user_account',$mobile)->value('core_member_id');
- if(empty($core_member_id)){
- throw new \Exception('会员未绑定核心库');
- }
- */
- $result = CardServer::getCardList($core_member_id,$mobile);
- return $result;
- }
- /**
- * Notes:会员绑定卡
- * @return \support\Response
- * User: ycp
- * Date: 2023/5/4
- */
- public function userBindCard()
- {
- $mobile = $this->request->post('mobile');
- $core_member_id = DB::table('user')->where('user_account',$mobile)->value('core_member_id');
- if(empty($core_member_id)){
- throw new \Exception('会员未绑定核心库');
- }
- $cardno = $this->request->post('cardno');
- $cardpswd = $this->request->post('cardpswd');
- $cardmonies = $this->request->post('cardmonies',0);
- $cardadded = $this->request->post('cardadded',0);
- $card_oct = substr($cardno, 15, 3);
- /* 八进制转十进制 */
- $card_dec = octdec((int)$card_oct);
- /* verifycode */
- $verifycode = md5($cardno . $cardpswd . $card_dec . ".YXJ");
- $result4 = CardServer::memberBindCard($cardno,$verifycode,$cardpswd,$cardmonies,$cardadded,$core_member_id);
- $result = json_decode($result4,true);
-
- if($result['errorcode'] == 313)
- {
- throw new \Exception("不能绑定同类型的卡");
- }
- if($result['errorcode'] == 312)
- {
- throw new \Exception("卡不存在或已被使用");
- }
- return json_success($result, '绑定成功');
- }
- /**
- * Notes:会员账户出入帐
- * @return \support\Response
- * User: yym
- * Date: 2022/7/26
- */
- public function memberAccountPay()
- {
- $mobile = $this->request->post('mobile');
- $core_member_id = DB::table('user')->where('user_account',$mobile)->value('core_member_id');
- if(empty($core_member_id)){
- throw new \Exception('会员未绑定核心库');
- }
- $cardno = $this->request->post('cardno');
- $orderno = $this->request->post('orderno');
- $io = $this->request->post('io');
- $expenses = $this->request->post('expenses');
- $added = $this->request->post('added',0);
- $detail = $this->request->post('detail','');
- $result = CardServer::memberAccountPay($core_member_id,$cardno,$orderno,$io,$expenses,$added,$detail);
- return $result;
- }
- /**
- * Notes:卡品种列表
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardMainCategoryList()
- {
- $result = CardServer::cardMainCategoryList();
- return $result;
- }
- /**
- * Notes:添加卡品种
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardMainCategoryAdd()
- {
- $card_main_category_name = $this->request->get('card_main_category_name');
- $result = CardServer::cardMainCategoryAdd($card_main_category_name);
- return $result;
- }
- /**
- * Notes:删除卡品种
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardMainCategoryDel()
- {
- $card_main_category_name = $this->request->get('card_main_category_name');
- $result = CardServer::cardMainCategoryDel($card_main_category_name);
- return $result;
- }
- /**
- * Notes:编辑卡品种
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardMainCategoryUpd()
- {
- $card_main_category_name = $this->request->get('card_main_category_name');
- $card_main_category_configs = $this->request->get('card_main_category_configs','&');
- $card_main_category_addtimes = $this->request->get('card_main_category_addtimes',1);
- $result = CardServer::cardMainCategoryUpd($card_main_category_name,$card_main_category_configs,$card_main_category_addtimes);
- //var_dump(http_build_query($result));
- return $result;
- }
- /**
- * Notes:卡品种列表
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardMainList()
- {
- $card_main_category = $this->request->get('card_main_category');
- $result = CardServer::cardMainList($card_main_category);
- return $result;
- }
- /**
- * Notes:储值卡-卡分类-创建[C]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardMainAdd()
- {
- $card_main_status = $this->request->get('card_main_category_configs','ACTIVED');
- $card_main_name = $this->request->get('card_main_name');
- $card_main_category = $this->request->get('card_main_category');
- $card_main_validday = $this->request->get('card_main_validday',0);
- $card_main_configs = $this->request->get('card_main_configs','&');
- $result = CardServer::cardMainAdd($card_main_status,$card_main_name,$card_main_category,$card_main_validday,$card_main_configs);
- return $result;
- }
- /**
- * Notes:编辑卡分类
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardMainUpd()
- {
- $card_main_id = $this->request->get('card_main_id');
- $card_main_status = $this->request->get('card_main_status','ACTIVED');
- $card_main_name = $this->request->get('card_main_name');
- $card_main_category = $this->request->get('card_main_category');
- $card_main_validday = $this->request->get('card_main_validday',1);
- $card_main_configs = $this->request->get('card_main_configs',1);
- $result = CardServer::cardMainUpd($card_main_id,$card_main_status,$card_main_name,$card_main_category,$card_main_validday,$card_main_configs);
- return $result;
- }
- /**
- * Notes:删除卡品种
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardMainDel()
- {
- $card_main_id = $this->request->get('card_main_id');
- $result = CardServer::cardMainDel($card_main_id);
- return $result;
- }
- /**
- * Notes:储值卡-卡台账-创建[批量]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardListAddBatch()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardListAddBatch";
- $params['card_city'] = $this->request->get('card_city','370100');
- $params['card_main_id'] = $this->request->get('card_main_id');
- $params['card_status'] = $this->request->get('card_status','ACTIVED');
- $params['card_batchcode'] = $this->request->get('card_batchcode');
- $params['card_def_monies'] = $this->request->get('card_def_monies',0);
- $params['card_num'] = $this->request->get('card_num');
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡台账-创建
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardListAdd()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardListAdd";
- $params['card_no'] = $this->request->get('card_no');
- $params['card_no_chip'] = $this->request->get('card_no_chip');
- $params['join_card_main_id'] = $this->request->get('join_card_main_id');
- $params['card_status'] = $this->request->get('card_status','INIT');
- $params['card_pswd'] = $this->request->get('card_pswd','123456');
- $params['card_def_monies'] = $this->request->get('card_def_monies',0);
- $params['card_qrcode'] = $this->request->get('card_qrcode');
- $params['card_batchcode'] = $this->request->get('card_batchcode');
- $params['card_extend'] = $this->request->get('card_extend');
- $params['card_addtimes'] = time();
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡台账-编辑
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardListUpd()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
-
- $data['card_no'] = $this->request->get('card_no');
- $data['card_no_chip'] = $this->request->get('card_no_chip');
- $data['join_card_main_id'] = $this->request->get('join_card_main_id');
- $data['card_status'] = $this->request->get('card_status','INIT');
- $data['card_pswd'] = $this->request->get('card_pswd','123456');
- $data['card_def_monies'] = $this->request->get('card_def_monies',0);
- $data['card_qrcode'] = $this->request->get('card_qrcode');
- $data['card_batchcode'] = $this->request->get('card_batchcode');
- $data['card_extend'] = $this->request->get('card_extend');
- $data['card_addtimes'] = time();
- $params['func'] = "functions.funcCardListUpd";
- $params['where'] = $this->request->get('where');
- $params['card_no'] = $this->request->get('card_no');
- $params['data'] = $data;
- $result = curlPost($url,json_encode($params));
- return $result;
- }
- /**
- * Notes:储值卡-卡台账-创建
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardListDel()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardListDel";
- $params['card_no'] = $this->request->get('card_no');
- $params['where'] = $this->request->get('where');
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡台账-读取[R]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardListList()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardListList";
-
- if($this->request->get('card_no') != ''){
- $params['card_no'] = $this->request->get('card_no');
- }
-
- if($this->request->get('join_card_main_id') != ''){
- $params['join_card_main_id'] = $this->request->get('join_card_main_id');
- }
-
- if($this->request->get('card_main_category') != ''){
- $params['card_main_category'] = $this->request->get('card_main_category');
- }
-
- if($this->request->get('pageno')){
- $params['pageno'] = $this->request->get('pageno');
- }else{
- $params['pageno'] = 1;
- }
-
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡动作-创建[U]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardActionAdd()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardActionAdd";
- $params['card_action_status'] = $this->request->get('card_action_status');
- $params['card_action_category'] = $this->request->get('card_action_category');
- $params['card_action_name'] = $this->request->get('card_action_name');
- $params['card_action_code'] = $this->request->get('card_action_code');
- $params['join_action_card_main_id'] = $this->request->get('join_action_card_main_id');
- $params['card_action_user_name'] = $this->request->get('card_action_user_name');
- $params['card_action_apply_user_name'] = $this->request->get('card_action_apply_user_name');
- $params['card_action_apply_orgi_name'] = $this->request->get('card_action_apply_orgi_name');
- $params['card_action_apply_count'] = $this->request->get('card_action_apply_count');
- $params['card_action_apply_content'] = $this->request->get('card_action_apply_content');
- $params['card_action_apply_extend'] = $this->request->get('card_action_apply_extend');
- $params['cardcard_action_result_no'] = $this->request->get('card_action_result');
- $params['card_action_result_count'] = $this->request->get('card_action_result_count');
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡动作-创建[U]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardActionUpd()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $data['card_action_status'] = $this->request->get('card_action_status');
- $data['card_action_category'] = $this->request->get('card_action_category');
- $data['card_action_name'] = $this->request->get('card_action_name');
- $data['card_action_code'] = $this->request->get('card_action_code');
- $data['join_action_card_main_id'] = $this->request->get('join_action_card_main_id');
- $data['card_action_user_name'] = $this->request->get('card_action_user_name');
- $data['card_action_apply_user_name'] = $this->request->get('card_action_apply_user_name');
- $data['card_action_apply_orgi_name'] = $this->request->get('card_action_apply_orgi_name');
- $data['card_action_apply_count'] = $this->request->get('card_action_apply_count');
- $data['card_action_apply_content'] = $this->request->get('card_action_apply_content');
- $data['card_action_apply_extend'] = $this->request->get('card_action_apply_extend');
- $data['cardcard_action_result_no'] = $this->request->get('card_action_result');
- $data['card_action_result_count'] = $this->request->get('card_action_result_count');
- $params['func'] = "functions.funcCardActionUpd";
- $params['card_action_id'] = $this->request->get('card_action_id');
- $params['data'] = $data;
- $result = curlPost($url,json_encode($params));
- return $result;
- }
- /**
- * Notes:储值卡-卡动作-读取[R]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardActionList()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardActionList";
- $params['card_action_id'] = $this->request->get('card_action_id');
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡动作-删除[D]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardActionDel()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardActionDel";
- $params['card_action_id'] = $this->request->get('card_action_id');
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡动作-执行[X]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardActionExecute()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardActionExecute";
- $params['card_action_id'] = $this->request->get('card_action_id');
- $params['card_action_card_no'] = $this->request->get('card_action_card_no','');
- $params['card_action_api'] = $this->request->get('card_action_api','{"type":"", "process":""}');
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡动作明细-创建[C]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardActionDetailAdd()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardActionDetailAdd";
- $params['join_card_action_id'] = $this->request->get('join_card_action_id');
- $params['card_action_card_no'] = $this->request->get('card_action_card_no');
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡动作明细-编辑[C]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardActionDetailUpd()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $data['join_card_action_id'] = $this->request->get('join_card_action_id');
- $data['card_action_card_no'] = $this->request->get('card_action_card_no');
- $params['func'] = "functions.funcCardActionDetailUpd";
- $params['card_action_detail_id'] = $this->request->get('card_action_detail_id');
- $params['data'] = $data;
- $result = curlPost($url,json_encode($params));
- return $result;
- }
- /**
- * Notes:储值卡-卡动作明细-读取[C]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardActionDetailList()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardActionDetailList";
- $params['join_card_action_id'] = $this->request->get('join_card_action_id');
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:储值卡-卡动作明细-删除[C]
- * @return \support\Response
- * User: ycp
- * Date: 2023/8/7
- */
- public function cardActionDetailDel()
- {
-
- $url = "http://core.wanyuewellness.cn/api.php";
- $params['func'] = "functions.funcCardActionDetailDel";
- $params['card_action_detail_id'] = $this->request->get('card_action_detail_id');
- $result = curlPost($url,$params);
- return $result;
- }
- /**
- * Notes:批量导入储值卡芯片码
- * @return \support\Response
- * @throws \Exception
- * User: YCP
- * Date: 2023/8/11
- */
- public function cardImport()
- {
- $excel_address = $this->request->get('excel_address');//文件地址;
- $admin_id = $this->request->admin_id;
- require_once 'vendor/phpoffice/phpexcel/Classes/PHPExcel.php';
- require_once 'vendor/phpoffice/phpexcel/Classes/PHPExcel/IOFactory.php';
- $objPHPExcel = \PHPExcel_IOFactory::load($excel_address);
- // 逐行读取 sheet 内的内容(常用)
- foreach ($objPHPExcel->getworksheetiterator() as $sheet){ //循环sheet
- foreach ($sheet->getrowiterator() as $row){ //循环row
- if ($row->getrowindex() < 2){ // 默认从第二行开始
- continue;
- }
- foreach ($row->getcelliterator() as $cell){ //循环cell
- $data[] = $cell->getvalue();
- }
- if(!empty($data)){
- $params['card_no_chip'] = $data[0];
- $result = DB::connection('mysql2')->table('tbl__core_card_list')->where(['card_no' => $data[1]])->update($params);
- if (!empty($result)){
- $msg = '管理员:' . $admin_id . '在:' . date("Y-m-d H:i:s", time()) . '导入储值卡芯片码-编号: ' . $result;
- plog('user-card-update', '储值卡-导入芯片码', $msg);
- }
-
- unset($data);
- }else{
- throw new \Exception('读取失败');
- }
- }
- }
- return json_success($excel_address, '导入成功');
- }
-
- }
|