1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183 |
- <?php
- /**
- * 机构管理界面
- *
- **by 好商城V3 www.33hao.com 运营版*/
- defined('InShopNC') or exit('Access Invalid!');
- include(BASE_CONFIG_PATH . CONFIG_PREFIX . '/refill.ini.php');
- require_once(BASE_HELPER_PATH . '/stat_helper.php');
- require_once(BASE_ROOT_PATH . '/helper/refill/functional.php');
- require_once(BASE_HELPER_PATH . '/task/task_helper.php');
- class merchantControl extends SystemControl
- {
- const EXPORT_SIZE = 1000;
- public function __construct()
- {
- parent::__construct();
- Language::read('merchant');
- }
- /**
- * 机构列表
- */
- public function merchantOp()
- {
- $model_merchant = Model('merchant');
- if (trim($_GET['merchant_name']) != '') {
- $condition['company_name'] = ['like', '%' . $_GET['merchant_name'] . '%'];
- }
- $merchant_list = $model_merchant->getMerchantList($condition, 100, 'available_predeposit desc,merchant_state asc,mchid desc', true);
- foreach ($merchant_list as $key => $merchant) {
- $merchant_list[$key]['available_predeposit'] = number_format(($merchant['available_predeposit'] - $merchant['credit_bonus']),4,'.',',');
- $merchant_list[$key]['credit_bonus'] = $merchant['credit_bonus'];
- }
- $merchant_state_text = ['使用中', '已禁用'];
- Tpl::output('merchant_state_text', $merchant_state_text);
- Tpl::output('merchant_list', $merchant_list);
- Tpl::output('page', $model_merchant->showpage('2'));
- Tpl::showpage('merchant.index');
- }
- public function changeStateOp()
- {
- $mchid = intval($_GET['mchid']);
- $state = intval($_GET['state']);
- $model_merchant = Model('merchant');
- $merchant_info = $model_merchant->getMerchantInfo(['mchid' => $mchid]);
- if (empty($merchant_info) || !in_array($state, [1, 2])) {
- showMessage('操作成功', 'index.php?act=merchant&op=merchant');
- }
- $resp = $model_merchant->editMerchant(['merchant_state' => $state], ['mchid' => $mchid]);
- if (!$resp) {
- showMessage('操作失败', 'index.php?act=merchant&op=merchant', 'html', 'error');
- }
- showMessage('操作成功', 'index.php?act=merchant&op=merchant');
- }
- public function AllCloseMerchantOp()
- {
- $model_merchant = Model('merchant');
- $resp = $model_merchant->editMerchant(['merchant_state' => 2], ['mchid' => ['gt',0]]);
- showMessage('操作成功');
- }
- public function merchant_addOp()
- {
- if (chksubmit())
- {
- $obj_validate = new Validator();
- $obj_validate->validateparam = [
- ["input" => $_POST["name"], "require" => "true", "message" => '机构账号不能为空'],
- ["input" => $_POST["company_name"], "require" => "true", "message" => '机构公司名称不能为空'],
- ["input" => $_POST["password"], "require" => "true", "message" => '密码不能为空']
- ];
- $error = $obj_validate->validate();
- if ($error != '') {
- showMessage($error);
- }
- else
- {
- $model_merchant = Model('merchant');
- $model_member = Model('member');
- $trans = new trans_wapper($model_merchant, __METHOD__);
- try
- {
- $name = trim($_POST['name']);
- $company_name = trim($_POST['company_name']);
- $pwd = trim($_POST['password']);
- $alarm_amount = $_POST['alarm_amount'] ?? 0;
- $insert_member['member_name'] = md5($name . time());
- $insert_member['member_passwd'] = $pwd;
- $insert_id = $model_member->addMember($insert_member);
- if ($insert_id == false) {
- $trans->rollback();
- showMessage('操作失败', 'index.php?act=merchant&op=merchant', 'html', 'error');
- }
- $insert_array['name'] = $name;
- $insert_array['company_name'] = $company_name;
- $insert_array['org_pwd'] = $pwd;
- $insert_array['password'] = md5($pwd);
- $insert_array['admin_id'] = trim($insert_id);
- $insert_array['alarm_amount'] = $alarm_amount;
- $result = $model_merchant->addMerchant($insert_array);
- if ($result > 0) {
- $helper = new refill\divert_account();
- $helper->init_member($insert_id);
- $ret = true;
- } else {
- $ret = false;
- }
- if($ret)
- {
- $trans->commit();
- $url = [[
- 'url' => 'index.php?act=merchant&op=merchant',
- 'msg' => '返回机构列表',
- ], [
- 'url' => 'index.php?act=merchant&op=merchant_add',
- 'msg' => '继续新增机构',
- ]];
- $this->log('添加机构:' . '[ ' . $_POST['name'] . ']', 1);
- showMessage('机构添加成功', $url);
- } else {
- $trans->rollback();
- showMessage('机构添加失败');
- }
- }
- catch (Exception $e) {
- $trans->rollback();
- showMessage('操作失败', 'index.php?act=merchant&op=merchant', 'html', 'error');
- }
- }
- }
- Tpl::showpage('merchant.add');
- }
- public function merchant_editOp()
- {
- $mchid = $_GET['mchid'] ?? $_POST['mchid'];
- $model_merchant = Model('merchant');
- $merchant = $model_merchant->getMerchantInfo(['mchid' => $mchid], '*', true);
- if (empty($merchant)) {
- showMessage('机构信息有误');
- }
- if (chksubmit())
- {
- $update_credit_bonus = ncPriceFormat($_POST['credit_bonus']);
- $operatetype = $_POST['operatetype'];
- if ($update_credit_bonus > 0) {
- if ($merchant['credit_bonus'] + $update_credit_bonus < 0) {
- showMessage('授信金额调整后不能小于0');
- }
- if ($operatetype == 'add') {
- $update['credit_bonus'] = ['exp', 'credit_bonus+' . $update_credit_bonus];
- } elseif ($operatetype == 'del') {
- $update['credit_bonus'] = ['exp', 'credit_bonus-' . $update_credit_bonus];
- }
- }
- $update['company_name'] = trim($_POST['company_name']);
- $update['org_pwd'] = trim($_POST['password']);
- $update['password'] = md5($update['org_pwd']);
- $update['alarm_amount'] = $_POST['alarm_amount'] ?? 0;
- $update['manual_recharge'] = $_POST['manual_recharge'];
- $day_timeout = intval($_POST['day_timeout']);
- $night_timeout = intval($_POST['night_timeout']);
- if($day_timeout <= 0) {
- $day_timeout = 180;
- }
- if($night_timeout <= 0) {
- $day_timeout = 180;
- }
- $update['day_timeout'] = $day_timeout;
- $update['night_timeout'] = $night_timeout;
- if(refill\functional::isDay()) {
- $update['time_out'] = intval($_POST['day_timeout']);
- } else {
- $update['time_out'] = intval($_POST['night_timeout']);
- }
- $member_id = $merchant['admin_id'];
- $model_merchant = Model('merchant');
- $trans = new trans_wapper($model_merchant, __METHOD__);
- try {
- if ($update_credit_bonus > 0) {
- $this->credit_save_money($update_credit_bonus, $operatetype, $member_id);
- }
- $result = $model_merchant->editMerchant($update, ['mchid' => $mchid]);
- if (!$result) {
- $trans->rollback();
- showMessage('机构编辑失败', 'index.php?act=merchant&op=merchant');
- }
- $trans->commit();
- $this->log('编辑机构:' . '[ ' . $merchant['name'] . ']', 1);
- showMessage('机构编辑成功', 'index.php?act=merchant&op=merchant');
- } catch (Exception $e) {
- $trans->rollback();
- showMessage('机构编辑失败', 'index.php?act=merchant&op=merchant');
- }
- }
- Tpl::output('merchant', $merchant);
- Tpl::showpage('merchant.edit');
- }
- public function priceOp()
- {
- $quality = $_GET['quality'] ?? 1;
- if (chksubmit()) {
- $mchid = $_POST['mchid'];
- //合并表单数据
- $card_types = $_POST['cardtype'];
- $specs = $_POST['spec'];
- $prices = $_POST['price'];
- $extra_prices = $_POST['extra_price'];
- $max_inprices = $_POST['max_inprice'];
- foreach ($card_types as $key => $card_type) {
- $data['card_type'] = $card_type;
- $data['spec'] = intval($specs[$key]);
- $data['price'] = ncPriceFormat($prices[$key]);
- $data['extra_price'] = ncPriceFormat($extra_prices[$key]);
- $data['max_inprice'] = ncPriceFormat($max_inprices[$key]);
- $params[] = $data;
- }
- foreach ($params as $param) {
- if ($param['price'] > 0) {
- $insert['mchid'] = $mchid;
- $insert['spec'] = $param['spec'];
- $insert['price'] = $param['price'];
- $insert['extra_price'] = $param['extra_price'];
- $insert['max_inprice'] = $param['max_inprice'];
- $insert['card_types'] = $param['card_type'];
- $insert['quality'] = $quality;
- $inserts[] = $insert;
- }
- }
- $model_merchant = Model('merchant');
- $trans = new trans_wapper($model_merchant, __METHOD__);
- try {
- //删除旧费率
- $res = $model_merchant->delPrices(['mchid' => $mchid, 'quality' => $quality]);
- if(!$res) {
- $trans->rollback();
- showMessage('删除旧费率失败');
- }
- $ret = true;
- //更新新费率
- if (!empty($inserts)) {
- $ret = $model_merchant->insertPrices($inserts);
- }
- if($ret) {
- $trans->commit();
- showMessage('操作成功');
- }else{
- $trans->rollback();
- showMessage('更新费率失败');
- }
- } catch (Exception $e) {
- $trans->rollback();
- Log::record("merchant_price update err: {$e->getMessage()}", Log::ERR);
- showMessage('操作失败');
- }
- }
- $mchid = $_GET['mchid'] ?? 0;
- $goods = $this->GoodsFormat($mchid, $quality);
- Tpl::output('goods', $goods);
- Tpl::showpage('merchant.price');
- }
- public function third_merchant_priceOp()
- {
- $mchid = $_GET['mchid'] ?? $_POST['mchid'];
- $mod = Model('thrid_refill');
- if (chksubmit()) {
- //合并表单数据
- $card_types = $_POST['cardtype'];
- $specs = $_POST['spec'];
- $prices = $_POST['price'];
- $pcodes = $_POST['pcode'];
- $quality = 1;
- $params = [];
- foreach ($card_types as $key => $card_type) {
- $data['card_type'] = $card_type;
- $data['spec'] = intval($specs[$key]);
- $data['price'] = ncPriceFormat($prices[$key]);
- $data['pcode'] = $pcodes[$key];
- $params[] = $data;
- }
- $model_merchant = Model('merchant');
- $trans = new trans_wapper($model_merchant, __METHOD__);
- try {
- foreach ($params as $param) {
- $insert = [];
- if ($param['price'] > 0) {
- $insert['mchid'] = $mchid;
- $insert['spec'] = $param['spec'];
- $insert['price'] = $param['price'];
- $insert['card_types'] = $param['card_type'];
- $insert['quality'] = $quality;
- $insert['pcode'] = $param['pcode'];
- }
- //删除旧费率
- $res = $model_merchant->delPrices(['mchid' => $mchid, 'quality' => $quality, 'pcode' => $param['pcode']]);
- if(!$res) {
- $trans->rollback();
- showMessage('删除旧费率失败');
- }
- $ret = true;
- //更新新费率
- if (!empty($insert)) {
- $ret = $model_merchant->table('merchant_price')->insert($insert);
- }
- if(!$ret) {
- $trans->rollback();
- showMessage('更新费率失败');
- }
- }
- $trans->commit();
- showMessage('操作成功', 'index.php?act=merchant&op=merchant');
- } catch (Exception $e) {
- $trans->rollback();
- Log::record("merchant_price pcode update err: {$e->getMessage()}", Log::ERR);
- showMessage('操作失败');
- }
- } else {
- $condition = [];
- if (!empty($_GET['system_code'])) {
- $condition['system_code'] = $_GET['system_code'];
- }
- if (trim($_GET['product_name']) != '') {
- $condition['product_name'] = ['like', '%' . $_GET['product_name'] . '%'];
- }
- $third_product = $mod->getProductList($condition, 30);
- $model_merchant = Model('merchant');
- $items = $model_merchant->table('merchant_price')->where(['mchid' => $mchid, 'quality' => 1, 'card_types' => mtopcard\ThirdRefillCard])->select();
- $goods = [];
- foreach ($items as $item) {
- $goods[$item['pcode']] = $item['price'];
- }
- Tpl::output('third_product', $third_product);
- Tpl::output('goods', $goods);
- Tpl::output('page', $mod->showpage());
- Tpl::showpage('third.merchant.price');
- }
- }
- private function GoodsFormat($mchid, $quality)
- {
- $all_spector = function ($quality) {
- global $config;
- $refill_specs = $config['refill_specs'];
- $all_type_specs = [];
- foreach ($refill_specs as $scard_type => $specs) {
- $card_type = mtopcard\topcard_type($scard_type);
- if (in_array($card_type, [mtopcard\ChinaMobileCard, mtopcard\ChinaUnicomCard, mtopcard\ChinaTelecomCard])) {
- if ($quality == refill\Quality::Quick) {
- $specs = array_merge($config['refill_phone_small_specs'], $specs);
- }
- }
- $all_type_specs[$card_type] = $specs;
- }
- $result = [];
- foreach ($all_type_specs as $card_type => $specs) {
- foreach ($specs as $spec) {
- $result["{$card_type}-{$spec}"] = ['card_type' => $card_type, 'spec' => $spec];
- }
- }
- return $result;
- };
- $merch_spector = function ($mchid, $quality) {
- $model_merchant = Model('merchant');
- $items = $model_merchant->table('merchant_price')->where(['mchid' => $mchid, 'quality' => $quality])->select();
- $result = [];
- foreach ($items as $item) {
- $card_types = explode(',', $item['card_types']);
- foreach ($card_types as $card_type) {
- $value['spec'] = intval($item['spec']);
- $result["{$card_type}-{$value['spec']}"] = ['card_type' => $card_type,
- 'spec' => intval($item['spec']),
- 'price' => $item['price'],
- 'extra_price' => $item['extra_price'],
- 'max_inprice' => $item['max_inprice']
- ];
- }
- }
- return $result;
- };
- $all_cardtype_specs = $all_spector($quality);
- $merch_cardtype_specs = $merch_spector($mchid, $quality);
- $merger = function ($all_specs, $mech_specs) {
- $result = [];
- foreach ($all_specs as $cardtype_spec => $value) {
- $card_name = $this->scard_type($value['card_type']);
- $data = [];
- $data['goods_name'] = $card_name;
- $data['card_type'] = $value['card_type'];
- $data['spec'] = $value['spec'];
- if (array_key_exists($cardtype_spec, $mech_specs)) {
- $data['price'] = $mech_specs[$cardtype_spec]['price'];
- $data['extra_price'] = $mech_specs[$cardtype_spec]['extra_price'];
- $data['max_inprice'] = $mech_specs[$cardtype_spec]['max_inprice'];
- } else {
- $data['price'] = 0;
- $data['extra_price'] = 0;
- $data['max_inprice'] = 0;
- }
- $result[$value['card_type']][] = $data;
- }
- return $result;
- };
- return $merger($all_cardtype_specs, $merch_cardtype_specs);
- }
- public function check_merchantOp()
- {
- $mchid = trim($_GET['mchid']);
- if (!$mchid) {
- echo '';
- die;
- }
- $model_merchant = Model('merchant');
- $merchant_info = $model_merchant->getMerchantInfo(['mchid' => $mchid], '*');
- if (empty($merchant_info)) {
- echo '';
- die;
- }
- echo 'true';
- }
- /**
- * ajax操作
- */
- public function ajaxOp()
- {
- $model_merchant = Model('merchant');
- switch ($_GET['branch']) {
- /**
- * 验证机构名称是否重复
- */
- case 'check_mch_name':
- $condition['name'] = $_GET['name'];
- $list = $model_merchant->getMerchantInfo($condition);
- if (empty($list)) {
- echo 'true';
- } else {
- echo 'false';
- }
- break;
- /**
- * 验证机构是否存在
- */
- case 'check_merchant':
- $condition['mchid'] = intval($_GET['mchid']);
- $list = $model_merchant->getMerchantInfo($condition);
- if (!empty($list)) {
- echo 'true';
- } else {
- echo 'false';
- }
- }
- }
- public function check_evidenceOp()
- {
- $status = $_GET['status'];
- $apply_id = intval($_GET['apply_id']);
- if ($apply_id > 0) {
- $model_merchant = Model('merchant');
- $evidence_info = $model_merchant->getRefillEvidenceInfo(['apply_id' => $apply_id], '*', true);
- if (empty($evidence_info)) {
- showMessage('充值申请不存在');
- }
- if ($status == 'pass') {
- $model_merchant->editRefillEvidence(['apply_id' => $apply_id], ['status' => 2, 'check_time' => time()]);
- } elseif ($status == 'unpass') {
- $model_merchant->editRefillEvidence(['apply_id' => $apply_id], ['status' => 3, 'check_time' => time()]);
- } else {
- showMessage('审核类型错误');
- }
- }
- showMessage(L('nc_common_save_succ'), urlAdmin('refill_evidence', 'index'));
- }
- //处理充值申请
- public function rechargeOp()
- {
- if (chksubmit()) {
- $mchid = $this->add_money();
- $model_merchant = Model('merchant');
- $merchant_info = $model_merchant->getMerchantInfo(['mchid' => $mchid]);
- if ($merchant_info['alarm_amount'] < $merchant_info['available_predeposit']) {
- //更新预警短信通知限制
- $mch_cache = rcache("merchant-notify", 'refill-');
- $caches = empty($mch_cache['data']) ? [] : unserialize($mch_cache['data']);
- $caches[$mchid] = ['last_time' => 0, 'send_count' => 0];
- wcache("merchant-notify", ['data' => serialize($caches)], 'refill-');
- }
- showMessage('操作成功', 'index.php?act=refill_evidence&op=index');
- } else {
- $apply_id = $_GET['apply_id'];
- if (!empty($apply_id)) {
- $model_merchant = Model('merchant');
- $evidence_info = $model_merchant->getRefillEvidenceInfo(['apply_id' => $apply_id], '*,member.available_predeposit', true);
- Tpl::output('apply_id', $apply_id);
- Tpl::output('amount', $evidence_info['amount']);
- Tpl::output('available_predeposit', $evidence_info['available_predeposit']);
- }
- global $config;
- Tpl::output('receive_bank', $config['receive_bank'][COMPANY_NAME]);
- Tpl::showpage('recharge.add');
- }
- }
- public function recharge_manualOp()
- {
- $type = $_GET['type'] ?? $_POST['type'];
- if (chksubmit()) {
- $add_type = '';
- $obj_validate = new Validator();
- if ($type == 'add') {
- $add_type = '加款';
- $obj_validate->validateparam = [
- ["input" => $_POST["mch_id"], "require" => "true", "message" => '机构号不能为空'],
- ["input" => $_POST["bank_username"], "require" => "true", "message" => '开户人姓名不能为空'],
- ["input" => $_POST["bank_name"], "require" => "true", "message" => '开户银行不能为空'],
- ["input" => $_POST["pointsnum"], "require" => "true", "message" => '预存金额不能为空'],
- ["input" => $_POST["receive_bank"], "require" => "true", "message" => '请选择收款银行']
- ];
- } elseif ($type == 'edit') {
- $add_type = '调款';
- $obj_validate->validateparam = [
- ["input" => $_POST["mch_id"], "require" => "true", "message" => '机构号不能为空'],
- ["input" => $_POST["bank_username"], "require" => "true", "message" => '操作人姓名不能为空'],
- ["input" => $_POST["pointsnum"], "require" => "true", "message" => '预存金额不能为空']
- ];
- }
- $operatetype = $_POST['operatetype'];
- $error = $obj_validate->validate();
- if ($error != '') {
- showMessage($error);
- }
- $mchid = $_POST["mch_id"];
- $model_merchant = Model('merchant');
- $merchant_info = $model_merchant->getMerchantInfo(['mchid' => $mchid]);
- if (!$merchant_info) {
- showMessage('对应机构不存在');
- }
- $pointsnum = $_POST['pointsnum'];
- $money = abs($pointsnum);
- if ($money == 0) {
- showMessage('预存金额错误');
- }
- if (!empty($_FILES['voucher']['name'])) {
- $upload = new UploadFile();
- $upload->set('default_dir', ATTACH_UPFILE);
- $result = $upload->upfile('voucher');
- if ($result) {
- $_POST['voucher_name'] = $upload->file_name;
- } else {
- showMessage($upload->error);
- }
- }
- $trans = new trans_wapper($model_merchant, __METHOD__);
- try {
- $member_id = $merchant_info['admin_id'];
- if ($operatetype == 'add') {
- $bz = "管理员{$add_type}操作,手动增加预存金额";
- $this->credit_save_money($money, 'add', $member_id, $bz);
- $_POST['pointsnum'] = $money;
- } elseif ($operatetype == 'del') {
- $bz = "管理员{$add_type}操作,手动减少预存金额";
- $this->credit_save_money($money, 'del', $member_id, $bz);
- $_POST['pointsnum'] = -($money);
- } else {
- showMessage('预存类型错误');
- }
- $result = $this->ct_refill_evidence($_POST, $merchant_info);
- if (!$result) {
- $trans->rollback();
- showMessage('操作失败', 'index.php?act=merchant&op=merchant');
- }
- $trans->commit();
- if ($merchant_info['alarm_amount'] < $merchant_info['available_predeposit']) {
- //更新预警短信通知限制
- $mch_cache = rcache("merchant-notify", 'refill-');
- $caches = empty($mch_cache['data']) ? [] : unserialize($mch_cache['data']);
- $caches[$mchid] = ['last_time' => 0, 'send_count' => 0];
- wcache("merchant-notify", ['data' => serialize($caches)], 'refill-');
- }
- showMessage('操作成功', 'index.php?act=refill_evidence&op=index');
- } catch (Exception $e) {
- $trans->rollback();
- showMessage('操作失败', 'index.php?act=refill_evidence&op=index');
- }
- } else {
- $mchid = $_GET['mchid'] ?? $_POST['mchid'];
- $model_merchant = Model('merchant');
- $merchant = $model_merchant->getMerchantInfo(['mchid' => $mchid]);
- if (empty($merchant)) {
- showMessage('机构信息有误');
- }
- Tpl::output('merchant', $merchant);
- global $config;
- Tpl::output('receive_bank', $config['receive_bank'][COMPANY_NAME]);
- $page = "recharge.manual.{$type}";
- Tpl::showpage($page);
- }
- }
- private function ct_refill_evidence($params, $merchant_info)
- {
- $admininfo = $this->getAdminInfo();
- $mem_info = Model('member')->getMemberInfo(['member_id' => $merchant_info['admin_id']]);
- $input['mchid'] = $merchant_info['mchid'];
- $input['mch_name'] = $merchant_info['name'];
- $input['member_id'] = $merchant_info['admin_id'];
- $input['amount'] = $params['pointsnum'];
- $input['bank_username'] = $params['bank_username'];
- $input['bank_name'] = $params['bank_name'] ?? '';
- $input['bz'] = $params['pointsdesc'];
- $input['voucher_name'] = $params['voucher_name'] ?? '/';
- $input['status'] = 2;
- $input['is_operation'] = 2;
- $input['add_time'] = $input['check_time'] = time();
- $input['after_available'] = ncPriceFormat($mem_info['available_predeposit'] + $params['pointsnum']);
- $input['admin_name'] = $admininfo['name'];
- $input['admin_id'] = $admininfo['id'];
- $input['add_type'] = $params['add_type'];
- $input['receive_bank'] = $params['receive_bank'] ?? 0;
- if ($params['type'] == 'add') {
- $input['is_bank'] = 1;
- }
- $model_merchant = Model('merchant');
- return $model_merchant->addRefillEvidence($input);
- }
- public function add_money()
- {
- $obj_validate = new Validator();
- $obj_validate->validateparam = [
- ["input" => $_POST["apply_id"], "require" => "true", "message" => Language::get('admin_points_member_error_again')],
- ["input" => $_POST["pointsnum"], "require" => "true", 'validator' => 'Compare', 'operator' => ' >= ', 'to' => 1, "message" => Language::get('admin_points_points_min_error')],
- ["input" => $_POST["receive_bank"], "require" => "true", "message" => '请选择收款银行']
- ];
- $error = $obj_validate->validate();
- if ($error != '') {
- showMessage($error, '', '', 'error');
- }
- $money = abs(floatval($_POST['pointsnum']));
- $memo = trim($_POST['pointsdesc']);
- if ($money <= 0) {
- showMessage('输入的金额必需大于0', '', 'html', 'error');
- }
- $apply_id = intval($_POST['apply_id']);
- $model_merchant = Model('merchant');
- $receive_bank = $_POST['receive_bank'] ?? 0;
- $evidence_info = $model_merchant->getRefillEvidenceInfo(['apply_id' => $apply_id], '*', true);
- if (!is_array($evidence_info) || count($evidence_info) <= 0) {
- showMessage("无效的充值申请信息", "index.php?act=merchant&op=recharge&apply_id={$apply_id}", '', 'error');
- }
- if ($evidence_info['status'] != 2) {
- showMessage("该充值申请未被审核通过", "index.php?act=merchant&op=recharge&apply_id={$apply_id}", '', 'error');
- }
- if ($evidence_info['is_operation'] == 2) {
- showMessage("该充值申请未已被预存过", "index.php?act=merchant&op=recharge&apply_id={$apply_id}", '', 'error');
- }
- //查询会员信息
- $obj_member = Model('member');
- $member_id = intval($evidence_info['member_id']);
- $member_info = $obj_member->getMemberInfo(['member_id' => $member_id], '*', true);
- $available_predeposit = floatval($member_info['available_predeposit']);
- $freeze_predeposit = floatval($member_info['freeze_predeposit']);
- if ($_POST['operatetype'] == 3 && $money > $available_predeposit) {
- showMessage(('可冻结预存款不足,会员当前预存款') . $available_predeposit, 'index.php?act=predeposit&op=predeposit_add', '', 'error');
- }
- if ($_POST['operatetype'] == 4 && $money > $freeze_predeposit) {
- showMessage(('可恢复冻结预存款不足,会员当前冻结预存款') . $freeze_predeposit, 'index.php?act=predeposit&op=predeposit_add', '', 'error');
- }
- $model_pd = Model('predeposit');
- $order_sn = $apply_id;
- $admininfo = $this->getAdminInfo();
- $log_msg = "管理员【" . $admininfo['name'] . "】操作会员【" . $member_info['member_name'] . "】预存款,金额为" . $money . ",编号为" . $order_sn;
- $admin_act = 'sys_add_money';
- switch ($_POST['operatetype']) {
- case 1:
- $admin_act = "sys_add_money";
- $log_msg = "管理员【" . $admininfo['name'] . "】操作会员【" . $member_info['member_name'] . "】预存款【增加】,金额为" . $money . ",编号为" . $order_sn;
- break;
- case 2:
- $admin_act = "sys_del_money";
- $log_msg = "管理员【" . $admininfo['name'] . "】操作会员【" . $member_info['member_name'] . "】预存款【减少】,金额为" . $money . ",编号为" . $order_sn;
- break;
- default:
- showMessage('操作失败', 'index.php?act=refill_evidence&op=index');
- break;
- }
- $trans = new trans_wapper($model_pd, __METHOD__);
- try {
- $evidence_info = $model_merchant->getRefillEvidenceInfo(['apply_id' => $apply_id], '*', true,true);
- if ($evidence_info['is_operation'] == 2) {
- $trans->commit();
- showMessage('已经处理', 'index.php?act=refill_evidence&op=index', 'html', 'error');
- }
- //扣除冻结的预存款
- $data = [];
- $data['member_id'] = $member_info['member_id'];
- $data['member_name'] = $member_info['member_name'];
- $data['amount'] = $money;
- $data['order_sn'] = $order_sn;
- $data['admin_name'] = $admininfo['name'];
- $data['pdr_sn'] = $order_sn;
- $data['lg_desc'] = $memo;
- $isRefill = $model_pd->isRefill($data['member_id']);
- $model_pd->changePd($admin_act, $data,$isRefill);
- $after_available = ncPriceFormat($available_predeposit + $evidence_info['amount']);
- $model_merchant->editRefillEvidence(
- ['apply_id' => $apply_id],
- [
- 'is_operation' => 2, 'after_available' => $after_available,
- 'admin_id' => $admininfo['id'], 'admin_name' => $admininfo['name'],
- 'receive_bank' => $receive_bank
- ]
- );
- $trans->commit();
- $this->log($log_msg, 1);
- return $evidence_info['mchid'];
- } catch (Exception $e) {
- $trans->rollback();
- $this->log($log_msg, 0);
- showMessage($e->getMessage(), 'index.php?act=refill_evidence&op=index', 'html', 'error');
- }
- }
- public function checkevidenceOp()
- {
- $apply_id = trim($_GET['apply_id']);
- if (!$apply_id) {
- echo '';
- die;
- }
- $model_merchant = Model('merchant');
- $evidence_info = $model_merchant->getRefillEvidenceInfo(['apply_id' => $apply_id], '*');
- if (empty($evidence_info)) {
- echo '';
- die;
- }
- echo 'true';
- }
- public function notify_merchantOp()
- {
- $order_id = $_GET['order_id'];
- $mod_order = Model('vr_order');
- $order_info = $mod_order->getOrderInfo(['order_id' => $order_id]);
- $refill_info = Model('refill_order')->getOrderInfo(['order_id' => $order_id, 'inner_status' => 0, 'is_retrying' => 0]);
- if (empty($refill_info)) {
- showMessage('订单不存在,或不符合条件', '');
- }
- if ($order_info['order_state'] == ORDER_STATE_SEND) {
- QueueClient::push("QueryRefillState", ['order_id' => $order_id]);
- } else {
- QueueClient::push("NotifyMerchantComplete", ['order_id' => $order_id, 'manual' => true]);
- }
- showMessage('操作成功', '');
- }
- public function notify_manual_merchantOp()
- {
- $order_id = $_GET['order_id'];
- $type = $_GET['type'];
- $mod_order = Model('vr_order');
- $order_info = $mod_order->getOrderInfo(['order_id' => $order_id, 'order_state' => ORDER_STATE_SEND]);
- $refill_info = Model('refill_order')->getOrderInfo(['order_id' => $order_id, 'inner_status' => 0, 'is_retrying' => 0]);
- if (empty($refill_info) || empty($order_info)) {
- showMessage('订单不存在,或不符合条件');
- }
- $fetch_order_ids = $this->check_fetch_order($order_id);
- if (in_array($order_id, $fetch_order_ids)) {
- showMessage('此订单不可手动操作,请联系抢单人员操作!');
- }
- if ($type == 'success') {
- refill\util::manual_success($order_id);
- } elseif ($type == 'cancel') {
- refill\util::manual_cancel($order_id);
- } else {
- showMessage('手动操作类型错误', 'index.php?act=refill_order&op=index');
- }
- $this->manual_log_record($refill_info, $type);
- showMessage('操作成功');
- }
- private function manual_log_record($order, $oper_type)
- {
- $admininfo = $this->getAdminInfo();
- $cur_time = time();
- $bz = "手动处理订单,操作者:{$admininfo['name']}";
- $ins = [
- 'order_id' => $order['order_id'], 'order_sn' => $order['order_sn'],'order_time' => $order['order_time'], 'notify_time' => $order['notify_time'],
- 'manual_type' => $oper_type, 'admin_id' => $admininfo['id'], 'admin_name' => $admininfo['name'], 'act_time' => $cur_time, 'bz' => $bz
- ];
- Model('refill_buyback')->insert($ins);
- }
- public function provider_provinceOp()
- {
- $provider_model = Model('refill_provider');
- $provider_id = $_GET['id'] ?? $_POST['id'];
- $provider = $provider_model->getProviderInfo(['provider_id' => $provider_id]);
- if (empty($provider)) {
- showMessage('通道信息有误');
- }
- $operator = [mtopcard\ChinaMobileCard, mtopcard\ChinaUnicomCard, mtopcard\ChinaTelecomCard];
- if (chksubmit()) {
- foreach ($operator as $opr) {
- $key = $opr . '-province';
- $province = $_POST[$key];
- if ($province == -1) {
- $updata[$opr] = -1;
- } else {
- $updata[$opr] = implode(',', $province);
- }
- }
- $resp = $provider_model->editProvider(['provinces' => serialize($updata)], ['provider_id' => $provider_id]);
- if ($resp) {
- showMessage('编辑成功', 'index.php?act=provider&op=index');
- } else {
- showMessage('编辑失败', "index.php?act=merchant&op=provider_province&id={$provider_id}");
- }
- } else {
- $data = unserialize($provider['provinces']);
- $provinces = [];
- foreach ($operator as $opr) {
- if (empty($data)) {
- $provinces[$opr] = [-1];
- } else {
- $provinces[$opr] = explode(',', $data[$opr]);
- }
- }
- $province_list = mtopcard\ProvinceList;
- Tpl::output('province_list', $province_list);
- Tpl::output('provider', $provider);
- Tpl::output('provinces', $provinces);
- Tpl::showpage('provider.province');
- }
- }
- public function changeProviderStateOp()
- {
- $provider_id = intval($_GET['id']);
- $state = intval($_GET['state']);
- $provider_model = Model('refill_provider');
- $provider_info = $provider_model->getProviderInfo(['provider_id' => $provider_id]);
- if (empty($provider_info) || !in_array($state, [1, 2])) {
- showMessage('操作成功', 'index.php?act=provider&op=index');
- }
- $resp = $provider_model->editProvider(['opened' => $state], ['provider_id' => $provider_id]);
- if (!$resp) {
- showMessage('操作失败', 'index.php?act=provider&op=index', 'html', 'error');
- }
- showMessage('操作成功', 'index.php?act=provider&op=index');
- }
- /**
- * 新增通道
- */
- public function provider_addOp()
- {
- $provider_model = Model('refill_provider');
- if (chksubmit()) {
- $params = $_POST;
- unset($params['form_submit']);
- $result = $provider_model->addProvider($params);
- if ($result) {
- $url = [
- [
- 'url' => 'index.php?act=provider&op=index',
- 'msg' => '返回通道列表',
- ],
- [
- 'url' => 'index.php?act=merchant&op=provider_add',
- 'msg' => '继续新增通道',
- ],
- ];
- $this->log('添加通道:' . '[ ' . $_POST['name'] . ']', 1);
- showMessage('通道添加成功', $url);
- } else {
- showMessage('通道添加失败');
- }
- }
- Tpl::showpage('provider.add');
- }
- public function provider_editOp()
- {
- $provider_model = Model('refill_provider');
- if (chksubmit()) {
- $provider_id = intval($_POST['provider_id']) ?? '';
- $provider = $provider_model->getProviderInfo(['provider_id' => $provider_id]);
- if (empty($provider)) {
- showMessage('通道信息有误');
- }
- $params = $_POST;
- unset($params['form_submit']);
- if (empty($params)) {
- showMessage('通道编辑成功', 'index.php?act=provider&op=index');
- }
- $result = $provider_model->editProvider($params, ['provider_id' => $provider_id]);
- if ($result) {
- $this->log('编辑通道:' . '[ ' . $provider['name'] . ']', 1);
- showMessage('通道编辑成功', 'index.php?act=provider&op=index');
- } else {
- showMessage('通道编辑失败', "index.php?act=merchant&op=provider_edit&id={$provider_id}");
- }
- }
- $provider_id = intval($_GET['id']) ?? '';
- $provider = $provider_model->getProviderInfo(['provider_id' => $provider_id]);
- if (empty($provider)) {
- showMessage('通道信息有误');
- }
- $type_text = ['油卡', '手机充值卡'];
- Tpl::output('type_text', $type_text);
- Tpl::output('provider', $provider);
- Tpl::showpage('provider.edit');
- }
- public function provider_delOp()
- {
- $provider_model = Model('refill_provider');
- $provider_id = intval($_GET['id']) ?? '';
- $provider = $provider_model->getProviderInfo(['provider_id' => $provider_id]);
- if (empty($provider)) {
- showMessage('通道信息有误');
- }
- $result = $provider_model->delProvider(['provider_id' => $provider_id]);
- if ($result) {
- $this->log('删除通道:' . '[ ' . $provider['name'] . ']', 1);
- showMessage('通道删除成功', 'index.php?act=provider&op=index');
- } else {
- showMessage('通道删除失败', "index.php?act=provider&op=index");
- }
- }
- public function OrderStatsCheckOp()
- {
- $stat_id = $_GET['stat_id'] ?? $_POST['stat_id'];
- $mod_stat = Model('refill_stats');
- $stats_data = $mod_stat->getStatsInfo(['stat_id' => $stat_id]);
- if (empty($stats_data)) {
- showMessage('对应数据不存在', '');
- }
- $type = $stats_data['type'];
- if (chksubmit()) {
- $corder_success_count = $_POST['corder_success_count'] ?? 0;
- $corder_success_amounts = $_POST['corder_success_amounts'] ?? 0;
- $corder_success_refill_amounts = $_POST['corder_success_refill_amounts'] ?? 0;
- $refund = $_POST['refund'] ?? 0;
- $remark = $_POST['remark'];
- $gap_order_count = $gap_success_amounts = $gap_success_refill_amounts = 0;
- if ($type == 'provider') {
- if (!empty($corder_success_amounts)) {
- $gap_success_amounts = $corder_success_amounts - $stats_data['success_channel_amounts'];
- }
- if (!empty($corder_success_count)) {
- $gap_order_count = $corder_success_count - $stats_data['success_count'];
- }
- } elseif ($type == 'merchant') {
- if (!empty($corder_success_count)) {
- $gap_order_count = $stats_data['success_count'] - $corder_success_count;
- }
- if (!empty($corder_success_amounts)) {
- $gap_success_amounts = $stats_data['success_channel_amounts'] - $corder_success_amounts;
- }
- } else {
- showMessage('对账数据类型错误', 'index.php?act=OrderStats&op=index');
- }
- if (!empty($corder_success_refill_amounts)) {
- $gap_success_refill_amounts = $corder_success_refill_amounts - $stats_data['success_refill_amounts'];
- }
- $updata['corder_success_count'] = $corder_success_count;
- $updata['corder_success_amounts'] = $corder_success_amounts;
- $updata['corder_success_refill_amounts'] = $corder_success_refill_amounts;
- $updata['gap_order_count'] = $gap_order_count;
- $updata['gap_success_amounts'] = $gap_success_amounts;
- $updata['gap_success_refill_amounts'] = $gap_success_refill_amounts;
- $updata['remark'] = $remark;
- $updata['refund'] = $refund;
- if (!empty($corder_success_count) && !empty($corder_success_amounts) && !empty($corder_success_refill_amounts)) {
- if ($gap_order_count == 0 && $gap_success_amounts == 0 && $gap_success_refill_amounts == 0) {
- $updata['check_status'] = 1;
- } else {
- $updata['check_status'] = 2;
- }
- }
- $res = $mod_stat->edit($stat_id, $updata);
- if ($res) {
- showMessage('操作成功', "index.php?act=OrderStats&op=index&type={$type}&cid={$stats_data['cid']}&order_time_type={$stats_data['order_time_type']}");
- } else {
- showMessage('操作失败');
- }
- } else {
- $type_text = ['provider' => '上游', 'merchant' => '商户'];
- Tpl::output('stats_type', $type_text[$type]);
- Tpl::output('stats_data', $stats_data);
- Tpl::showpage('order.stats.check');
- }
- }
- public function OrderStatsReloadOp()
- {
- $stat_id = $_GET['stat_id'];
- $mod_stat = Model('refill_stats');
- $stats_data = $mod_stat->getStatsInfo(['stat_id' => $stat_id]);
- if (empty($stats_data)) {
- showMessage('对应数据不存在', '');
- }
- $cond = [
- 'type' => $stats_data['type'],
- 'time_stamp' => $stats_data['time_stamp'],
- 'cid' => $stats_data['cid'],
- 'order_time_type' => $stats_data['order_time_type']
- ];
- $manager = new task\manager();
- $task = $manager->add_task('order_stat_reload',$cond,0,3600);
- if ($task->completed() && $task->success()) {
- showMessage('操作成功');
- } else {
- showMessage("操作成功,后台任务已开始重新统计,请稍后查看新数据");
- }
- }
- public function merchant_ctlOp()
- {
- $mchid = $_GET['mchid'] ?? $_POST['mchid'];
- $model_merchant = Model('merchant');
- $merchant = $model_merchant->getMerchantInfo(['mchid' => $mchid], '*', true);
- if (empty($merchant)) {
- showMessage('机构信息有误');
- }
- $qualitys = [
- refill\Quality::Normal, refill\Quality::Quick, refill\Quality::CardKey, refill\Quality::ThirdShop,
- refill\Quality::SlowTwentyFour, refill\Quality::SlowSix, refill\Quality::SlowTwo, refill\Quality::SlowFortyEight,
- refill\Quality::SlowSeventyTwo, refill\Quality::Fastest
- ];
- if(chksubmit())
- {
- $intercept_data = function (){
- $intercept_cfg['is_transfer'] = intval($_POST['is_transfer']) === 1;
- if (!empty($_POST['card_states'])) {
- foreach ($_POST['card_states'] as $card_state)
- {
- $card_states[] = intval($card_state);
- }
- $intercept_cfg['card_states'] = $card_states;
- }
- if (!empty($_POST['card_types'])) {
- foreach ($_POST['card_types'] as $card_type)
- {
- $card_types[] = intval($card_type);
- }
- $intercept_cfg['card_types'] = $card_types;
- }
- return serialize($intercept_cfg);
- };
- $retry_times_data = function ($qualitys){
- $qualities = [];
- foreach ($qualitys as $quality) {
- $quality = intval($quality);
- $day_secs_key = "{$quality}-day_secs";
- $night_secs_key = "{$quality}-night_secs";
- $times_key = "{$quality}-times";
- if(!empty($_POST[$day_secs_key]) && !empty($_POST[$night_secs_key]) && !empty($_POST[$times_key])) {
- $qualities[$quality] = ['day_secs' => intval($_POST[$day_secs_key]), 'night_secs' => intval($_POST[$night_secs_key]), 'times' => intval($_POST[$times_key])];
- }
- }
- $retry_times_cfg['qualities'] = $qualities;
- $ratio = floatval($_POST['ratio']) ?? 0;
- $period = intval($_POST['period']) ?? 0;
- $profit_ratio = floatval($_POST['profit_ratio']) ?? 0;
- $retry_times_cfg['lower_ratio'] = ['ratio' => $ratio, 'period' => $period];
- $retry_times_cfg['profit_ratio'] = $profit_ratio;
- $profit_formula = $_POST['profit_formula'] ?? '';
- $retry_times_cfg['profit_formula'] = $profit_formula;
- return serialize($retry_times_cfg);
- };
- $update['quality'] = intval($_POST['quality']);
- $update['oil_quality'] = intval($_POST['oil_quality']);
- $update['intercept_cfg'] = $intercept_data();
- $update['retry_times_cfg'] = $retry_times_data($qualitys);
- $resp = $model_merchant->editMerchant($update, ['mchid' => $mchid]);
- if ($resp) {
- showMessage('操作成功', 'index.php?act=merchant&op=merchant');
- } else {
- showMessage('操作失败');
- }
- }
- else
- {
- foreach ($qualitys as $value) {
- $quality[$value] = $this->quality_format($value,mtopcard\ChinaMobileCard);
- }
- Tpl::output('intercept', $this->merchant_intercept($merchant));
- Tpl::output('retry_times', $this->merchant_retry_times($merchant));
- Tpl::output('merchant', $merchant);
- Tpl::output('quality', $quality);
- Tpl::output('card_state', mtopcard\CardState);
- Tpl::showpage('merchant.ctl');
- }
- }
- private function merchant_intercept($merchant)
- {
- $intercept_cfg = $merchant['intercept_cfg'];
- if (empty($intercept_cfg)) {
- $intercept_cfg = ['card_states' => [], 'is_transfer' => 0];
- } else {
- $intercept_cfg = unserialize($intercept_cfg);
- }
- return $intercept_cfg;
- }
- private function merchant_retry_times($merchant)
- {
- $retry_times_cfg = $merchant['retry_times_cfg'];
- if (empty($retry_times_cfg)) {
- $retry_times_cfg = [];
- } else {
- $retry_times_cfg = unserialize($retry_times_cfg);
- }
- return $retry_times_cfg;
- }
- }
|