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());
}
}
