function index() { $list = $this->dao->where("shipping_id=" . $_GET["id"])->findall(); foreach ($list as $k => $v) { $config = unserialize($v['config']); foreach ((array) $config as $vo) { $list[$k]['area'][] = get_region_name($vo); } $list[$k]['area'] = implode(',', $list[$k]['area']); } $this->list = $list; $this->id = $_GET["id"]; $this->display(); }
public function index() { import("Library.Page"); $sch_id = session('sch_id'); $db = M('wechat_user'); $shop = M('shop')->where(array('sch_id' => array('in', $sch_id), 'status' => 1))->select(); $userArr = array(); foreach ($shop as $key => $val) { $userArr[] = $val['uid']; } $_userId = implode(",", $userArr); $map['id'] = array('in', $_userId); $so_key = I('get.key'); if ($so_key) { $where['nickname'] = array('like', '%' . $so_key . '%'); $where['shop_name'] = array('like', '%' . $so_key . '%'); $where['name'] = array('like', '%' . $so_key . '%'); $where['_logic'] = 'or'; $map['_complex'] = $where; } //角色为店长 $map['role_id'] = 2; $count = $db->where($map)->count(); $Page = new \Page($count, 10); $show = $Page->show(); $this->assign('show', $show); $list = $db->where($map)->order('id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($list as $key => $val) { $shop = M('shop')->where(array('uid' => $val['id']))->find(); $shop['prov'] = get_region_name($shop['prov_id']); $shop['city'] = get_region_name($shop['city_id']); $shop['town'] = get_region_name($shop['county_id']); $shop['school'] = M('school')->where(array('id' => $shop['sch_id']))->getField('name'); $shop['build'] = M('building')->where(array('id' => $shop['build_id']))->getField('name'); $list[$key]['shop'] = $shop; $list[$key]['shop_id'] = $shop['id']; } $this->assign('list', $list); $this->display(); }
function item_region_box($region_txt, $region_select_txt) { $aRegions = osc_get_regions(); $item = osc_item() != null ? osc_item() : array(); switch (count($aRegions)) { case 0: // 0 regions ?> <div class="clearfix"> <label><?php echo $region_txt; ?> </label> <div class="input"> <input class="region_name" id="region_name" type="text" name="region" value="<?php echo get_region_name($item); ?> " /> </div> </div> <?php break; case 1: // only one region ?> <input class="region_id" id="region_id" type="hidden" name="regionId" value="<?php echo get_region_id($item); ?> " /> <?php break; default: // more than one region ?> <div class="clearfix"> <label><?php echo $region_txt; ?> </label> <div class="input"> <select class="region_id" id="region_id" name="regionId"> <option value=""><?php echo $region_select_txt; ?> </option> <?php foreach ($aRegions as $region) { ?> <option value="<?php echo $region['pk_i_id']; ?> "><?php echo $region['s_name']; ?> </option> <?php } ?> </select> </div> </div> <?php break; } }
function get_region_link($regionid) { global $_WEB_URL; $url = $_WEB_URL . "/show.php?regionid=" . $regionid; return "<a href='{$url}'>" . get_region_name($regionid) . "</a>"; }
public function address_list () { checkLogin(); include_once(RPC_ROOT . 'includes/lib_transaction_ec.php'); include_once('includes/lib_transaction.php'); $user_id = intval($_SESSION['user_id']); $consignee_list = get_consignee_list($user_id); $address_list = array(); //取得国家列表,如果有收货人列表,取得省市区列表 foreach ($consignee_list AS $key => $consignee) { $address_id = $consignee['address_id']; $consignee['country'] = isset($consignee['country']) ? intval($consignee['country']) : 0; $consignee['province'] = isset($consignee['province']) ? intval($consignee['province']) : 0; $consignee['city'] = isset($consignee['city']) ? intval($consignee['city']) : 0; $consignee['district'] = isset($consignee['district']) ? intval($consignee['district']) : 0; $country = get_region_name($consignee['country']); $province = get_region_name($consignee['province']); $city = get_region_name($consignee['city']); $district = get_region_name($consignee['district']); $address_list[$address_id]['address'] = $country.'-'.$province.'-'.$city.'-'.$district.'-'.$consignee['address']; $address_list[$address_id]['mobile'] = $consignee['mobile']; //$address_list[$address_id]['username'] = $_SESSION['user_name']; $address_list[$address_id]['username'] = $consignee['consignee']; } //print_r($address_list);exit; jsonExit($address_list); }
/** * 获得商圈列表 * @param int city 市id * @param int county 县id * @param string keyword 查询关键字 * @return array */ function get_district_list() { /* 查询条件 */ $filter['city'] = intval($_REQUEST['city']); $filter['county'] = intval($_REQUEST['county']); $filter['keyword'] = trim($_REQUEST['keyword']); if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) { $filter['keyword'] = json_str_iconv($filter['keyword']); } $filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'district_id' : trim($_REQUEST['sort_by']); $filter['sort'] = empty($_REQUEST['sort']) ? 'DESC' : trim($_REQUEST['sort']); $where = !empty($filter['city']) ? " AND city = '" . $filter['city'] . "' " : ''; $where .= !empty($filter['keyword']) ? " AND district_name like '%" . $filter['keyword'] . "%' " : ''; $where .= $filter['county'] != '' ? " AND county = '" . $filter['county'] . "' " : ''; $sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('virtual_goods_district') . " WHERE 1 {$where}"; $filter['record_count'] = $GLOBALS['db']->getOne($sql); /* 分页大小 */ $filter = page_and_size($filter); $start = ($filter['page'] - 1) * $filter['page_size']; /* 查询 */ $sql = "SELECT *" . " FROM " . $GLOBALS['ecs']->table('virtual_goods_district') . " WHERE 1 " . $where . " ORDER BY {$filter['sort_by']} {$filter['sort']} " . " LIMIT {$start}, {$filter['page_size']}"; $all = $GLOBALS['db']->getAll($sql); foreach ($all as $k => $v) { $all[$k]['area_name'] = get_region_name($v['province']) . '-' . get_region_name($v['city']) . '-' . get_region_name($v['county']); } return array('item' => $all, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']); }
function store_area_list($parent_id) { $area_arr = array(); $sql = 'SELECT * FROM ' . $GLOBALS['ecs']->table('store_shipping_region') . " WHERE store_id = '{$parent_id}' ORDER BY rec_id desc "; $res = $GLOBALS['db']->query($sql); while ($row = $GLOBALS['db']->fetchRow($res)) { $row['area_name'] = get_region_name($row['province']) . get_region_name($row['city']) . get_region_name($row['district']) . get_region_name($row['xiangcun']); $area_arr[] = $row; } return $area_arr; }
/** *提交获奖感言 */ function submitmyspeech($cmt, $user_id) { require_once ROOT_PATH . 'includes/lib_order.php'; $id = $cmt->id; $speech = $cmt->speech; $address = $cmt->address; $tel = $cmt->tel; $name = $cmt->name; $province = $cmt->province; $city = $cmt->city; $district = $cmt->district; $email = $cmt->email; $goods_id = $cmt->goods_id; //下订单 $order_sn = get_order_sn(); $shipping_id = 8; $shipping_name = "圆通快递"; $shipping_fee = 0.0; $order_amount = $shipping_fee; $pay_id = 1; $pay_name = "余额支付"; $sql = 'INSERT INTO ' . $GLOBALS['ecs']->table('order_info') . ' (`order_sn`, `user_id`,`consignee`, `country`, `province`,`city`, `district`, `address`, ' . '`tel`, `email`,`shipping_id`, `shipping_name`,`pay_id`, `pay_name`, `how_oos`, `goods_amount`,' . ' `shipping_fee`,`order_amount`,`referer`, `add_time`) VALUES ("' . $order_sn . '",' . $user_id . ',"' . $name . '",1,' . $province . ',' . $city . ',' . $district . ',"' . $address . '","' . $tel . '","' . $email . '",' . $shipping_id . ',"' . $shipping_name . '",' . $pay_id . ',"' . $pay_name . '","等待所有商品备齐后再发",0.00,' . $shipping_fee . ',' . $order_amount . ',"本站",' . gmtime() . ')'; $GLOBALS['db']->query($sql); $sql = 'select max(order_id) from ' . $GLOBALS['ecs']->table('order_info'); $order_id = $GLOBALS['db']->getOne($sql); $sql = 'select * from ' . $GLOBALS['ecs']->table('goods') . ' where goods_id = ' . $goods_id; $goods = $GLOBALS['db']->getRow($sql); //获奖商品信息 $sql = 'INSERT INTO ' . $GLOBALS['ecs']->table('order_goods') . ' (`order_id`, `goods_id`, `goods_name`, `goods_sn`, `market_price`, `goods_price`, `is_real`) VALUES (' . $order_id . ',' . $goods_id . ',"' . $goods['goods_name'] . '(抽奖获奖品)","' . $goods['goods_sn'] . '",' . $goods['market_price'] . ',0.00,1)'; $GLOBALS['db']->query($sql); $province = get_region_name($province); $city = get_region_name($city); $district = get_region_name($district); $address = $name . ',' . $address . ',' . $email; $address1 = $province . $city . $district; //修改获奖状态为已申请 $sql = "update " . $GLOBALS['ecs']->table('lottery_user') . " set speech='{$speech}', address1='{$address1}',address='{$address}', tel='{$tel}' ,order_id = '{$order_id}',gettime='" . gmtime() . "',ip = '" . real_ip() . "',applystatus=1 where id='{$id}' and user_id='{$user_id}'"; $GLOBALS['db']->query($sql); return "1"; }
include_once('includes/lib_transaction.php'); $user_id = intval($_SESSION['user_id']); $consignee_list = get_consignee_list($user_id); $address_list = array(); //取得国家列表,如果有收货人列表,取得省市区列表 foreach ($consignee_list AS $key => $consignee) { $address_id = $consignee['address_id']; $consignee['country'] = isset($consignee['country']) ? intval($consignee['country']) : 0; $consignee['province'] = isset($consignee['province']) ? intval($consignee['province']) : 0; $consignee['city'] = isset($consignee['city']) ? intval($consignee['city']) : 0; $consignee['district'] = isset($consignee['district']) ? intval($consignee['district']) : 0; $country = get_region_name($consignee['country']); $province = get_region_name($consignee['province']); $city = get_region_name($consignee['city']); $district = get_region_name($consignee['district']); $address_list[$address_id]['address'] = $country.'-'.$province.'-'.$city.'-'.$district.'-'.$consignee['address']; $address_list[$address_id]['mobile'] = $consignee['mobile']; //$address_list[$address_id]['username'] = $_SESSION['user_name']; $address_list[$address_id]['username'] = $consignee['consignee']; } //print_r($address_list);exit; jsonExit($address_list); }else if($act == 'update_user_default_address')//修改默认收获地址 { checkLogin(); $user_id = intval($_SESSION['user_id']); $address_id = isset($_GET['address_id']) ? intval($_GET['address_id']) : 0; if(empty($address_id)) { $msg = rpcLang('user.php', 'address_id_is_empty');
public function checkout() { $cart_model = D("Cart"); if ($cart_model->get_item_count($this->sessionID) < 1) { $this->jumpUrl = U('Index/index'); $this->error("Your shopping cart does not have any products!"); } if ($this->memberID <= 0 && GetSettValue('quickbuy') == 0 && !$_SESSION['guest']) { Session::set('back', U('Cart/checked_payment')); $this->redirect('Member-Public/Login'); } if (!isset($_POST['shipping_id']) || empty($_POST['shipping_id'])) { $this->error('Please select SHIPPING METHOD! '); } if (!isset($_POST['payment_module_code']) || empty($_POST['payment_module_code'])) { $this->error('Please select PAYMENT METHOD! '); } if (!empty($_POST['coupon'])) { $dao = D("Coupon"); $coupon = $dao->validate($_POST['coupon']); if ($coupon) { } else { $this->error('The coupon is invalid! '); } } $orders_model = D("Orders"); $shipping_model = D("Shipping"); $shippingaddress_model = D("Shippingaddress"); $payment_model = D('Payment'); if ($delivery_list = $orders_model->create()) { $delivery = $_POST['delivery']; //0会员本身地址,1其它地址 if ($delivery == 0) { $member_model = D('Members'); $delivery_list['member_id'] = $this->memberID; $this->member_info = $member_info = $member_model->find($this->memberID); $delivery_list['delivery_email'] = $member_info['email']; $delivery_list['delivery_firstname'] = $member_info['firstname']; $delivery_list['delivery_lastname'] = $member_info['lastname']; $member_info = $shippingaddress_model->get_shippingaddress($this->memberID); $delivery_list['delivery_address'] = $member_info['address']; $delivery_list['delivery_country'] = $member_info['country']; $delivery_list['delivery_state'] = $member_info['state']; $delivery_list['delivery_city'] = $member_info['city']; $delivery_list['delivery_zip'] = $member_info['zip']; $delivery_list['delivery_telephone'] = $member_info['telphone']; } $delivery_list['total_weight'] = $cart_model->cart_total_weight($this->sessionID); $delivery_list['shippingmoney'] = $shipping_model->get_shipping_fee($delivery_list["shipping_id"], $delivery_list['delivery_country'], $delivery_list['delivery_state'], $delivery_list['delivery_city'], $delivery_list['total_weight']); $delivery_list['shippingmoney'] = $delivery_list['shippingmoney']['price']; //没有价格取保险金 !$delivery_list['shippingmoney'] ? $delivery_list['shippingmoney'] = $shipping_model->get_insure($delivery_list["shipping_id"]) : ''; $delivery_list['shipping_method'] = $delivery_list['shipping_module_code'] = $shipping_model->get_name($delivery_list["shipping_id"]); $products_total = $cart_model->cart_total($this->sessionID); //产品总价格 $discount = $cart_model->discount($products_total); //打折信息 $sum_total = round($discount['price'], 2); //打折后价格 $delivery_list['discount'] = $discount['text']; $itemTotal = $cart_model->get_item_totalcount($this->sessionID); //总数量 $payment_id = $payment_model->get_id($delivery_list["payment_module_code"]); $fee = get_orders_Fees($sum_total, $itemTotal, $payment_id); //最小订单金额 if ($fee['minimum_money'] && $fee["total"] <= $fee['minimum_money']) { $this->error("Not be less than " . $fee['minimum_money'] . " minimum!"); } $delivery_list['paymoney'] = $fee["paymoney"]; $delivery_list['insurance'] = $fee["insurance"]; $delivery_list['orders_total'] = $fee['total'] + $delivery_list['shippingmoney']; //总价加上运费 $delivery_list['products_total'] = $fee['products_total']; //判断手动和选择 $delivery_list['delivery_country'] = is_numeric($delivery_list['delivery_country']) ? get_region_name($delivery_list['delivery_country']) : $delivery_list['delivery_country']; $delivery_list['delivery_state'] = is_numeric($delivery_list['delivery_state']) ? get_region_name($delivery_list['delivery_state']) : $delivery_list['delivery_state']; $delivery_list['delivery_city'] = is_numeric($delivery_list['delivery_city']) ? get_region_name($delivery_list['delivery_city']) : $delivery_list['delivery_city']; //货币符号 $delivery_list['currencies_code'] = $_SESSION['currency']['code'] ? $_SESSION['currency']['code'] : "\$"; //如果使用了优惠券 if ($coupon) { $delivery_list['orders_total'] -= $coupon['amount']; $delivery_list['coupon'] = $coupon['amount']; //记录优惠了多少价格 } //生成订单 $orders_model->create($delivery_list); //过滤 if ($orders_id = $orders_model->add()) { //保存优惠券使用者 $dao = D("Coupon"); $dao->where(array('coupon' => $_POST['coupon']))->save(array('user' => $delivery_list['delivery_lastname'] . ' ' . $delivery_list['delivery_firstname'], 'status' => 0)); //处理orders_products表 $list = $cart_model->display_contents($this->sessionID); $orders_products_model = D("Orders_products"); for ($row = 0; $count = count($list), $row < $count; $row++) { $data['orders_id'] = $orders_id; $data['products_model'] = serialize($list[$row]['model']); $data['products_id'] = $list[$row]['pid']; $data['products_name'] = $list[$row]['name']; $data['products_price'] = $list[$row]['price']; $data['products_pricespe'] = $list[$row]['pricespe']; $data['products_quantity'] = $list[$row]['count']; $data['products_total'] = $list[$row]['total']; if ($orders_products_model->create($data)) { $orders_products_model->add(); } } //清除购物车 $cart_model->clear_cart($this->sessionID); //发送邮件 //邮件变量 $this->itemTotal = $itemTotal; //总数量 $this->totalWeight = $delivery_list['total_weight']; //总重量 $this->orders_data = $delivery_list; //订单数据 $this->list = $list; //购物车产品 $this->cartTotal = getprice_str($products_total); //产品总价格 $fee['insurance'] > 0 && $this->assign('insurance', getprice_str($fee['insurance'])); $fee['paymoney'] > 0 && $this->assign('paymoney', getprice_str($fee['paymoney'])); $this->discount = $discount; //打折 $this->shippingPrice = getprice_str($delivery_list['shippingmoney']); //运费 $this->totalAmount = getprice_str($delivery_list['orders_total']); //全部总价 $this->this_script = "http://" . $_SERVER['HTTP_HOST']; $sendto = array($delivery_list['delivery_email'], GetSettValue('mailcopyTo')); //抄送 $body = $this->fetch("MailTpl:checkout"); sendmail($sendto, GetSettValue('sitename') . " - new order(SN:" . $orders_model->sn . ")!", $body); $this->redirect('Cart/payment', array('id' => $orders_id)); } else { $this->error($orders_model->getError()); } } else { $this->error(self::$Model->getError()); } }
/** * This function will notify the regional education office of updates / deletes to affected apartment events. * * @param string $action * @param int $event_id * @return bool $success */ function notify_regional_education($action, $event_id) { global $db, $AGENT_CONTACTS, $event_info, $ENTRADA_USER; $query = "\tSELECT * FROM `" . CLERKSHIP_DATABASE . "`.`events` AS a\n\t\t\t\tLEFT JOIN `" . CLERKSHIP_DATABASE . "`.`regions` AS b\n\t\t\t\tON a.`region_id` = b.`region_id`\n\t\t\t\tLEFT JOIN `" . CLERKSHIP_DATABASE . "`.`event_contacts` AS c\n\t\t\t\tON a.`event_id` = c.`event_id`\n\t\t\t\tWHERE a.`event_id` = " . $db->qstr($event_id); $result = $db->GetRow($query); if ($result) { /** * Don't process this if the event has already ended as there's not need for notifications. */ if ($result["event_finish"] > time()) { $whole_name = get_account_data("firstlast", $result["etype_id"]); $query = "\tSELECT a.`inhabiting_start`, a.`inhabiting_finish`, b.`apartment_title`\n\t\t\t\t\t\t\t\tFROM `" . CLERKSHIP_DATABASE . "`.`apartment_schedule` AS a\n\t\t\t\t\t\t\t\tLEFT JOIN `" . CLERKSHIP_DATABASE . "`.`apartments` AS b\n\t\t\t\t\t\t\t\tON b.`apartment_id` = a.`apartment_id`\n\t\t\t\t\t\t\t\tWHERE a.`event_id` = " . $db->qstr($event_id); $apartments = $db->GetAll($query); if ($apartments) { switch ($action) { case "deleted": $message = "Attention " . $AGENT_CONTACTS["agent-regionaled"]["name"] . ",\n\n"; $message .= $_SESSION["details"]["firstname"] . " " . $_SESSION["details"]["lastname"] . " has removed an event from " . $whole_name . "'s "; $message .= "clerkship schedule, to which you had previously assigned housing. Due to the removal of this event from the system, "; $message .= "the housing associated with it has also been removed.\n\n"; $message .= "Information For Reference:\n\n"; $message .= "Event Information:\n"; $message .= "Event Title:\t" . html_decode($result["event_title"]) . "\n"; $message .= "Region:\t\t" . $result["region_name"] . "\n"; $message .= "Start Date:\t" . date(DEFAULT_DATE_FORMAT, $result["event_start"]) . "\n"; $message .= "Finish Date:\t" . date(DEFAULT_DATE_FORMAT, $result["event_finish"]) . "\n\n"; if ($apartments && ($assigned_apartments = @count($apartments))) { $message .= "Apartment" . ($assigned_apartments != 1 ? "s" : "") . " " . $whole_name . " was removed from:\n"; foreach ($apartments as $apartment) { $message .= "Apartment Title:\t" . $apartment["apartment_title"] . "\n"; $message .= "Inhabiting Start:\t" . date(DEFAULT_DATE_FORMAT, $apartment["inhabiting_start"]) . "\n"; $message .= "Inhabiting Finish:\t" . date(DEFAULT_DATE_FORMAT, $apartment["inhabiting_finish"]) . "\n\n"; } } $message .= "=======================================================\n\n"; $message .= "Deletion Date:\t" . date("r", time()) . "\n"; $message .= "Deleted By:\t" . $_SESSION["details"]["firstname"] . " " . $_SESSION["details"]["lastname"] . " (" . $ENTRADA_USER->getID() . ")\n"; break; case "change-critical": $message = "Attention " . $AGENT_CONTACTS["agent-regionaled"]["name"] . ",\n\n"; $message .= $_SESSION["details"]["firstname"] . " " . $_SESSION["details"]["lastname"] . " has updated an event in " . $whole_name . "'s "; $message .= "clerkship schedule, to which you had previously assigned housing. This update involves a change to the region or the "; $message .= "dates that the event took place in. Due to this critical change taking place, the housing for this event for this "; $message .= "student has been removed.\n\n"; if ($result["manage_apartments"]) { $message .= "Please log into the clerkship system and re-assign housing to this student for this event.\n\n"; } else { $message .= "Since this event no longer is taking place in a region which is managed by Regional Education, \n"; $message .= "no further action is required on your part in the system.\n\n"; } $message .= "Information For Reference:\n\n"; $message .= "OLD Event Information:\n"; $message .= "Event Title:\t" . $event_info["event_title"] . "\n"; $message .= "Region:\t\t" . get_region_name($event_info["region_id"]) . "\n"; $message .= "Start Date:\t" . date(DEFAULT_DATE_FORMAT, $event_info["event_start"]) . "\n"; $message .= "Finish Date:\t" . date(DEFAULT_DATE_FORMAT, $event_info["event_finish"]) . "\n\n"; $message .= "NEW Event Information:\n"; $message .= "Event Title:\t" . html_decode($result["event_title"]) . "\n"; $message .= "Region:\t\t" . $result["region_name"] . "\n"; $message .= "Start Date:\t" . date(DEFAULT_DATE_FORMAT, $result["event_start"]) . "\n"; $message .= "Finish Date:\t" . date(DEFAULT_DATE_FORMAT, $result["event_finish"]) . "\n\n"; if ($apartments && ($assigned_apartments = @count($apartments))) { $message .= "Apartment" . ($assigned_apartments != 1 ? "s" : "") . " " . $whole_name . " was removed from:\n"; foreach ($apartments as $apartment) { $message .= "Apartment Title:\t" . $apartment["apartment_title"] . "\n"; $message .= "Inhabiting Start:\t" . date(DEFAULT_DATE_FORMAT, $apartment["inhabiting_start"]) . "\n"; $message .= "Inhabiting Finish:\t" . date(DEFAULT_DATE_FORMAT, $apartment["inhabiting_finish"]) . "\n\n"; } } $message .= "=======================================================\n\n"; $message .= "Deletion Date:\t" . date("r", time()) . "\n"; $message .= "Deleted By:\t" . $_SESSION["details"]["firstname"] . " " . $_SESSION["details"]["lastname"] . " (" . $ENTRADA_USER->getID() . ")\n"; break; case "change-non-critical": case "updated": default: $message = "Attention " . $AGENT_CONTACTS["agent-regionaled"]["name"] . ",\n\n"; $message .= $_SESSION["details"]["firstname"] . " " . $_SESSION["details"]["lastname"] . " has updated an event in " . $whole_name . "'s "; $message .= "clerkship schedule, to which you had previously assigned housing.\n\n"; $message .= "Important:\n"; $message .= "This update does not affect the date or region of this event, as such this change is considered non-critical "; $message .= "and no action is required on your part.\n\n"; $message .= "Information For Reference:\n\n"; $message .= "OLD Event Information:\n"; $message .= "Event Title:\t" . $event_info["event_title"] . "\n"; $message .= "Region:\t\t" . get_region_name($event_info["region_id"]) . "\n"; $message .= "Start Date:\t" . date(DEFAULT_DATE_FORMAT, $event_info["event_start"]) . "\n"; $message .= "Finish Date:\t" . date(DEFAULT_DATE_FORMAT, $event_info["event_finish"]) . "\n\n"; $message .= "NEW Event Information:\n"; $message .= "Event Title:\t" . html_decode($result["event_title"]) . "\n"; $message .= "Region:\t\t" . $result["region_name"] . "\n"; $message .= "Start Date:\t" . date(DEFAULT_DATE_FORMAT, $result["event_start"]) . "\n"; $message .= "Finish Date:\t" . date(DEFAULT_DATE_FORMAT, $result["event_finish"]) . "\n\n"; if ($apartments && ($assigned_apartments = @count($apartments))) { $message .= "Apartment" . ($assigned_apartments != 1 ? "s" : "") . " " . $whole_name . " is assigned to:\n"; foreach ($apartments as $apartment) { $message .= "Apartment Title:\t" . $apartment["apartment_title"] . "\n"; $message .= "Inhabiting Start:\t" . date(DEFAULT_DATE_FORMAT, $apartment["inhabiting_start"]) . "\n"; $message .= "Inhabiting Finish:\t" . date(DEFAULT_DATE_FORMAT, $apartment["inhabiting_finish"]) . "\n\n"; } } $message .= "=======================================================\n\n"; $message .= "Updated Date:\t" . date("r", time()) . "\n"; $message .= "Update By:\t" . $_SESSION["details"]["firstname"] . " " . $_SESSION["details"]["lastname"] . " (" . $ENTRADA_USER->getID() . ")\n"; break; } $mail = new Zend_Mail(); $mail->addHeader("X-Originating-IP", $_SERVER["REMOTE_ADDR"]); $mail->addHeader("X-Section", "Clerkship Notify System", true); $mail->clearFrom(); $mail->clearSubject(); $mail->setFrom($AGENT_CONTACTS["agent-notifications"]["email"], APPLICATION_NAME . ' Clerkship System'); $mail->setSubject("MEdTech Clerkship System - " . ucwords($action) . " Event"); $mail->setBodyText($message); $mail->clearRecipients(); $mail->addTo($AGENT_CONTACTS["agent-regionaled"]["email"], $AGENT_CONTACTS["agent-regionaled"]["name"]); $sent = true; try { $mail->send(); application_log("success", "An event change notification has been sent to regional education to notify them of the changes to the event [" . $event_info["event_id"] . "] which will affect the apartment schedule."); return true; } catch (Exception $e) { system_log_data("error", "Unable to send " . $action . " notification to regional education. Zend_mail said: " . $e->getMessage()); return false; } } else { return true; } } else { // No need to notify Regional Education because the event is already over, just return true. return true; } } else { system_log_data("error", "The notify_regional_education() function returned false with no results from the database query. Database said: " . $db->ErrorMsg()); return false; } }
while ($row = $db->FetchRow($res)) { if (!isset($arr[$row['supplier_id']])) { //获取店铺三个最新商品 $gsql = "select goods_id, goods_name, goods_thumb, goods_img, shop_price from " . $ecs->table('goods') . " where supplier_id=" . $row['supplier_id'] . " order by goods_id desc"; $glist = $db->getAll($gsql); $arr[$row['supplier_id']]['goodlist'] = $glist; foreach ($glist as $k => $v) { $arr[$row['supplier_id']]['goodlist'][$k]['goods_thumb'] = '../' . get_image_path($v['goods_id'], $v['goods_thumb'], true); $arr[$row['supplier_id']]['goodlist'][$k]['goods_img'] = '../' . get_image_path($v['goods_id'], $v['goods_img']); $arr[$row['supplier_id']]['goodlist'][$k]['url'] = build_uri('goods', array('gid' => $v['goods_id']), $v['goods_name']); } } $arr[$row['supplier_id']][$row['code']] = $row['value']; $arr[$row['supplier_id']]['supplier_id'] = $row['supplier_id']; $arr[$row['supplier_id']]['shop_province_name'] = get_region_name($arr[$row['supplier_id']]['shop_province']); $arr[$row['supplier_id']]['shop_city_name'] = get_region_name($arr[$row['supplier_id']]['shop_city']); $arr[$row['supplier_id']]['goods_number'] = count($arr[$row['supplier_id']]['goodlist']); } //获取店铺评分 foreach ($arr as $k => $v) { //代码增加 $sql1 = "SELECT AVG(comment_rank) FROM " . $GLOBALS['ecs']->table('comment') . " c" . " LEFT JOIN " . $GLOBALS['ecs']->table('order_info') . " o" . " ON o.order_id = c.order_id" . " WHERE c.status > 0 AND o.supplier_id = " . $v['supplier_id']; $avg_comment = $GLOBALS['db']->getOne($sql1); $avg_comment = round($avg_comment, 1); $sql2 = "SELECT AVG(server), AVG(shipping) FROM " . $GLOBALS['ecs']->table('shop_grade') . " s" . " LEFT JOIN " . $GLOBALS['ecs']->table('order_info') . " o" . " ON o.order_id = s.order_id" . " WHERE s.is_comment > 0 AND s.server >0 AND o.supplier_id = " . $v['supplier_id']; $row = $GLOBALS['db']->getRow($sql2); $avg_server = round($row['AVG(server)'], 1); $avg_shipping = round($row['AVG(shipping)'], 1); $haoping = round(($avg_comment + $avg_server + $avg_shipping) / 3 / 5, 2) * 100; //代码增加 $arr[$k]['c_rank'] = $avg_comment;
if ($ERROR) { $STEP = 1; } break; case 1: default: if (!isset($APARTMENT_INFO['keys_firstname']) || $APARTMENT_INFO['keys_firstname'] == '') { $APARTMENT_INFO['keys_firstname'] = $APARTMENT_INFO['super_firstname']; $APARTMENT_INFO['keys_lastname'] = $APARTMENT_INFO['super_lastname']; $APARTMENT_INFO['keys_phone'] = $APARTMENT_INFO['super_phone']; $APARTMENT_INFO['keys_email'] = $APARTMENT_INFO['super_email']; } $super_for_keys = $APARTMENT_INFO['keys_firstname'] == $APARTMENT_INFO['super_firstname'] && $APARTMENT_INFO['keys_lastname'] == $APARTMENT_INFO['super_lastname'] && $APARTMENT_INFO['keys_phone'] == $APARTMENT_INFO['super_phone'] && $APARTMENT_INFO['keys_email'] == $APARTMENT_INFO['super_email'] ? 'true' : 'false'; $PROCESSED = $APARTMENT_INFO; if (isset($APARTMENT_INFO["region_id"])) { $PROCESSED["city"] = get_region_name($APARTMENT_INFO["region_id"]); } break; } switch ($STEP) { case 2: if ($ERROR) { echo display_errors(); } if ($NOTICE) { echo display_notices(); } if ($SUCCESS) { echo display_success(); } break;
public function check_payment() { $payment_module_code = I('post.payment_module_code', ''); $coupon = I('post.coupon', ''); if ($this->memberID <= 0 && GetValue('quickbuy') == 0) { $this->redirect('Admin/login'); } $cartModel = D('Cart'); if ($cartModel->get_item_count($this->sessionID) < 1) { $this->error("Your shopping cart does not have any goods."); } if (empty($payment_module_code)) { $this->error('Please select PAYMENT METHOD.'); } $couponModel = D('Coupon'); if (!empty($coupon)) { if (!$couponModel->validate($coupon)) { $this->error('The coupon is invalid.'); } } $ordersModel = D('Orders'); $shippingModel = D('Shipping'); $shippingaddressModel = D('Shippingaddress'); $paymentModel = D('Payment'); if ($delivery_list = $ordersModel->create()) { $delivery = $_POST['delivery']; //0会员本身地址,1其它地址 if ($delivery == 0) { $memberModel = D('Members'); $delivery_list['member_id'] = $this->memberID; $this->member_info = $member_info = $memberModel->find($this->memberID); $delivery_list['delivery_email'] = $member_info['email']; $delivery_list['delivery_firstname'] = $member_info['firstname']; $delivery_list['delivery_lastname'] = $member_info['lastname']; $address = $shippingaddressModel->get_shippingaddress($this->memberID); $delivery_list['delivery_address'] = $address['address']; $delivery_list['delivery_country'] = $address['country']; $delivery_list['delivery_state'] = $address['state']; $delivery_list['delivery_city'] = $address['city']; $delivery_list['delivery_zip'] = $address['zip']; $delivery_list['delivery_telephone'] = $address['telphone']; } $delivery_list['total_weight'] = $cartModel->cart_total_weight($this->sessionID); if ($delivery_list['shipping_id']) { $delivery_list['shippingmoney'] = $shippingModel->get_shipping_fee($delivery_list['shipping_id'], $delivery_list['delivery_country'], $delivery_list['delivery_state'], $delivery_list['delivery_city'], $delivery_list['total_weight']); } else { $delivery_list['shippingmoney']['price'] = 0; } $delivery_list['shippingmoney'] = $delivery_list['shippingmoney']['price']; //没有价格取保险金 if (empty($delivery_list['shippingmoney'])) { $delivery_list['shippingmoney'] = $shippingModel->get_insure($delivery_list["shipping_id"]); } $delivery_list['shipping_method'] = $delivery_list['shipping_module_code'] = $shippingModel->get_name($delivery_list["shipping_id"]); $products_total = $cartModel->cart_total($this->sessionID); //产品总价格 $discount = $cartModel->discount($products_total); //打折信息 $sum_total = round($discount['price'], 2); //打折后价格 $delivery_list['discount'] = $discount['text']; $itemTotal = $cartModel->get_item_totalcount($this->sessionID); //总数量 $payment_id = $paymentModel->get_id($delivery_list["payment_module_code"]); $fee = get_orders_Fees($sum_total, $itemTotal, $payment_id); //最小订单金额 if ($fee['minimum_money'] && $fee["total"] <= $fee['minimum_money']) { $this->error("Not be less than " . $fee['minimum_money'] . " minimum!"); } //满金额免运费, 总金额大于免运费 $free_shipping = GetValue('free_shipping'); $this->free_shipping = $free_shipping; if ($free_shipping && $fee['total'] >= $free_shipping) { $delivery_list['shippingmoney'] = 0; } $delivery_list['paymoney'] = $fee["paymoney"]; $delivery_list['insurance'] = $fee["insurance"]; $delivery_list['orders_total'] = $fee['total'] + $delivery_list['shippingmoney']; //总价加上运费 $delivery_list['products_total'] = $fee['products_total']; //判断手动和选择 $delivery_list['delivery_country'] = is_numeric($delivery_list['delivery_country']) ? get_region_name($delivery_list['delivery_country']) : $delivery_list['delivery_country']; $delivery_list['delivery_state'] = is_numeric($delivery_list['delivery_state']) ? get_region_name($delivery_list['delivery_state']) : $delivery_list['delivery_state']; $delivery_list['delivery_city'] = is_numeric($delivery_list['delivery_city']) ? get_region_name($delivery_list['delivery_city']) : $delivery_list['delivery_city']; //货币符号 $delivery_list['currencies_code'] = $_SESSION['currency']['code'] ? $_SESSION['currency']['code'] : '$'; //如果使用了优惠券 if ($coupon) { $delivery_list['orders_total'] -= $coupon['amount']; $delivery_list['coupon'] = $coupon['amount']; //记录优惠了多少价格 } //生成订单 $ordersModel->create($delivery_list); //过滤 if ($orders_id = $ordersModel->add()) { //保存优惠券使用者 $couponModel->where(array('coupon' => $coupon))->save(array('user' => $delivery_list['delivery_lastname'] . ' ' . $delivery_list['delivery_firstname'], 'status' => 0)); //处理orders_products表 $orders_products_model = D('OrdersProducts'); $list = $cartModel->get_cart_list($this->sessionID); if ($list) { foreach ($list as $k => $v) { $data['orders_id'] = $orders_id; $data['products_model'] = serialize($v['model']); $data['products_id'] = $v['pid']; $data['products_name'] = $v['name']; $data['products_price'] = $v['price']; $data['products_pricespe'] = $v['pricespe']; $data['products_quantity'] = $v['count']; $data['products_total'] = $v['total']; if ($orders_products_model->create($data)) { $orders_products_model->add(); } } } //清除购物车 $cartModel->clear_cart($this->sessionID); //发送邮件 /* //邮件变量 $this->assign('itemTotal', $itemTotal); //总数量 $this->assign('totalWeight', $delivery_list['total_weight']); //总重量 $this->assign('orders_data', $delivery_list); //订单数据 $this->assign('list', $list); //购物车产品 $this->assign('cartTotal', getprice_str($products_total)); //产品总价格 if($fee['insurance']) { $this->assign('insurance',getprice_str($fee['insurance'])); } if($fee['paymoney']>0) { $this->assign('paymoney',getprice_str($fee['paymoney'])); } $this->assign('discount', $discount); //打折 $this->assign('shippingPrice', getprice_str($delivery_list['shippingmoney'])); //运费 $this->assign('totalAmount', getprice_str($delivery_list['orders_total'])); //全部总价 $this->assign('this_script', "http://".$_SERVER['HTTP_HOST']); $sendto = array($delivery_list['delivery_email'],GetValue('mailcopyTo')); //抄送 $body = $this->fetch("MailTpl:checkout"); sendmail($sendto,GetValue('sitename')." - new order(SN:".$orders_model->sn.")!",$body) ; */ $this->success('The operation success.', U('Cart/pment', array('id' => $orders_id))); } else { $this->error($ordersModel->getError()); } } else { $this->error($ordersModel->getError()); } }