public function httpGetMethod(Http $http, array $queryFields)
{
/*
* Méthode appelée en cas de requête HTTP GET
*
* L'argument $http est un objet permettant de faire des redirections etc.
* L'argument $queryFields contient l'équivalent de $_GET en PHP natif.
*/
$userSession = new UserSession();
if ($userSession->isAuthenticated() == false) {
$http->redirectTo('/User/Login');
}
if (array_key_exists('order_Id', $queryFields)) {
if (ctype_digit($queryFields['order_Id'])) {
//var_dump($queryFields['order_Id']);
$orderModel = new OrderModel();
$orderInformation = $orderModel->findOrder($queryFields['order_Id']);
$customerModel = new CustomerModel();
$customerInformation = $customerModel->findCustomer($orderInformation['Customer_Id']);
$order = $orderModel->getOrderLineByOrderId($queryFields['order_Id']);
return ['customerInformation' => $customerInformation, 'order' => $order, 'orderInformation' => $orderInformation];
}
}
$http->redirectTo('/');
}
/**
* 取消订单
* @param $orderId
*/
public function cancelOrder($orderId)
{
$openId = (new WeixinUtil())->getOpenId();
if (!$openId) {
ResponseUtil::failure('未授权访问！');
}
if (!$orderId) {
ResponseUtil::failure('没有订单');
}
$orderId += 0;
$orderModel = new OrderModel();
// 获得订单
$order = $orderModel->readOne($orderId);
if (!$order) {
ResponseUtil::failure('取消订单失败!');
}
// 获得积分ID
$couponId = $order['use_coupon_id'];
if ($couponId) {
(new CustomerCouponModel())->refundCoupon($couponId, $openId);
}
//取消订单
if ((new CurdUtil(new OrderModel()))->update(array('order_id' => $orderId, 'open_id' => $openId), array('order_status' => OrderModel::ORDER_CANCEL))) {
ResponseUtil::executeSuccess('订单取消成功！');
} else {
ResponseUtil::failure('取消订单失败!');
}
}
public function index()
{
$orderModel = new OrderModel();
$view = new ViewModel('admin/index');
$view->assign('orders', $orderModel->selectPendingOrders($_POST));
$view->assign('complains', $orderModel->selectComplains($_POST));
$view->display();
}
static function count($where)
{
if (!$where) {
return false;
}
$model = new OrderModel();
$result = $model->count($where);
return $result;
}
public function find()
{
$view = new ViewModel('main/find');
$orderModel = new OrderModel();
if (isset($_POST['id_przesylki'])) {
$result = $orderModel->findDelivery($_POST['id_przesylki']);
if (!empty($result)) {
$view->assign('delivery', $result);
$view->assign('from', $orderModel->getAddress($result['od']));
$view->assign('to', $orderModel->getAddress($result['do']));
}
$view->setTemplate('main/findResult');
}
$view->display();
}
function actionOrder($id)
{
$this->template->o = OrderModel::get($id, $this->user->getIdentity()->data['user_id']);
if (!$this->template->o) {
throw new NBadRequestException('Objednávka č. ' . (int) $id . ' neexistuje');
}
}
public function test()
{
Sys::D('Order');
$goodsData = array(array(1, 3), array(2, 1));
$receiveData = array('username' => 'bee', 'tel' => '18224087281', 'email' => '*****@*****.**', 'address' => '四川省成都市青羊区');
OrderModel::add(1, 1, $goodsData, $receiveData, 'this is a remark');
}
public static function cancelOrder(Order $order)
{
if ($order->getStatus() != OrderStatus::ACTIVE) {
self::$errorMessage = "The order cannot be canceled";
return false;
}
$deal = new Deal();
$deal->findActiveDealByOrderId($order->getId());
$rate = new Rate();
$rate->findById($order->getRateId());
if ($order->getType() == OrderType::BUY) {
$purse = self::getPurse($order->getUserId(), $rate->getSecondCurrencyId());
$refund = $deal->getVolume() * $deal->getPrice() * (1.0 + $rate->getFee());
} else {
$purse = self::getPurse($order->getUserId(), $rate->getFirstCurrencyId());
$refund = $deal->getVolume();
}
$purse->addValue($refund);
$purse->save();
$deal->delete();
if ($order->getPart() == 0) {
$order->setStatus(OrderStatus::CANCELLED);
} else {
$order->setStatus(OrderStatus::PARTIALLY_DONE);
}
$order->setDate(date("Y-m-d H:i:s"));
$order->save();
self::refreshRatePrices($rate);
return true;
}
public function submitOrder($force = false)
{
if (!$this->_order) {
return false;
}
$this->module->getLogger()->info('Will submit order to Payin7, ID: ' . $this->_order->getOrderId());
$already_sent = $this->getPayin7IsOrderSent();
// check if already submitted
if ($already_sent && !$force) {
$this->module->getLogger()->debug('Order already submitted - not doing anything');
return $this->getPayin7OrderIdentifier();
}
// begin submitting
$data = array('order_id' => $this->_order->getOrderId(), 'unique_order_id' => $this->_order->getPayin7OrderIdentifier(), 'payment_method' => $this->_order->getPaymentMethodCode(), 'device_type' => $this->_device_type, 'ordered_by_ip_address' => $this->_ordered_by_ip_address, 'source' => $this->_source, 'order' => json_encode($this->_prepareOrderData()), 'items' => json_encode($this->_prepareOrderItems()), 'addresses' => json_encode($this->_prepareOrderAddresses()), 'customer' => json_encode($this->_prepareCustomerData()), 'sysinfo' => json_encode($this->_sysinfo));
$this->module->getLogger()->info(($already_sent ? 'RE-' : null) . 'Submitting order to Payin7: ' . print_r(array('order_id' => $this->_order->getOrderId(), 'payment_method' => $this->_order->getPaymentMethodCode()), true));
$client = $this->module->getApiClientInstance();
$response = $client->postOrder($data);
if (!$response['payin7_order_id']) {
return false;
}
// update the order
$this->_order->setPayin7OrderIdentifier($response['payin7_order_id']);
$this->_order->setPayin7OrderSent(true);
$this->_order->setPayin7OrderAccepted((bool) $response['is_accepted']);
$this->_order->setPayin7AccessToken($response['access_token']);
$this->module->getLogger()->info('Order ' . ($already_sent ? 're' : null) . 'submitted to Payin7, ID: ' . $this->_order->getOrderId() . ', data: ' . print_r($response, true));
return $this;
}
public static function getInstance()
{
if (self::$instance === null) {
return self::$instance = new self();
} else {
return self::$instance;
}
}
public function render($controls = true)
{
// $this->beforeRender();
//print_r($this->template);
$this->template->setFile(dirname(__FILE__) . '/small.phtml');
// $this->template->total_sum-=$this->template->weight_price;
$this->template->cart_info = OrderModel::getCartInfo($this->session->products, false, false, $this->getPresenter()->context, $isCache = true);
$this->template->render();
}
public function httpPostMethod(Http $http, array $formFields)
{
/*
* Méthode appelée en cas de requête HTTP POST
*
* L'argument $http est un objet permettant de faire des redirections etc.
* L'argument $formFields contient l'équivalent de $_POST en PHP natif.
*/
$userSession = new UserSession();
if ($userSession->isAuthenticated() == false) {
$http->redirectTo('/User/Login');
}
$orderModel = new OrderModel();
$order_Id = $orderModel->validation($formFields['order'], $userSession->getId());
//$order = $orderModel->getOrderById($order_Id);
//return ['order', $order];
$http->redirectTo('/Order/Payment?order_Id=' . $order_Id);
// TODO : PAGE DE VALIDATION DU PANIER ET BOUTON PAYMENT
}
/**
* (non-phpDoc)
*
* @see Nette\Application\Control#render()
*/
public function render($params = array())
{
$order_info = NEnvironment::getSession('user_order_info');
$this->template->delivery = (isset($params['delivery']) and $params['delivery'] == true) ? $order_info['values']['id_delivery'] : false;
$this->template->payment = (isset($params['delivery']) and $params['delivery'] == true) ? $order_info['values']['id_payment'] : false;
$this->template->cart_info = OrderModel::getCartInfo($this->session->products, $this->template->delivery, $this->template->payment, $this->getPresenter()->context, $isCache = true);
// dump($this->template->cart_info);
$this->template->controls = (isset($params['controls']) and $params['controls'] == false) ? false : true;
$this->template->setFile(dirname(__FILE__) . '/default.phtml');
$this->template->render();
// $session = NEnvironment::getSession('cart');
}
/**
* 取消订单
* @param string $order_id
*/
public function CancelOrder($order_id = '')
{
if (!$order_id) {
$this->message('订单ID不能为空！');
}
$orderModel = new OrderModel();
// 获得订单
$order = $orderModel->readOne($order_id);
if (!$order) {
ResponseUtil::failure('取消订单失败!');
}
// 获得积分ID
$couponId = $order['use_coupon_id'];
if ($couponId) {
(new CustomerCouponModel())->refundCoupon($couponId, $order['open_id']);
}
if ((new CurdUtil($this->orderModel))->update(array('order_id' => $order_id), array('order_status' => OrderModel::ORDER_CANCEL, 'complete_time' => DateUtil::now()))) {
$this->message('订单已取消！');
} else {
$this->message('处理失败！');
}
}
public function immediateBuy()
{
$goodsId = (int) $this->postParam('goodsId', 0);
$skuAttr = $this->postParam('skuAttr', '');
$skuvalue = $this->postParam('skuValue', '');
$amount = (int) $this->postParam('amount', 0);
if ($goodsId <= 0 || empty($skuAttr) || empty($skuValue)) {
$this->ajaxReturn(ERR_PARAMS_ERROR, '参数错误');
return;
}
$result = OrderModel::createOrder(UserOrderModel::ORDER_PRE_COMMON, $this->userId());
if ($result['code'] != 0) {
$this->ajaxReturn($result['code'], $result['desc']);
return;
}
$this->ajaxReturn(0, '', '', array('token' => $result['result']['token']));
}
public function t()
{
$model = new OrderModel();
$rs = $model->where("orderNo ='" . $head["orderNo"] . "'")->find();
print_r($rs);
/*
vendor("WebOrderService",LIB_PATH."\Service");
$service = new WebOrderService();
$result = $service->login((object)array("userID"=>"00100001","userPass"=>"0000"));
print_r((object)$result);
*/
}
private function saveOrder($jsonArray = null)
{
if (is_array($jsonArray) && isset($jsonArray['usr']) && isset($jsonArray['cart'])) {
$order = new OrderModel();
$usr = $jsonArray['usr'];
$cart = $jsonArray['cart'];
// echo '<pre>';print_R($cart);die;
// add checks here before saving order
$order->setBfname($usr['fname']);
$order->setBlname($usr['lname']);
$order->setBemail($usr['email']);
$order->setBaddressl1($usr['addr1']);
$order->setBaddressl2($usr['addr2']);
$order->setBaddressl3($usr['addr3']);
$order->setBcity($usr['city']);
$order->setBcountry($usr['country']);
$order->setBstate($usr['state']);
$order->setBzipcode($usr['zipcode']);
$order->setInserttime(date("Y-m-d H:i:s"));
$order->setSfname($usr['sfname']);
$order->setSlname($usr['slname']);
$order->setSemail($usr['semail']);
$order->setSaddressl1($usr['saddr1']);
$order->setSaddressl2($usr['saddr2']);
$order->setSaddressl3($usr['saddr3']);
$order->setScity($usr['scity']);
$order->setScountry($usr['scountry']);
$order->setSstate($usr['sstate']);
$order->setStatus("pending");
$order->setSubtotal($cart['subTotal']);
$order->setSzipcode($usr['szipcode']);
$order->setDiscount($cart['discount']);
$order->setTotal($cart['total']);
$order->setQty($cart['qty']);
$order->setOrder_type(strtoupper($usr['ordertype']));
$order->setUserid(Session::getInstance()->getSess("userid"));
$order->insert();
if ($order->isSuccess() == 1) {
$oid = $order->getOrderid();
foreach ($cart['items'] as $k => $itm) {
$item = new OrderProdsModel();
$item->setOid($oid);
$item->setTid($itm['template']);
$item->setPid($itm['product']);
$item->setPrice($itm['price']);
$item->setQty($itm['qty']);
$item->setTotal($itm['total']);
$item->insert();
$this->moveTemplate($itm['template']);
// converts file urls from temp dir to final destination dir
}
if ($cart['disId'] != 0) {
$du = new DiscountUserModel();
$du->setDiscountId($cart['disId']);
$du->setUserId(Session::getInstance()->getSess("userid"));
$du->insert();
if ($cart['discountFor'] == 1) {
$dis = new DiscountModel();
$dis->setDiscountid($cart['disId']);
$dis->setStatus(1);
$dis->update_status();
}
}
if ($usr['ordertype'] == 'cod') {
$this->cod_order($oid, $usr, $cart['total']);
}
$oc = new OrderController();
ob_start();
$oc->printinvoice($oid);
$html = ob_get_clean();
if ($usr['ordertype'] != 'payment') {
Session::getInstance()->setMessage("Order accepted.", "green");
Session::getInstance()->removeSess('cart');
}
mail($usr['email'], "Order Confirmation", $html, "Content-type: text/html; charset=iso-8859-1 \r\nFrom: noreply@snooky.com\r\n");
echo $oid;
} else {
Session::getInstance()->setMessage("Problem in accepting order, please try again.", "red");
echo "failed";
}
}
}
public function setutfbaseAction()
{
if ($this->checkLogin()) {
$model = new OrderModel();
$model->setUTF();
die;
} else {
die;
}
}
/**
* 微信支付后的异步回调
*/
public function notice()
{
$weixin = new WeixinPayUtil();
//通知微信
$notice = $weixin->notifyData();
// 签名成功， 返回数组， 否则返回xml数据
if (!is_array($notice) || !isset($notice['transaction_id'])) {
exit($notice);
}
//签名成功，处理数据
/**
* 返回的数据
* 'appid' => string 'wxf5b5e87a6a0fde94' (length=18)
* 'bank_type' => string 'CFT' (length=3)
* 'fee_type' => string 'CNY' (length=3)
* 'is_subscribe' => string 'N' (length=1)
* 'mch_id' => string '10000097' (length=8)
* 'nonce_str' => string 'dz8nirk7gmxhhxn38zgib28yx14ul2gf' (length=32)
* 'openid' => string 'ozoKAt-MmA74zs7MBafCix6Dg8o0' (length=28)
* 'out_trade_no' => string 'wxf5b5e87a6a0fde941409708791' (length=28)
* 'result_code' => string 'SUCCESS' (length=7)
* 'return_code' => string 'SUCCESS' (length=7)
* 'sign' => string 'EDACA525F6C675337B2DAC25B7145028' (length=32)
* 'sub_mch_id' => string '10000097' (length=8)
* 'time_end' => string '20140903094659' (length=14)
* 'total_fee' => string '1' (length=1)
* 'trade_type' => string 'NATIVE' (length=6)
* 'transaction_id' => string '1004400737201409030005091526' (length=28) //微信支付单号
*/
// $notice = array(
// 'out_trade_no' => '201512271710391206225994',
// 'transaction_id' => '1004400737201409030005091526'
// );
$orderNo = $notice['out_trade_no'];
$wxOrderNo = $notice['transaction_id'];
$openId = $notice['openid'];
$orderModel = new OrderModel();
// 获得订单
$orders = $orderModel->orders(array('order_no' => $orderNo));
if (!$orders || !$orders[0]) {
exit($weixin->notifyFailure());
}
// 判断是否已经支付
$order = $orders[0];
if ($order['order_sign'] == OrderModel::ORDER_PAYED) {
exit($weixin->notifyPayed());
}
// 更新订单信息
$this->db->trans_start();
$orderModel->payed($orderNo, $wxOrderNo);
// 更新积分
$customerModel = new CustomerModel();
$score = $order['total_fee'];
$customer = $customerModel->readOne($openId);
if ($customer) {
$customerModel->addCredits($openId, $score);
}
// 事物完成
$this->db->trans_complete();
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
exit($weixin->notifyFailure());
} else {
$this->db->trans_commit();
// 获得access token
$weixinUtil = new WeixinUtil();
$token = $weixinUtil->getToken();
if ($token) {
//foreach ($orders as $order) {
$orderNo = $order['order_no'];
$appointmentDay = DateUtil::buildDateTime($order['appointment_day'], $order['appointment_start_time']);
$shops = (new ShopModel())->getAllShops();
$shop = $shops[$order['shop_id']];
$beautician = (new BeauticianModel())->readOne($order['beautician_id']);
$beauticianName = $beautician['name'];
$project = (new CurdUtil(new OrderProjectModel()))->readOne(array('order_id' => $order['order_id']));
$projectName = $project['project_name'];
// 计算总积分
$totalCredits = $customer['credits'] + $score;
// 发送模板消息
// $orderNo, $appointmentDay, $shop, $beautician, $projectName
$weixinUtil->sendOrderMessage($orderNo, $appointmentDay, $shop, $beauticianName, $projectName, $openId, $token, $totalCredits);
//}
}
exit($weixin->notifySuccess());
}
}
public function selectForSearch($data)
{
$searchResult = parent::selectForSearch($data);
foreach ($searchResult as $row) {
$newResultLine = new stdclass();
ob_start();
?>
<div class="text-center">
<a href="<?php
echo Config::read('page.url.order.detail') . '/' . $row->id;
?>
" class="btn btn-default btn-sm"><i class="fa fa-edit"></i> Detalhes</a>
<?php
if ($row->status == Config::read('order.status')['new'] && $this->type == 'myPurchases') {
?>
<a href="<?php
echo Config::read('page.url.order.pay') . '/' . $row->id;
?>
" class="btn btn-default btn-sm"><i class="fa fa-money"></i> Pagar</a>
<?php
}
?>
</div>
<?php
$newResultLine->action = ob_get_clean();
$newResultLine->code = $row->id;
$newResultLine->date = $row->date;
// Detalhes do produto
ob_start();
?>
<a href="<?php
echo Config::read('page.url.product.detail') . '/' . $row->product;
?>
">
<div class="row">
<div class="col-xs-2">
<?php
if ($row->photos[0]) {
?>
<img style="width:100px;" src="<?php
echo Config::read('url.photos') . '/' . $row->album . '/small-' . $row->photos[0]->url;
?>
" draggable="false">
<?php
}
?>
</div>
<div class="col-xs-10">
<h4><?php
echo $row->productName;
?>
</h4>
<p><?php
echo $row->productText;
?>
</p>
</div>
</div>
</a>
<?php
$newResultLine->product = ob_get_clean();
// Comprador ou Vendedor?
switch ($this->type) {
case 'mySales':
$newResultLine->person = $row->buyerName;
break;
case 'myPurchases':
$newResultLine->person = $row->vendorName;
break;
default:
$newResultLine->person = " ";
break;
}
// Status do produto
$newResultLine->status = '<span class="label label-' . Config::read('order.status.state')[array_search($row->status, Config::read('order.status'))] . '">' . $row->statusText . '</span>';
$result[] = $newResultLine;
}
return $result;
}
/**
* 删除订单
*
* @param xml string $request
* @return xml string
*/
private function orderDelete($request)
{
try {
$id = $request["body"]["id"];
if (!$id) {
return $this->createResult($request["head"]["type"], -3, 'not a valid action');
}
$model = new OrderModel();
$result = $model->where("id = {$id} and status = 0")->delete();
if (!$result) {
return $this->createResult($request["head"]["type"], -1, 'delete error');
}
return $this->createResult($request["head"]["type"], 1, 'success', 1);
} catch (Exception $e) {
return $this->createResult($request["head"]["type"], -1, 'error in order delete');
}
}
function sendOrderAdmin($order_id)
{
$objEmailer = new Emailer();
$objLayout = new LayoutModel();
$objTemplate = new TemplatesModel();
$objOrder = new OrderModel();
$objUser = new UserModel();
$objSettings = Settings::getInstance();
$adminEmail = $objSettings->getEntry('admin', 'admin-email');
$layoutInfo = $objLayout->loadLayout(28);
$template = $objTemplate->loadTemplateFromKeyname('email-order');
// load order
$orderInfo = $objOrder->getOrder($order_id);
$objUser->setUserId($orderInfo['user_id']);
$userInfo = $objUser->getInfo();
// assign to template
$this->view->assign('adminView', true);
$this->view->assign('orderInfo', $orderInfo);
$this->view->assign('userInfo', $userInfo);
// render template
$this->view->assign('content', $this->view->fetch('fromstring:' . $template['content']));
$this->view->assign('sidebar_left', $this->view->fetch('fromstring:' . $template['left_sidebar']));
$this->view->assign('sidebar_right', $this->view->fetch('fromstring:' . $template['right_sidebar']));
// send email
$objEmailer->setFrom('*****@*****.**');
$objEmailer->addTo($adminEmail, "Parks Associates");
$objEmailer->setSubject('NEW PURCHASE');
$objEmailer->setBody($this->view->fetch('fromstring:' . $layoutInfo['code']), true);
$objEmailer->sendMail();
// see if we also need to send webcast registration email
if (!empty($orderInfo['webcasts'])) {
foreach ($orderInfo['webcasts'] as $webcast) {
// see if its in the future
if (strtotime($webcast['eventDate']) > time()) {
// send them email
$this->sendWebcastRegistrationAdmin($orderInfo);
break;
// only need to send once
}
}
}
return true;
}
public function order()
{
$orderid = $this->orderid ? $this->orderid : 0;
$orderModel = OrderModel::find($orderid);
return isset($orderModel) ? $orderModel : '';
}
public function __construct()
{
parent::__construct();
}
//获取订单号
$trade_no = $_GET['trade_no'];
//获取支付宝交易号
$total_fee = $_GET['price'];
//获取总价格
if ($_GET['trade_status'] == 'WAIT_SELLER_SEND_GOODS') {
//判断该笔订单是否在商户网站中已经做过处理（可参考“集成教程”中“3.4返回数据处理”）
//如果没有做过处理，根据订单号（out_trade_no）在商户网站的订单系统中查到该笔订单的详细，并执行商户的业务程序
//如果有做过处理，不执行商户的业务程序
} else {
echo "trade_status=" . $_GET['trade_status'];
}
echo "验证成功<br />";
echo "trade_no=" . $trade_no;
//——请根据您的业务逻辑来编写程序（以上代码仅作参考）——
require_once '../configs/run.inc.php';
$_order = new OrderModel();
$_order->updateOrderNum();
echo "<script>location.href='../?a=member&m=order';</script>";
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
} else {
//验证失败
//如要调试，请看alipay_notify.php页面的verifyReturn函数，比对sign和mysign的值是否相等，或者检查$responseTxt有没有返回true
echo "验证失败";
}
?>
<title>支付宝担保交易</title>
</head>
<body>
</body>
</html>
function handleCreateOrder()
{
$order_info = NEnvironment::getSession('user_order_info');
$values = $order_info['values'];
// dump($values);exit;
//presmerovanie ak nieco nieje v poriadku
$session = NEnvironment::getSession('cart');
if (empty($session->products)) {
$this->redirect('default');
}
if (empty($order_info['values'])) {
$this->redirect('step2');
}
//znama polick login na email
$values['email'] = $values['login'];
$values['id_lang'] = $this->id_lang;
//odstranenie loginu
unset($values['login']);
//odstranenie terms_and_conditions
unset($values['terms_and_conditions']);
//odstranenie discount_hash
// $discount_hash = $values['discount_hash'];
if ($values['type'] == NULL) {
$values['type'] = 0;
}
$values['user_discount'] = 0;
// ak je prihlaseny setni id_user
if ($this->user->isLoggedIn()) {
$values['id_user'] = $this->user->getIdentity()->data['user_id'];
$values['user_discount'] = $this->user->getIdentity()->data['discount'];
}
$cart_info = OrderModel::getCartInfo($session->products, $order_info['values']['id_delivery'], $order_info['values']['id_payment'], $this->context, false);
$values['total_price'] = $cart_info['total_sum'];
$values['total_price_with_tax'] = $cart_info['total_sum_with_tax'];
$values['delivery_title'] = $cart_info['delivery_title'];
$values['delivery_price'] = $cart_info['delivery_price']['price'];
$values['delivery_tax'] = $cart_info['delivery_price']['tax'];
$values['payment_title'] = $cart_info['payment_title'];
$values['payment_price'] = $cart_info['payment_price']['price'];
$values['payment_tax'] = $cart_info['payment_price']['tax'];
//odstranenie id_delivery
unset($values['id_delivery']);
//odstranenie id_payment
unset($values['id_payment']);
$values['rate'] = Lang::get($this->id_lang)->rate;
try {
$id_order = OrderModel::createOrder($values, $session->products, $this->id_lang, $this->user);
$conf = $this->context->parameters;
$template = $this->template;
$template->setFile(APP_DIR . '/FrontModule/templates/Order/OrderEmail.phtml');
$template->discount = false;
$template->o = OrderModel::get($id_order);
$mail = new MyMail();
$mail->addTo($values['email']);
$mail->addBcc($conf['client_email']);
$mail->setSubject(_('Objednávka č. ') . $id_order);
$mail->setTemplate($template);
$mail->send();
if ($conf['HEUREKA']['ENABLE'] == 1) {
try {
$overeno = new HeurekaOvereno($conf['HEURELA']['API_KEY'], HeurekaOvereno::LANGUAGE_SK);
$overeno->setEmail($values['email']);
foreach ($session->products as $id_product_param => $p) {
$product = ProductModel::getProductIdentifyByParam($id_product_param, $this->id_lang, $this->user);
$overeno->addProduct($product->name);
}
$overeno->send();
} catch (Exception $e) {
}
}
//vymazanie z kosika
$session = NEnvironment::getSession('cart');
unset($session->products);
//vymazanie info o uzivatelovi
unset($order_info['values']);
$this->redirect('Cart:success');
} catch (OrderException $e) {
$form->addError($e);
}
}
/**
*
* Create reservation records
* @param $orderId
* @param $item
*
*/
static function createReservations($orderId, $item)
{
$order = new OrderModel();
$sql = "INSERT INTO `reservations` VALUES (NULL, :Running_films, :Cinema_Name, :Cinema_Address\n ,:Run_Time,:Room_Name,:Room_id,:Seats_Numbers,:Order_Id,:Price)";
$param = ["Running_films" => $item->Film_Name, "Cinema_Name" => $item->Cinema, "Cinema_Address" => $item->Cinema_Address, "Run_Time" => $item->Run_Time, "Room_Name" => $item->Room, "Room_id" => $item->Room_ID, "Seats_Numbers" => $item->Seats, "Order_Id" => $orderId, "Price" => $item->TotalPrice];
$order->modifyOrder($param, $sql);
}
public function acceptComplain()
{
$view = new ViewModel('admin/index');
$orderModel = new OrderModel();
try {
$orderModel->acceptComplain($_POST['id_reklamacji']);
} catch (PDOException $e) {
$view->assign('message-type', 'error');
$view->assign('message', 'Nie można zaakceptować!');
$view->display();
return;
}
$view->assign('message-type', 'info');
$view->assign('message', 'Zaakceptowano!');
$view->display();
}
function transferPaySave()
{
$id = $_GET['id'];
//$id=4;
$val = $_GET['val'];
//$val="shun";
$orderOb = new OrderModel();
//var_dump($orderOb);
$arr = array("id" => $id, "transferPay" => $val);
$re = $orderOb->updOrder($arr);
//var_dump($re);
if ($re !== false) {
echo "1";
exit;
}
}
BookGenreModel::create(array('book_id' => 7, 'genre_id' => 10));
BookGenreModel::create(array('book_id' => 8, 'genre_id' => 13));
BookGenreModel::create(array('book_id' => 9, 'genre_id' => 12));
BookGenreModel::create(array('book_id' => 10, 'genre_id' => 12));
BookGenreModel::create(array('book_id' => 11, 'genre_id' => 12));
BookGenreModel::create(array('book_id' => 12, 'genre_id' => 3));
BookGenreModel::create(array('book_id' => 13, 'genre_id' => 4));
BookGenreModel::create(array('book_id' => 14, 'genre_id' => 2));
BookGenreModel::create(array('book_id' => 15, 'genre_id' => 8));
BookGenreModel::create(array('book_id' => 16, 'genre_id' => 9));
BookGenreModel::create(array('book_id' => 17, 'genre_id' => 10));
BookGenreModel::create(array('book_id' => 18, 'genre_id' => 11));
BookGenreModel::create(array('book_id' => 19, 'genre_id' => 13));
BookGenreModel::create(array('book_id' => 20, 'genre_id' => 12));
BookGenreModel::create(array('book_id' => 21, 'genre_id' => 13));
BookGenreModel::create(array('book_id' => 22, 'genre_id' => 3));
BookGenreModel::create(array('book_id' => 23, 'genre_id' => 4));
BookGenreModel::create(array('book_id' => 24, 'genre_id' => 2));
BookGenreModel::create(array('book_id' => 25, 'genre_id' => 8));
BookGenreModel::create(array('book_id' => 26, 'genre_id' => 9));
BookGenreModel::create(array('book_id' => 27, 'genre_id' => 10));
BookGenreModel::create(array('book_id' => 28, 'genre_id' => 11));
BookGenreModel::create(array('book_id' => 29, 'genre_id' => 12));
BookGenreModel::create(array('book_id' => 30, 'genre_id' => 12));
}
if (!$db->tableExists('order')) {
OrderModel::create(array('user_id' => 1, 'datetime' => "2014-11-11 11:11:11"));
}
if (!$db->tableExists('position')) {
PositionModel::create(array('order_id' => 1, 'book_id' => 1, 'amount' => 1, 'price' => 12.5));
}