public function doPayAction()
{
$model = D("PtContract");
$conract_id = I("current_contract_id");
$contract = $model->find($conract_id);
$member_id = $contract['member_id'];
$member = M("MemberBasic")->find($member_id);
$recharge = 0;
$price = $contract['should_pay'] - $contract['paid'];
if (I('use_recharge') == 1) {
$recharge = $member['recharge'];
$recharge = $recharge > $price ? $price : $recharge;
}
$service = \Service\CService::factory("Financial");
$project = $service->getBillProject("1", I("current_contract_id"));
$ret = $service->pay($project['id'], 1, is_user_login(), get_brand_id(), I("description"), I("cash"), I("pos"), I("check"), I('check_num'), get_club_id(), $recharge, I("network"), I("netbank"));
if (!$ret) {
$this->error($service->getError());
}
if (I('use_recharge') == 1 && $recharge > 0) {
M("MemberBasic")->where(array("id" => $member_id))->setField("recharge", $member['recharge'] - $recharge);
$data = array("member_id" => $member_id, "value" => "-{$recharge}", "record_id" => is_user_login(), "description" => "PT收款消费￥{$recharge},余额￥" . ($member['recharge'] - $recharge));
M("RechargeHistory")->data($data)->add();
}
$project = $service->getBillProject("1", I("current_contract_id"));
$contract['paid'] = $project['paid'];
$contract['update_time'] = getDbTime();
$contract['description'] = I("description");
$model->data($contract)->save();
//cash history
// $cashHistoryModel=M("CashHistory");
// $data=array("record_id"=>is_user_login(),"price"=>$paid,"brand_id"=>get_brand_id(),"description"=>I("description"),"object_id"=>$contract_id,"update_time"=>getDbTime(),"club_id"=>get_club_id());
// $cashHistoryModel->data($data)->add();
$this->success("收款成功！", "/Cashier/Ptcontract/index");
}
public function assignAction($members, $mc_id)
{
if (empty($mc_id)) {
$this->error("Please choose one mc!");
}
$model = M("MemberBasic");
foreach ($members as $key => $value) {
$model->where("id={$value}")->setField(array("mc_id" => $mc_id, "assign_time" => getDbTime()));
}
$this->success("指派成功!");
}
public function consumeendAction($id)
{
$contract = M("PtContract")->find($id);
if (empty($contract)) {
$this->error("Contract is not exist...");
}
if ($contract['invalid'] != 1) {
$this->error("合同非正常状态！");
}
if ($contract['status'] != 1) {
$this->error("请先开始上课！");
}
M("PtContract")->where("id={$id}")->setField("status", 0);
M("PtConsumeHistory")->where(array("contract_id" => $id))->order("id desc")->limit(1)->setField("end_time", getDbTime());
$this->success("消课成功！");
}
public function consumeAction($code, $name, $phone)
{
$rules = array(array('code', 'require', '蜘蛛码必须！', 1), array('name', 'require', '姓名必须！', 1), array('phone', 'require', '电话必须！', 1));
$model = D("SpiderCode");
if (!$model->validate($rules)->create()) {
$this->error($model->getError());
}
$c = M("SpiderCode")->where(array("code" => $code))->find();
if (empty($c)) {
$this->error("号码不存在");
}
if ($c['valid'] != 0) {
$this->error("蜘蛛码被其他人消费！请重新提供！");
}
$model->where(array("code" => $code))->setField(array("use_time" => getDbTime(), "record_id" => is_user_login(), "valid" => 1, "name" => $name, "phone" => $phone));
$this->ajaxReturn(array("status" => 1));
}
public function registAction($username, $password, $verifycode, $email, $confirm_password)
{
session('[start]');
// if(!check_verify($verifycode)){
// $this->error('验证码输入错误！');
// }
$model = D("User");
$rules = array(array('username', '1,30', "用户名至少1-30位！", 1, 'length'), array('username', '', "用户名已被注册！", 1, 'unique'), array('password', '6,30', "密码至少6-30位！", 1, 'length'), array('confirm_password', 'password', '确认密码不正确!', 1, 'confirm'));
$arr = array("confirm_password" => $confirm_password, "email" => $email, "username" => $username, "password" => md5($password), "name_cn" => time(), "name_en" => time(), "last_login_time" => getDbTime(), "last_login_ip" => get_client_ip(0));
if (!$model->data($arr)->validate($rules)->create()) {
$this->error($model->getError());
}
$id = $model->data(array("username" => $username, "password" => $password, "last_login_time" => getDbTime(), "last_login_ip" => get_client_ip(0)))->add();
D("UserExtension")->data(array("id" => $id, "name_cn" => time(), "name_en" => time()))->add();
$user = $model->where("id={$id}")->find();
userLoginSession($user);
session('[destroy]');
$this->success('登录成功！', U('Main/teacher'));
}
public function addAction()
{
$rules = array(array('username', '1,30', "用户名至少1-30位！", 1, 'length'), array('username', '', "用户名已被注册！", 1, 'unique'), array('password', '6,30', "密码至少6-30位！", 1, 'length'), array('confirm_password', 'password', '确认密码不正确!', 1, 'confirm'), array('name_cn', 'require', "请输入中文名！", 1), array('name_en', 'require', "请输入英文名！", 1), array('identity_card', '/^\\d{15}$|^\\d{17}(\\d|[Xx])$/', "身份证号码不对！", 2));
$userModel = M("User");
$extensionModel = M("UserExtension");
if (!$userModel->validate($rules)->create()) {
$this->error($userModel->getError());
} else {
$userModel->brand_id = get_brand_id();
$userModel->club_id = get_club_id();
$userModel->password = ucenter_md5(I("password"), C("MD5_SECRET_KEY"));
$userModel->update_time = getDbTime();
$id = $userModel->add();
if (!$extensionModel->create()) {
$userModel->delete($id);
$this->error($extensionModel->getError());
} else {
$avatar = "default.jpg";
if (!empty($_FILES["avatar"]["name"])) {
$config["savePath"] = "em_avatar";
$upload = new \Think\Upload();
// 实例化上传类
$upload->maxSize = 31457280;
// 设置附件上传大小
$upload->exts = array('jpg', 'gif', 'png', 'jpeg');
// 设置附件上传类型
$upload->rootPath = './Public/uploads/';
// 设置附件上传根目录
$upload->savePath = "em_avatar/";
$upload->autoSub = false;
$upload->replace = true;
$upload->saveName = "{$id}";
$info = $upload->upload();
if (!$info) {
$userModel->delete($id);
$this->error($upload->getError());
} else {
$avatar = $info["avatar"]['savename'];
}
}
$extensionModel->id = $id;
$extensionModel->avatar = $avatar;
$extensionModel->update_time = getDbTime();
$extensionModel->add();
//add roles
$roles = I('roles');
foreach ($roles as $key => $value) {
M("AuthGroupAccess")->data(array("uid" => $id, "group_id" => $value))->add();
}
}
}
$this->success('成功！', U('Shopkeeper/Employee/index'));
}
private function updateLogin($uid)
{
$data = array('id' => $uid, 'last_login_time' => getDbTime(), 'last_login_ip' => get_client_ip(0));
M("User")->save($data);
}
protected function updateLogin($uid)
{
$data = array('id' => $uid, 'last_login_time' => getDbTime(), 'last_login_ip' => get_client_ip(0));
$this->sysUserModel->save($data);
}
public function doTransformAction1($owner_id, $contract_id, $new_id, $new_card_number)
{
$memberModel = M("MemberBasic");
$cardModel = M("Card");
$contractModel = M("Contract");
$originalcontract = $contract = $contractModel->find($contract_id);
$is_active = 1;
if ($contract['active_type'] == 2 && $contract['start_time'] == '0000-00-00') {
$is_active = 0;
}
$new_member = $memberModel->find($new_id);
if (empty($new_member)) {
$this->error("Can't find this member in your brand's database!");
}
if ($contract['member_id'] != $owner_id) {
$this->error("This contract not belongs to the owner!");
}
if ($contract['invalid'] != 1) {
$this->error("合同无效，不能转让！");
}
$member = M("MemberBasic")->find($owner_id);
$service = \Service\CService::factory("Financial");
// $model =M("BrandConfig");
// $config = $model->where(array("brand_id"=>get_brand_id()))->find();
$fee = D("Goods")->getZhuanrangFee();
$bill_project = $service->getBillProject("0,3,4,5", $contract_id);
$bill_project['member_id'] = $new_id;
$bill_project['type'] = 3;
unset($bill_project['id']);
M("BillProject")->data($bill_project)->add();
$contract['member_id'] = $new_id;
$contract_number = date("YmdHis") . rand(0, 10000);
$contract['contract_number'] = $contract_number;
$contract['free_trans'] = $contract['free_trans'] > 1 ? $contract['free_trans'] - 1 : 0;
unset($contract['id']);
M("Contract")->data($contract)->add();
if ($contract['free_trans'] == 0) {
$config = $model->where(array("brand_id" => get_brand_id()))->find();
$extra_bill_id = $service->addBillProject(13, 0, $contract_id, $current_contract['member_id'], $config['member_upgrade_price'], 0, get_brand_id(), is_user_login(), get_club_id(), $mc_id, I("description"));
if (!$extra_bill_id) {
$model->delete($contract_id);
M("BillProject")->delete($bill_id);
M("PayHistory")->delete($ret);
$this->error($service->getError());
}
}
M("BillProject")->data($bill_project)->save();
if (!empty($new_card_number)) {
$newCard = $cardModel->where(array("card_number" => $new_card_number, "brand_id" => get_brand_id()))->find();
if (!empty($newCard)) {
if ($newCard['member_id'] != $new_id) {
$this->error("此卡号已存在，请重新输入");
} else {
$new_card_id = $newCard['id'];
}
} else {
//create a card with card_number
$card = array("sale_club" => get_club_id(), "is_active" => $is_active, "brand_id" => get_brand_id(), "card_number" => $new_card_number, "member_id" => $new_id, "update_time" => getDbTime());
$new_card_id = $cardModel->data($card)->add();
}
} else {
$card = array("is_active" => $is_active, "brand_id" => get_brand_id(), "card_number" => '', "member_id" => $new_id, "update_time" => getDbTime());
$new_card_id = $cardModel->data($card)->add();
$cardModel->where(array("id" => $new_card_id))->setField("card_number", $new_card_id);
}
//change the contract
$contract['member_id'] = $new_id;
$contract['card_id'] = $new_card_id;
$contract['status'] = 4;
$contractModel->data($contract)->save();
M("ContractHistory")->data(array("contract_id" => $contract_id, "extension" => json_encode(I("post."))))->add();
$reason = "合同转让";
if (!empty($reason)) {
$data = array("original_extension" => json_encode($originalcontract), "extension" => json_encode($contract), "reason" => $reason, "record_id" => is_user_login(), "club_id" => get_club_id(), "brand_id" => get_brand_id(), "type" => 0, "status" => 0);
M("Review")->data($data)->add();
}
M("MemberBasic")->where("id={$new_id}")->setField(array("is_member" => 1, "join_time" => getDbTime()));
$this->success("转卡成功！", U("Cashier/Contract/index"));
}
public function docheckAction($id)
{
M("McFollowUp")->where("id={$id}")->setField(array("is_come" => 1, "come_time" => getDbTime()));
$this->success("到场记录成功！");
}
public function importMemberAction()
{
setlocale(LC_ALL, 'en_US.UTF-8');
set_time_limit(0);
$club_id = get_club_id();
$this->clean($club_id);
$brand_id = get_brand_id();
$upload = new \Think\Upload();
// 实例化上传类
// $upload->maxSize = 3145728 ;// 设置附件上传大小
$upload->exts = array('csv');
// 设置附件上传类型
$upload->rootPath = './Public/uploads/';
// 设置附件上传根目录
$upload->savePath = "import/";
$upload->autoSub = false;
$upload->replace = false;
$upload->saveName = $brand_id . "_" . time();
$info = $upload->uploadOne($_FILES['users']);
if (!$info) {
$this->error($upload->getError());
} else {
$file = './Public/uploads/' . $info['savepath'] . $info['savename'];
// $this->checkFile($file);
$handle = fopen($file, 'r');
if ($handle) {
$count = 0;
$arr = array();
$users = fgetcsv($handle);
while ($users = fgetcsv($handle)) {
try {
$count++;
$data = array();
$data['name'] = $users[0];
$data['phone'] = $users[1];
if (empty($data['phone'])) {
$data['phone'] = time();
}
$mc_id = trim($users[14]);
if (empty($mc_id)) {
$mc_id = 0;
$users[14] = 0;
} else {
if (!is_numeric($mc_id)) {
$mcs = M("UserExtension")->where(array("name_cn" => $mc_id))->select();
$mc = null;
foreach ($mcs as $key => $value) {
$m = M("User")->find($value['id']);
if ($m['club_id'] == get_club_id()) {
$mc = $m;
}
}
if (empty($mc)) {
$mc_id = M("User")->data(array("username" => "xj" . $users[14], "password" => md5('111111'), "club_id" => get_club_id(), "brand_id" => get_brand_id()))->add();
M("UserExtension")->data(array("work_status" => 0, "id" => $mc_id, "name_cn" => $users[14], "name_en" => $users[14]))->add();
M("AuthGroupAccess")->data(array("uid" => $mc_id, "group_id" => 6))->add();
$users[14] = $mc_id;
} else {
$users[14] = $mc['id'];
}
}
}
$m = M("MemberBasic")->where(array("club_id" => get_club_id(), "name" => trim($users[0]), "phone" => trim($users[1])))->find();
if (!empty($m)) {
$uid = $m['id'];
} else {
$model = D("MemberBasic");
$data['sex'] = $users[2];
$data['type'] = 1;
$data['email'] = $users[3];
$data['birthday'] = $users[4];
$data['home_phone'] = $users[5];
$data['home_addr'] = $users[6];
$data['country'] = $users[7];
$data['nation'] = $users[8];
$data['job'] = $users[9];
$data['desc'] = $users[10];
$data['brand_id'] = get_brand_id();
$data['club_id'] = get_club_id();
$data['in_pool'] = 0;
$data['is_member'] = 1;
$data['join_time'] = trim($users[24]);
if (empty($data['join_time'])) {
$data['join_time'] = $users[15];
}
$data['mc_id'] = trim($users[14]);
$data['certificate_number'] = trim($users[23]);
if (!$model->create($data)) {
$this->clean($club_id);
$this->error("{$count}行数据有误--" . $model->getError());
}
$uid = $model->data($data)->add();
}
$card_type = "湘江世纪城——" . trim($users[11]);
$pattern = array('/一/', '/二/', '/三/', '/四/', '/五/', '/六/', '/七/', '/八/', '/九/', '/十/');
$replace = array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10");
$card_type = preg_replace($pattern, $replace, $card_type);
$cardTypeModel = M("CardType");
$cardType = $cardTypeModel->where(array("name" => $card_type))->find();
//添加卡种
if ($users[12] == 0) {
$valid_number = 0;
if (preg_match('/[1|一]年卡/u', $card_type)) {
$valid_time = 12;
} else {
if (preg_match('/[2|二|两]年卡/u', $card_type)) {
$valid_time = 24;
} else {
if (preg_match('/[3|三]年卡/u', $card_type)) {
$valid_time = 36;
} else {
if (preg_match('/半年(.*)卡/u', $card_type)) {
$valid_time = 6;
} else {
if (preg_match('/季(度)?卡/u', $card_type)) {
$valid_time = 3;
} else {
if (preg_match('/(\\d+)(个)?月卡/i', $card_type, $matches)) {
$valid_time = $matches[1];
} else {
$valid_time = 12;
}
}
}
}
}
}
} else {
if (preg_match('/\\d+/i', $card_type, $matches)) {
$valid_number = $matches[0];
} else {
$this->clean($club_id);
$this->error("{$count}行次不明！");
}
$valid_time = 12;
}
if (empty($cardType)) {
$data = array("name" => $card_type, "category" => 1, "type" => 1 + $users[12], "valid_time" => $valid_time, "brand_id" => get_brand_id(), "start_time" => "2015-01-01", "end_time" => "2019-01-01", "price" => $users[18], "valid_number" => $valid_number, "sold_num" => 999999, "min_price" => $users[18] - 500);
$cardtypeid = M("CardType")->data($data)->add();
M("CardSaleclub")->data(array("card_type_id" => $cardtypeid, "club_id" => get_club_id()))->add();
M("CardUseclub")->data(array("card_type_id" => $cardtypeid, "club_id" => get_club_id()))->add();
} else {
$cardtypeid = $cardType['id'];
}
$card_type_id = $cardtypeid;
$mc_id = trim($users[12]);
$start_time = trim($users[15]);
$end_time = trim($users[16]);
$card_number = trim($users[17]);
$cardModel = D("Card");
$cardTypeModel = M("CardType");
$cardType = $cardTypeModel->find($card_type_id);
if (empty($cardType)) {
$this->clean($club_id);
$this->error("{$count}行卡种不存在!");
}
if (empty($card_number)) {
$card_number = date("YmdHis") . rand(0, 10000);
$card = array("free_rest" => 0, "sale_club" => get_club_id(), "is_active" => 0, "brand_id" => get_brand_id(), "card_number" => $card_number, "member_id" => $uid);
$card['update_time'] = getDbTime();
$card_id = $cardModel->data($card)->add();
$max_card = M("Card")->where(array("sale_club" => get_club_id(), "is_auto_create" => 1))->order("card_number desc")->find();
if (empty($max_card)) {
$card_number = get_club_id() . "00001";
} else {
$card_number = $max_card['card_number'] + 1;
}
$card_number = preg_replace("/4/", "5", $card_number);
while (true) {
if ($cardModel->isExist($card_number, get_brand_id())) {
$card_number += 1;
$card_number = preg_replace("/4/", "5", $card_number);
} else {
break;
}
}
$cardModel->where("id={$card_id}")->setField(array("card_number" => $card_number, "is_auto_create" => "1"));
} else {
$card = array("free_rest" => 0, "sale_club" => get_club_id(), "is_active" => 0, "brand_id" => get_brand_id(), "card_number" => $card_number, "member_id" => $uid);
$card_id = $cardModel->data($card)->add();
}
if (!$card_id) {
$this->error("{$count}行开卡失败，请稍后再试!");
$this->clean($club_id);
}
$model = D("Contract");
$payed = trim($users[19]);
$contract_number = date("YmdHis") . rand(0, 10000);
$data = array("total_num" => $valid_number, "member_id" => $uid, "start_time" => $start_time, "end_time" => $end_time, "brand_id" => get_brand_id(), "card_type_id" => $card_type_id, "type" => 0, "description" => $users[22], "price" => $payed, "sale_club_id" => get_club_id(), "card_id" => $card_id, "payed" => $payed, "contract_number" => $contract_number, "mc_id" => trim($users[14]), "card_type_extension" => json_encode($cardType), "active_type" => 2);
$contract_id = $model->data($data)->add();
$service = \Service\CService::factory("Financial");
$bill_id = $service->addBillProject(0, 0, $contract_id, $uid, $payed, 0, get_brand_id(), is_user_login(), get_club_id(), trim($users[14]), $users[22]);
if (!$bill_id) {
$this->clean($club_id);
$this->error("{$count}行数据有误--" . $service->getError());
}
$ret = $service->pay($bill_id, 0, is_user_login(), get_brand_id(), $users[22], $payed, 0, 0, 0, get_club_id(), 0, 0, 0);
if (!$ret) {
$this->clean($club_id);
$this->error("{$count}行数据有误--" . $service->getError());
}
} catch (Exception $e) {
$this->clean($club_id);
$this->error($e->getMessage());
}
}
} else {
$this->clean($club_id);
$this->error("error!");
}
}
$this->success("Success!");
}
public function buyAction()
{
$member_id = I("member_id");
$member = M("MemberBasic")->find(I("member_id"));
if (empty($member)) {
$this->error("member does not exist");
}
$class_id = I("class_id");
$class = M("PtClass")->find($class_id);
if (empty($class)) {
$this->error("class is not exist!");
}
$use_recharge = I("use_recharge");
$model = D("PtContract");
if (!$model->create()) {
$this->error($model->getError());
}
$rules = array(array('pos', 'number', '请输入正确的pos金额!', 1), array('cash', 'number', '请输入正确的现金金额!', 1), array('check', 'number', '请输入正确的支票金额!', 1), array('network', 'number', '请输入正确的网络支付金额!', 1), array('netbank', 'number', '请输入正确的网银分期金额!', 1));
// $cashHistoryModel=M("CashHistory");
// if (!$cashHistoryModel->validate($rules)->create()){
// $this->error($cashHistoryModel->getError());
// }
$paid = I("cash") + I("pos") + I("check") + I("network") + I("netbank");
$book_price = 0;
$price = I("should_pay");
if ($member['pt_book_price'] != 0) {
$book_price = $price - $paid > $member['pt_book_price'] ? $member['pt_book_price'] : $price - $paid;
$paid += $book_price;
}
$recharge = 0;
$should_pay = $price - $paid;
if ($use_recharge == 1) {
$recharge = $member['recharge'] > $should_pay ? $should_pay : $member['recharge'];
}
$paid += $recharge;
$model->paid = $paid;
$contract_number = date("YmdHis") . rand(0, 10000);
$model->contract_number = $contract_number;
$model->pt_id = $member['pt_id'];
$pt_id = I("pt_id");
if (!empty($pt_id)) {
$model->pt_id = $pt_id;
}
$start_time = I("start_time");
$end_time = I("end_time");
if (empty($start_time)) {
$start_time = date('Y-m-d');
}
if (empty($end_time)) {
$end_time = date('Y-m-d', strtotime("+2 years"));
}
$model->start_time = $start_time;
$model->end_time = $end_time;
$contract_id = $model->add();
if (empty($contract_id)) {
$this->error("Error!请检查参数的正确性");
}
if ($use_recharge == 1 && $recharge != 0) {
M("MemberBasic")->where(array("id" => $member_id))->setField("recharge", $member['recharge'] - $recharge);
$data = array("member_id" => $member_id, "value" => "-{$recharge}", "record_id" => is_user_login(), "description" => "购PT消费￥{$recharge},余额￥" . ($member['recharge'] - $recharge));
$recharge_id = M("RechargeHistory")->data($data)->add();
}
$service = \Service\CService::factory("Financial");
$bill_id = $service->addBillProject(1, 0, $contract_id, $member_id, I("should_pay"), 0, get_brand_id(), is_user_login(), get_club_id(), $member['pt_id'], I("description"));
if (!$bill_id) {
$model->delete($contract_id);
M("MemberBasic")->where(array("id" => $member_id))->setField("recharge", $member['recharge'] + $recharge);
if (isset($recharge_id)) {
M("RechargeHistory")->delete($recharge_id);
}
$this->error($service->getError());
}
$ret = $service->pay($bill_id, 0, is_user_login(), get_brand_id(), I('description'), I("cash"), I("pos"), I("check"), I("check_num"), get_club_id(), $recharge, I("network"), I("netbank"));
if (!$ret) {
$model->delete($contract_id);
M("MemberBasic")->where(array("id" => $member_id))->setField("recharge", $member['recharge'] + $recharge);
if (isset($recharge_id)) {
M("RechargeHistory")->delete($recharge_id);
}
M("BillProject")->delete($bill_id);
$this->error($service->getError());
}
if ($book_price != 0) {
M("MemberBasic")->where(array("id" => $member_id))->setDec("pt_book_price", $book_price);
$bill_project = M("BillProject")->where(array("member_id" => $member_id, "type" => 8, "object_id" => 0))->select();
$i = $book_price;
foreach ($bill_project as $key => $value) {
$i -= $value['paid'];
M("BillProject")->where("id=" . $value['id'])->setField(array("object_id" => $contract_id));
if ($i <= 0) {
break;
}
}
M("BillProject")->where("id={$bill_id}")->setInc("paid", $book_price);
}
// $cashHistoryModel->data(array("type"=>1,"sub_type"=>0,"recharge"=>$recharge,"cash"=>I("cash"),"check"=>I("check"),"pos"=> I("pos"),"object_id"=>$contract_id,"price"=>I("should_pay"),"record_id"=>is_user_login(),"brand_id"=>get_brand_id()))->add();
$reason = "新增PT合同";
if ($class['price'] * I("total_num") > I("should_pay")) {
$reason .= ";收银过低";
}
if (!empty($reason)) {
$contract = M("PtContract")->find($contract_id);
$data = array("extension" => json_encode($contract), "reason" => $reason, "record_id" => is_user_login(), "club_id" => get_club_id(), "brand_id" => get_brand_id(), "type" => 1, "status" => 0);
M("Review")->data($data)->add();
}
$cards = D("Card")->getAllCards($member_id, get_brand_id());
if (empty($cards)) {
$cardModel = D("Card");
$card_number = date("YmdHis") . rand(0, 10000);
$card = array("free_rest" => I("free_rest"), "sale_club" => get_club_id(), "is_active" => 1, "brand_id" => get_brand_id(), "card_number" => $card_number, "member_id" => $member_id);
$card['update_time'] = getDbTime();
$card_id = $cardModel->data($card)->add();
$card_number = get_club_id() . $card_id;
while (true) {
if ($cardModel->isExist($card_number, get_brand_id())) {
$card_number .= rand(0, 100);
} else {
break;
}
}
$cardModel->where("id={$card_id}")->setField("card_number", $card_number);
$this->success("购买成功！相关卡号为：{$card_number} 请前台烧卡！", U("Cashier/Ptcontract/index"));
}
$this->success("购买成功！您的任意会员卡均可进行私教消费！", U("Cashier/Ptcontract/index"));
}
public function weixinblacklistAction()
{
//检查当日没来的，进入黑名单
$model = M("AppointHistory");
$yesterday = date('Y-m-d H:i:s', strtotime("-2 hour"));
$values = $model->field("a.*,b.start as starttime")->table(array("yoga_appoint_history" => "a", "yoga_club_schedule" => "b"))->where("a.is_check=0 and a.come=0 and a.schedule_id=b.id and b.start<='{$yesterday}'")->select();
$month = date('Y-m');
foreach ($values as $key => $value) {
$model->where("id=" . $value['id'])->setField("is_check", 1);
$starttime = $value['starttime'];
$starttime = substr($starttime, 0, 10);
$ct = M("CheckHistory")->where(array("member_id" => $value['member_id'], "create_time" => array("like", $starttime . "%")))->count();
if ($ct > 0) {
M("AppointHistory")->where("id=" . $value['id'])->setField("come", 1);
continue;
}
//本月爽约历史记录次数次数
//$history=M("AppointBlackList")->where(array("member_id"=>$value['member_id'],"create_time"=>array("gt",$month)))->count();
$count = $model->where(array("create_time" => array("gt", $month), "come" => 0, "member_id" => $value['member_id']))->count();
if ($count == 0) {
continue;
}
//爽约原因
$schedule_id = $value['schedule_id'];
$schedule = D("ClubSchedule")->find($schedule_id);
if (!empty($schedule)) {
$class = M("PtClassPublic")->find($schedule['class_id']);
$reason = "缺席" . $schedule['start'] . "的" . $class['name'];
} else {
$reason = "缺席";
}
if ($count == 1) {
$end_time = date('Y-m-d H:i:s', strtotime("+4 day"));
//4天
M("AppointBlackList")->data(array("reason" => $reason, "member_id" => $value['member_id'], "history_id" => $value['id'], "create_time" => getDbTime(), "start_time" => getDbTime(), "end_time" => $end_time))->add();
} else {
if ($count == 2) {
//2周
$end_time = date('Y-m-d H:i:s', strtotime("+2 week"));
//4天
M("AppointBlackList")->data(array("reason" => $reason, "member_id" => $value['member_id'], "history_id" => $value['id'], "create_time" => getDbTime(), "start_time" => getDbTime(), "end_time" => $end_time))->add();
} else {
//本月
$end_time = date('Y-m-d H:i:s', strtotime(date('Y-m-01') . ' +1 month -1 day'));
//4天
M("AppointBlackList")->data(array("reason" => $reason, "member_id" => $value['member_id'], "history_id" => $value['id'], "create_time" => getDbTime(), "start_time" => getDbTime(), "end_time" => $end_time))->add();
}
}
}
}
public function getGiftAction($uid, $level)
{
$model = M("YaaGift");
for ($i = 1; $i <= $level; $i++) {
$data = array("member_id" => $uid, "level" => $i, 'create_time' => getDbTime());
$exist = $model->where($data)->select();
if (empty($exist)) {
M("YaaGift")->data($data)->add();
}
}
M("YaaMember")->where("member_id={$uid}")->setField(array("gift_status" => 1));
$this->ajaxReturn(array("status" => 1, "info" => "您的申请已经提交，请等待！"));
}
public function dopayback($contract_id, $price, $desc, $user_id)
{
$paybackmodel = M("PayBack");
$ret = $paybackmodel->where(array("contract_id" => $contract_id))->find();
if (empty($ret)) {
$data = array("update_time" => getDbTime(), "contract_id" => $contract_id, "brand_id" => get_brand_id(), "club_id" => get_club_id(), "review_id" => $user_id, "ret" => 1, "pay_back_price" => $price, "description" => $desc, "apply_id" => $user_id);
$paybackmodel->data($data)->add();
} else {
$ret['ret'] = 1;
$ret['pay_back_price'] = $price;
$ret['description'] = $desc;
$ret['review_id'] = $user_id;
$ret['update_time'] = getDbTime();
$paybackmodel->data($ret)->save();
}
M("Contract")->where(array("id" => $contract_id))->setField(array("invalid" => 0, "status" => 7));
$contract = M("Contract")->find($contract_id);
$card_id = $contract['card_id'];
if (M("Contract")->where(array("card_id" => $card_id, "invalid" => 1))->count() == 0) {
$card = M("Card")->find($card_id);
$card['status'] = 4;
M("CardDel")->data($card)->add();
M("Card")->delete($card_id);
}
return true;
}
public function editAction($id, $card_number, $btype, $card_type_id, $present_day, $present_num, $price, $start_time, $end_time, $active_type, $desc, $free_rest, $free_trans, $mc_name)
{
$rules = array(array('id', 'require', '合同ID必须！', 1), array('card_number', 'require', '卡号必须！', 1), array('btype', array(0, 1), '类型不对!', 1, 'in'), array('card_type_id', 'number', '卡类型不对!', 1), array('present_day', 'number', '赠送天数需要为整数!', 1), array('present_num', 'number', '赠送次数需要为整数!', 1), array('price', 'number', '请输入正确的应付价格!', 1), array('active_type', array(0, 1, 2), '请选择开卡方式!', 1, 'in'));
$bill = M("BillProject")->find($id);
$model = D("Contract");
if (!$model->validate($rules)->create()) {
$this->error($model->getError());
}
if ($active_type != 2) {
$rules = array(array('start_time', '/^\\d{4}-\\d{2}-\\d{2}$/', '请选择合同开始日期!', 1), array('end_time', '/^\\d{4}-\\d{2}-\\d{2}$/', '请选择合同结束日期!', 1));
if (!$model->validate($rules)->create()) {
$this->error($model->getError());
}
}
$cardTypeModel = M("CardType");
$cardType = $cardTypeModel->find($card_type_id);
if (empty($cardType)) {
$this->error("卡种不存在!");
}
$model = D("Contract");
$original_contract = $model->find($bill['object_id']);
$member_id = $original_contract['member_id'];
$card_id = $original_contract['card_id'];
$original_extension = json_encode($original_contract);
if (empty($original_contract)) {
$this->error("Error");
}
if ($original_contract['is_review'] == 1 && !is_user_brand()) {
$this->error("此合同已审核，如需修改，请联系管理员！ ");
}
if ($original_contract['is_review'] == 2) {
$this->error("此合同已升级作废，如需修改请联系管理员！ ");
}
$cardModel = D("Card");
if ($card_number != $original_contract['card_number']) {
$c = $cardModel->getCard($card_number, get_brand_id());
if (empty($c)) {
//delete this card is no relate contract
$count = $model->where("card_id=" . $original_contract['card_id'])->count();
if ($count == 1) {
$card = $cardModel->find($original_contract['card_id']);
if (empty($card)) {
$card = array("card_number" => $card_number, "member_id" => $member_id, "brand_id" => get_brand_id());
$card_id = $cardModel->data($card)->add();
} else {
M("Card")->where("id=" . $original_contract['card_id'])->setField(array("card_number" => $card_number, "is_auto_create" => 0));
}
} else {
$card = $cardModel->find($card_id);
unset($card['id']);
$card['create_time'] = getDbTime();
$card['update_time'] = getDbTime();
$card['card_number'] = $card_number;
$card_id = $cardModel->data($card)->add();
}
} else {
if ($c['member_id'] != $member_id) {
$this->error("此卡已被占用！请输入其他卡号！");
}
$card_id = $c['id'];
}
}
if (!$card_id) {
$this->error("开卡失败，请稍后再试!");
}
if (I('active_type') == 2) {
unset($model->start_time);
unset($model->end_time);
}
$new_contract = $original_contract;
$new_contract['card_id'] = $card_id;
$new_contract['type'] = $btype;
if ($original_contract['card_type_id'] != $card_type_id) {
$new_contract['card_type_extension'] = json_encode($cardType);
}
$new_contract['card_type_id'] = $card_type_id;
$new_contract['present_day'] = $present_day;
$new_contract['present_num'] = $present_num;
$new_contract['price'] = $price;
$new_contract['start_time'] = $start_time;
$new_contract['end_time'] = $end_time;
$new_contract['active_type'] = $active_type;
$new_contract['free_rest'] = $free_rest;
$new_contract['free_trans'] = $free_trans;
if ($original_contract['mc_id'] != $mc_name) {
M("MemberBasic")->where("id={$member_id}")->setField(array("mc_id" => $mc_name));
M("BillProject")->where("id={$id}")->setField(array("mc_id" => $mc_name));
}
$new_contract['mc_id'] = $mc_name;
if (!empty($desc)) {
$new_contract['description'] = $desc . ";" . $original_contract['description'];
}
$new_contract['total_num'] = $present_num + $cardType['valid_number'];
$model->data($new_contract)->save();
M("BillProject")->where("id={$id}")->setField(array("price" => $price));
//review
$reason = "合同修改";
if (!empty($reason)) {
$contract = M("Contract")->find($new_contract["id"]);
$data = array("original_extension" => $original_extension, "extension" => json_encode($contract), "reason" => $reason, "record_id" => is_user_login(), "club_id" => get_club_id(), "brand_id" => get_brand_id(), "type" => 0, "status" => 0);
M("Review")->data($data)->add();
}
$this->success("修改成功");
}
<?php
include_once "../common.php";
include_once ROOT_PATH . "/mod/functs.php";
refresh_bot_info();
$date = getDbTime();
if (!$date) {
die("<font class='error'>ERROR</font> : cannot get time");
}
$YEAR = gmdate('Y', $date);
$MONTH = gmdate('m', $date);
$DAY = gmdate('d', $date);
$TIME = gmdate('H:i:s', $date);
echo "<b>{$YEAR}<br>{$MONTH}/{$DAY}<br>{$TIME}</b>";
$sql = 'SELECT COUNT(id_bot) FROM bots_t WHERE status_bot <> \'offline\'';
$res = $db->query($sql);
$cnt = -1;
if (@$res && $db->affected_rows > 0) {
list($cnt) = $res->fetch_array();
}
$sql = 'SELECT COUNT(id_bot) FROM bots_t';
$res = $db->query($sql);
$cnt2 = -1;
if (@$res && $db->affected_rows > 0) {
list($cnt2) = $res->fetch_array();
}
echo "<script>\$('#bot_info').html('<b>{$cnt}<br>{$cnt2}</b>');</script>";
//
private function ptappoint($member_id, $contract_id, $pt_id)
{
$date = date('Y-m-d');
$appoint = M("PtAppoint")->where(array("member_id" => $member_id, "pt_id" => $pt_id, "appoint_date" => $date))->find();
if (empty($appoint)) {
$appoint_id = M("PtAppoint")->date(array("member_id" => $member_id, "pt_id" => $pt_id, "appoint_date" => $date, "create_time" => getDbTime(), "is_appoint" => 0))->add();
} else {
$appoint_id = $appoint['id'];
}
// M("PtAppoint")->where("id=$appoint_id")->setField("is_come"=>1);
}
public function editAction()
{
$channel = I("channel_id");
$model = D("MemberBasic");
$id = I("id");
$member = $model->find($id);
if (empty($member)) {
$this->error("此访客不存在，不能修改！");
}
if (!is_user_brand()) {
$is_reception = D("User")->isReception(is_user_login());
if (!$is_reception && $member["mc_id"] != is_user_login() && $member['record_id'] != is_user_login()) {
$this->error("无权查看此用户信息");
}
} else {
if ($member['brand_id'] != get_brand_id()) {
$this->error("无权查看此用户信息");
}
}
if (!$model->create()) {
$this->error($model->getError());
} else {
$brand_id = get_brand_id();
$club_id = get_club_id();
$condition = array();
$condition['club_id'] = $club_id;
$condition['id'] = array("neq", $id);
$where['phone'] = I("phone");
$certificate_number = I("certificate_number");
if (!empty($certificate_number)) {
$where['certificate_number'] = I("certificate_number");
} else {
$where['1'] = '0';
}
$where['_logic'] = 'or';
$condition['_complex'] = $where;
$member = $model->where($condition)->find();
if (!empty($member)) {
$this->error("此访客信息已存在，不能再添加！");
}
if ($member['type'] != I('type') || $member['pre_sale'] != I('pre_sale')) {
$model->level_update_time = getDbTime();
}
$model->save();
if (!empty($_FILES["avatar"]["name"])) {
$upload = new \Think\Upload();
// 实例化上传类
$upload->maxSize = 31457280;
// 设置附件上传大小
$upload->exts = array('jpg', 'gif', 'png', 'jpeg');
// 设置附件上传类型
$upload->rootPath = './Public/uploads/';
// 设置附件上传根目录
$upload->savePath = "mmb_avatar/";
$upload->autoSub = false;
$upload->replace = true;
$upload->saveName = "{$id}";
$info = $upload->upload();
if (!$info) {
$this->error($upload->getError());
} else {
$avatar = $info["avatar"]['savename'];
$model->where("id={$id}")->setField("avatar", $avatar);
}
}
}
$this->success('成功！', Cookie('__forward__'));
// $this->success('成功！', $this->getAddRedirectUrl($member['is_member']),1);
}
public function freeLocks()
{
$ids = I("ids");
$club_id = I("club_id");
$model = M("Lock");
$model->where(array("club_id" => $club_id, "id" => array("in", $ids)))->setField(array("is_use" => 0));
foreach ($ids as $key => $value) {
M("LockUseHistory")->data(array("card_id" => "0", "lock_id" => $value, "status" => 0, "via" => 1, "create_time" => getDbTime()))->add;
\Think\Log::write("free lock by manual " . $value, 'DEBUG');
}
$this->ajaxReturn(array("state" => 1, "data" => "释放锁！"));
}
