/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Orders(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Orders'])) { $model->attributes = $_POST['Orders']; $model->order_sn = F::get_order_sn(); $model->user_id = Yii::app()->user->id ? Yii::app()->user->id : '0'; if ($model->save()) { $cart = Yii::app()->cart; $mycart = $cart->contents(); foreach ($mycart as $mc) { $orderGoods = new OrderGoods(); $orderGoods->order_id = $model->order_id; $orderGoods->product_id = $mc['id']; $orderGoods->product_name = $mc['product_name']; $orderGoods->product_image = serialize($mc['product_image']); $orderGoods->product_sn = $mc['product_sn']; $orderGoods->qty = $mc['qty']; $orderGoods->save(); } $cart->destroy(); $this->redirect(array('success')); } } // // $this->render('create', array( // 'model' => $model, // )); }
public function testGetAnnualMonthlyReport() { /*insert last month*/ foreach (range(0, 5) as $key => $value) { /*insert 5 orders row*/ $newOrder = new Orders(); $newOrder->paid = 5000.0; $newOrder->order_date = (string) Carbon::parse('monday last month'); $newOrder->save(false); } foreach (range(0, 5) as $key => $value) { /*insert 5 orders row*/ $newOrder = new Orders(); $newOrder->paid = 5000.0; $newOrder->order_date = (string) Carbon::parse('monday this month'); $newOrder->save(false); } /*insert this month*/ $reportArr = $this->annualReport->getAnnualMonthlyReport(); /*check if Month is complete*/ $this->assertNotNull($reportArr['January'], 'Check if January is in the report'); $this->assertNotNull($reportArr['February'], 'Check if February is in the report'); $this->assertNotNull($reportArr['March'], 'Check if March is in the report'); $this->assertNotNull($reportArr['April'], 'Check if April is in the report'); $this->assertNotNull($reportArr['May'], 'Check if May is in the report'); $this->assertNotNull($reportArr['June'], 'Check if June is in the report'); $this->assertNotNull($reportArr['July'], 'Check if July is in the report'); $this->assertNotNull($reportArr['August'], 'Check if August is in the report'); $this->assertNotNull($reportArr['September'], 'Check if September is in the report'); $this->assertNotNull($reportArr['October'], 'Check if October is in the report'); $this->assertNotNull($reportArr['November'], 'Check if November is in the report'); $this->assertNotNull($reportArr['December'], 'Check if December is in the report'); $this->assertEquals($reportArr['October'], 30000, 'Make sure total is 30000'); $this->assertEquals($reportArr['November'], 30000, 'Make sure total is 30000'); }
/** * Validates data submitted in the add form. If the validation fails, * displays the add page. Otherwise, creates a new order, saves it and * its products to the database and clears the 'cart' session variable. * Redirects to the front page. */ public static function add() { $params = $_POST; date_default_timezone_set('Europe/Helsinki'); $attributes = array('user_id' => $params['user_id'], 'first_name' => $params['first_name'], 'last_name' => $params['last_name'], 'phone_number' => $params['phone_number'], 'street_address' => $params['street_address'], 'postal_code' => $params['postal_code'], 'city' => $params['city'], 'delivery_method' => $params['delivery_method']); $validator = self::order_validator($attributes); if ($validator->validate()) { $order = new Orders(array('user_id' => $attributes['user_id'], 'order_time' => date('d-m-Y H:i:s'), 'actual_delivery_time' => null, 'delivery_address' => $attributes['street_address'] . ', ' . $attributes['postal_code'] . ' ' . $attributes['city'], 'delivery_method' => $attributes['delivery_method'], 'total_price' => $_SESSION['cart']['price'], 'status' => 'Jonossa')); if (!$params['user_id']) { $user = array('user_id' => null, 'first_name' => $params['first_name'], 'last_name' => $params['last_name'], 'phone_number' => $params['phone_number']); $order->user_id = null; $order->user_info = json_encode($user); } else { $order->user_info = json_encode(Users::findOne($_SESSION['user'])); } if ($order->delivery_method == 'Nouto') { $order->agreed_delivery_time = date('d-m-Y H:i:s', strtotime('+15 minutes', strtotime($order->order_time))); } else { $order->agreed_delivery_time = date('d-m-Y H:i:s', strtotime('+60 minutes', strtotime($order->order_time))); } $order_id = $order->save(); self::set_order_products($order_id, $_SESSION['cart']['items']); $_SESSION['cart'] = null; Redirect::to('/', array('message' => 'Tilauksesi on lähetetty, kiitos!')); } else { View::make('order/add.html', array('errors' => $validator->errors(), 'user' => $attributes)); } }
public static function create() { $model = new Orders(); $dateCreated = new DateTime('now'); $model->created = $dateCreated->format('Y-m-d H:i:s'); $model->status = Orders::STATUS_CREATED; if ($model->save()) { return $model->id; } else { return false; } }
public function storeData($walletID) { $attributes = $this->apiAttributes(); //Retrieve the XML dataset $orders = $this->getEVEData($walletID); $character = Characters::Model()->findByPk($walletID); Orders::Model()->deleteAll('charID=:charID', array(':charID' => $character->characterID)); foreach ($orders->result->rowset->row as $row) { $exist = Orders::Model()->exists('orderID=:orderID', array(':orderID' => $row->attributes()->orderID)); if (!$exist) { //echo "ORDERID: {$row->attributes()->orderID} <br>"; $orderRow = new Orders(); $orderRow->orderID = $row->attributes()->orderID; $orderRow->charID = $row->attributes()->charID; $orderRow->stationID = $row->attributes()->stationID; $orderRow->volEntered = $row->attributes()->volEntered; $orderRow->volRemaining = $row->attributes()->volRemaining; $orderRow->minVolume = $row->attributes()->minVolume; $orderRow->orderState = $row->attributes()->orderState; $orderRow->typeID = $row->attributes()->typeID; $orderRow->range = $row->attributes()->range; $orderRow->accountKey = $row->attributes()->accountKey; $orderRow->duration = $row->attributes()->duration; $orderRow->escrow = $row->attributes()->escrow; $orderRow->price = $row->attributes()->price; $orderRow->bid = $row->attributes()->bid; $orderRow->issued = $row->attributes()->issued; $orderRow->save(); //print_r($orderRow->getErrors()); } else { //echo "ORDERID: {$row->attributes()->orderID} <br>"; $orderRow = Orders::Model()->findByPk($row->attributes()->orderID); $orderRow->orderID = $row->attributes()->orderID; $orderRow->charID = $row->attributes()->charID; $orderRow->stationID = $row->attributes()->stationID; $orderRow->volEntered = $row->attributes()->volEntered; $orderRow->volRemaining = $row->attributes()->volRemaining; $orderRow->minVolume = $row->attributes()->minVolume; $orderRow->orderState = $row->attributes()->orderState; $orderRow->typeID = $row->attributes()->typeID; $orderRow->range = $row->attributes()->range; $orderRow->accountKey = $row->attributes()->accountKey; $orderRow->duration = $row->attributes()->duration; $orderRow->escrow = $row->attributes()->escrow; $orderRow->price = $row->attributes()->price; $orderRow->bid = $row->attributes()->bid; $orderRow->issued = $row->attributes()->issued; $orderRow->save(); //print_r($orderRow->getErrors()); } } }
public function actionCreate() { $model = new Orders(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Orders'])) { $model->attributes = $_POST['Orders']; $model->start = date("Y-m-d", strtotime($_POST['Orders']['start'])); $model->stop = date("Y-m-d", strtotime($_POST['Orders']['stop'])); if ($model->save()) { $this->redirect(array('view', 'id' => $model->id)); } } $this->render('create', array('model' => $model)); }
public function paymentAction() { if ($this->request->isPost()) { $orderarray = $this->request->getPost('orderarray'); $orderarray = json_decode($orderarray, TRUE); $sum = 0; foreach ($orderarray as $veg) { $sum += $veg[m_price] * $veg[quant]; } //echo $sum; $auth = $this->session->get('auth'); $id = $auth[uid]; $orders = new Orders(); $orders->u_id = $id; $orders->o_price = $sum; $orders->o_date = date("Y-m-d"); $orders->o_payment = "Failed"; $orders->o_delivery = 0; if ($orders->save() == false) { foreach ($orders->getMessages() as $message) { echo $message; } } else { foreach ($orderarray as $veg) { $orderdetails = new Orderdetails(); $orderdetails->o_id = $orders->o_id; $orderdetails->m_id = $veg[m_id]; $orderdetails->od_quantity = $veg[quant]; $orderdetails->od_prepared = 0; if ($orderdetails->save() == false) { foreach ($orderdetails->getMessages() as $message) { echo $message; } } else { $user = Userdetails::findFirst(array("(u_id = :id:)", 'bind' => array('id' => $id))); if ($user != false) { $datename = $user->u_fname; $dataemail = $user->u_email; $dataphone = $user->u_phno; $dataamount = $sum; $url = "https://www.instamojo.com/slickaccount/test-for-integration-monthly-payment/?intent=buy&data_name=" . $dataname . "&data_email=" . $dataemail . "&data_phone=" . $dataphone . "&data_amount=" . $dataamount . "&data_readonly=data_phone&data_readonly=data_name&data_readonly=data_email"; header('Location: ' . $url); } } } } } }
public function add($order_sn, $user_id, $company_id = 0, $box_id = '', $payment_id = 0, $payment = "", $goods_id = 0, $money = 0, $status = 0, $remark = "", $count = 0) { $bean = new Orders(); $bean->order_sn = $order_sn; $bean->user_id = $user_id; $bean->company_id = $company_id; $bean->box_id = $box_id; $bean->payment_id = $payment_id; $bean->payment = $payment; $bean->goods_id = $goods_id; $bean->money = $money; $bean->status = $status; $bean->remark = $remark; $bean->count = $count; return $bean->save(); }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Orders(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Orders'])) { $model->attributes = $_POST['Orders']; if ($model->save()) { $msg = 'Заказ #' . $model->id . ' - ' . $model->name . ' для ' . $model->client->name . ' создан'; Yii::app()->user->setFlash('success', $msg); Yii::app()->logger->write($msg); $this->redirect(array('view', 'id' => $model->id)); } } $this->render('create', array('model' => $model)); }
public function actionStep2($id, $day) { $models_orders = new Orders(); if (isset($_POST['Orders'])) { $models_orders->name = $_POST['Orders']['name']; $models_orders->tel = $_POST['Orders']['tel']; $models_orders->selected_time_id = $_POST['selected_time_id']; $models_orders->quest_id = $_GET['id']; $models_orders->date_day = $_GET['day']; $models_orders->setScenario('insert'); if ($models_orders->save()) { $this->redirect('/site/success'); } } $this->render('step2', array('model' => $this->loadModel($id), 'day' => $date_day, 'models_orders' => $models_orders)); }
public function checkoutAction() { $id = $this->session->get('user_id'); $orderList = TempOrder::find("user_id = '{$this->session->get('user_id')}'"); foreach ($orderList as $key => $value) { $order = new Orders(); $order->id = UUID::v4(); $order->stadium = $value->stadium; $order->start_hour = $value->start_hour; $order->end_hour = $value->end_hour; $order->user_id = $value->user_id; $order->date_created = Carbon::now()->toDateString(); $order->save(); $value->delete(); } $this->response->redirect('/dashboard'); }
/** * Creates a new model. * @param integer $id the default Car Id * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate($car = null) { $model = new Orders('insert'); if (!empty($car)) { $model->car_id = $car; } // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Orders'])) { $model->attributes = $_POST['Orders']; $model->user_id = Yii::app()->user->id; if ($model->save()) { $this->redirect(array('reservation/index')); } } //$model->car_id = Yii::app()->request->getParam('id'); $this->render('create', array('model' => $model)); }
public function storeOrderIntoDB() { foreach ($this->placedOrder->basket as $item) { $order = new Orders(); $order->deviceid = $this->placedOrder->deviceID; $order->name = $this->placedOrder->name; $order->delivery_location = $this->placedOrder->deliveryLocation; $order->timeplaced = new CDbExpression('NOW()'); $order->status = "placed"; $order->item = $item->item; $order->quantity = $item->quantity; $order->orderNo = $this->placedOrder->orderNumber; //$order->station = $item->station; $order->save(); } /*$order->item = $this->placedOrder->wtf; //$order->deliverylocation = $this->placedOrder->shit; $order->save();*/ }
public function actionAdd() { $this->layout = '//layouts/admin'; $this->pageTitle = 'Новый заказ'; $this->breadcrumbs = array('Заказы' => array('/admin/orders'), 'Новый заказ'); $success = false; if (isset($_POST['data'])) { $model = new Orders(); $dataArray = $_POST['data']; $dataArray['timestamp'] = isset($dataArray['timestamp']) ? strtotime($dataArray['timestamp']) : time(); $orderItems = json_decode($dataArray['order_items'], true); unset($dataArray['order_items']); $model->setAttributes($dataArray); if ($model->save()) { $success = true; if (is_array($orderItems) && count($orderItems)) { foreach ($orderItems as $oItem) { foreach ($oItem as $oId => $amount) { $object = CatalogObjects::model()->findByPk($oId); if (is_object($object) && $amount) { $oItemModel = new OrderItems(); $attributes = array(); $attributes['order_id'] = $model->id; $attributes['name'] = $object->name; $attributes['product_id'] = $object->id; $attributes['price'] = $object->price; $attributes['amount'] = $amount; $oItemModel->setAttributes($attributes); $oItemModel->save(); } } } } } } if ($success) { $this->redirect("/admin/orders"); } if (!isset($model) || !is_object($model)) { $model = new Orders(); } $this->render('add', array('model' => $model, 'errors' => $model->errors)); }
public function bidderdeposit() { $order = new Orders(); $order->desn = Auth::user()->id; $order->fee = 200; $order->fee = 0.01; //must comment $order->step = 3; //这是商家支付保证金 $order->status = 0; $order->title = Auth::user()->username . "-支付保证金"; $order->details = Auth::user()->username . "-支付保证金"; $order->showurl = "http://www.51jinggou.com/demand/show/1"; $order->save(); $this->payorder($order->id); }
/** * Create an order with many products * * * @param $product * @return integer $orderID */ public static function createOrderWithMultiProducts(array $products, $customer_id, $type = "domain") { $order = new Orders(); try { $customer = Customers::getAllInfo($customer_id); $isp_id = $customer['isp_id']; // Creating a new Order. $order->customer_id = $customer_id; $order->isp_id = $isp_id; $order->order_date = date('Y-m-d'); $order->status_id = Statuses::id("tobepaid", "orders"); // To pay $order->save(); $id = $order->getIncremented(); // Add a fastlink to a order $link_exist = Fastlinks::findlinks($id, $customer_id, 'orders'); if (count($link_exist) == 0) { $link = new Fastlinks(); $link->controller = "orders"; $link->action = "edit"; $link->params = json_encode(array('id' => $id)); $link->customer_id = $customer_id; $link->sqltable = "orders"; $link->id = $id; $link->code = Shineisp_Commons_Utilities::GenerateRandomString(); $link->save(); } foreach ($products as $product) { $product = Domains::getAllInfo($product, null, null, true); // Attaching the order item to the order previously created. $orderitem = new OrdersItems(); $date_end = Shineisp_Commons_Utilities::add_date(date('d-m-Y'), null, 365); // Fixed Renew $orderitem->order_id = $id; $orderitem->product_id = $product[0]['Products']['product_id']; $orderitem->billing_cycle_id = 1; $orderitem->date_start = date('Y-m-d H:i:s'); $orderitem->date_end = $date_end; $orderitem->autorenew = true; $orderitem->description = $product[0]['domain'] . "." . $product[0]['tld']; $orderitem->quantity = 1; $tax = Taxes::getTaxbyProductID($product[0]['Products']['product_id']); $orderitem->price = $product[0]['Products']['price_1']; $orderitem->cost = $product[0]['Products']['cost']; $orderitem->status_id = Statuses::id("processing", "orders"); // Processing status set $orderitem->save(); $detailid = $orderitem->getIncremented(); // Set the domains status as processing Domains::setStatus($product[0]['domain_id'], 6); } // Update the total of the order self::updateTotalsOrder($id); return $id; } catch (Exception $e) { echo $e->getMessage(); die; } }
public function actionCart() { $this->pageTitle = 'Мобильный мир - корзина'; $this->menu = Category::model()->findAll(); if (isset($_POST['submit_cart'])) { Yii::app()->shoppingCart->remove($_POST['submit_cart']); } if (Yii::app()->request->isAjaxRequest) { $pos_first = Yii::app()->shoppingCart->getPositions(); foreach ($pos_first as $position) { if ($position->id == $_POST['id']) { $quantity = $position->getQuantity(); } } Yii::app()->shoppingCart->update(Models::model()->findByPk($_POST['id']), $_POST['button'] == 'minus' ? $quantity > 1 ? $quantity - 1 : $quantity : $quantity + 1); $pos = Yii::app()->shoppingCart->getPositions(); $data[0] = Yii::app()->shoppingCart->getCost(); $data[1] = Yii::app()->shoppingCart->getCount(); foreach ($pos as $position) { if ($position->id == $_POST['id']) { $data[2] = $position->getQuantity(); $data[3] = $position->getSumPrice(); } } echo json_encode($data); // Завершаем приложение Yii::app()->end(); } $order = new Orders(); if (isset($_POST['Orders'])) { $items = Yii::app()->shoppingCart->getPositions(); $id = array(); $quant = array(); $sum = array(); $cost = Yii::app()->shoppingCart->getCost(); foreach ($items as $item) { $name[] = $item->brandModel->brand . ' ' . $item->model_name; $quant[] = $item->getQuantity(); $sum[] = $item->getSumPrice(); $models = Models::model()->updateByPk($item->id, array('quantity' => $item->quantity - $item->getQuantity())); } $order->attributes = $_POST['Orders']; $order->model_id = json_encode($name); $order->quantity = json_encode($quant); $order->sum = json_encode($sum); $order->total = $cost; if ($order->save()) { /* $message = 'Hello World!'; $mailer = Yii::createComponent('application.extensions.mailer.EMailer'); $mailer->Host = 'smtp.gmail.com'; $mailer->Port = 465; $mailer->Username = '******'; $mailer->Password = '******'; $mailer->IsSMTP(); $mailer->From = '*****@*****.**'; $mailer->AddReplyTo('*****@*****.**'); $mailer->AddAddress('*****@*****.**'); $mailer->FromName = 'Wei Yard'; $mailer->CharSet = 'UTF-8'; $mailer->Subject = Yii::t('demo', 'Yii rulez!'); $mailer->Body = $message; $mailer->Send(); $text_message = 'Новый заказ на от '.$order->name.' на сумму '.$order->total.' рублей'; Yii::import('ext.yii-mail.YiiMailMessage'); $message = new YiiMailMessage; $message->setBody($text_message, 'text'); $message->subject = 'Новый заказ в магазине'; $message->addTo('*****@*****.**'); $message->from = Yii::app()->params['adminEmail']; Yii::app()->mail->send($message);*/ Yii::app()->shoppingCart->clear(); $this->redirect(array('success', 'id_order' => $order->id)); } } $this->render('cart', array('order' => $order)); }
static function createPendingOrderForEnrollmentChequeType($paymentDuedata, $inputs) { $order = new Orders(); $order->customer_id = $paymentDuedata[0]['customer_id']; $order->student_id = $paymentDuedata[0]['student_id']; $order->season_id = $paymentDuedata[0]['season_id']; $order->student_classes_id = $paymentDuedata[0]['student_class_id']; $order->amount = $paymentDuedata[0]['payment_due_amount']; if (isset($inputs['paymentType'])) { $order->payment_mode = $inputs['paymentType']; } if (isset($inputs['chqueNo'])) { $order->cheque_number = $inputs['chqueNo']; } if (isset($inputs['bankChequeName'])) { $order->bank_name = $inputs['bankChequeName']; } $order->payment_for = "enrollment"; $order->payment_dues_id = $paymentDuedata[0]['id']; $order->created_by = Session::get('userId'); $order->created_at = date("Y-m-d H:i:s"); $order->save(); return $order; }
public function enrollKid() { $inputs = Input::all(); $batch_data = Batches::find($inputs['batchCbx']); $eachClassCost = $batch_data->class_amount; //return Response::json(array('status'=>$inputs)); //$inputs['discountPercentage']=$inputs['discountP']; $studentClasses['classId'] = $inputs['eligibleClassesCbx']; $studentClasses['batchId'] = $inputs['batchCbx']; $studentClasses['studentId'] = $inputs['studentId']; $season_data = Seasons::find($inputs['SeasonsCbx']); //$inputs['enrollmentEndDate']=$season_data->end_date; //$studentClasses['enrollment_start_date'] = date('Y-m-d', strtotime($inputs['enrollmentStartDate'])); //return Response::json(array('status'=>'working')); //$studentClasses['enrollment_end_date'] = date('Y-m-d', strtotime($inputs['enrollmentEndDate'])); $studentClasses['selected_sessions'] = $inputs['selectedSessions']; $studentClasses['seasonId'] = $inputs['SeasonsCbx']; //for proper enrollment start date and end date $end = Carbon::now(); $start = Carbon::now(); $start->year = date('Y', strtotime($inputs['enrollmentStartDate'])); $start->month = date('m', strtotime($inputs['enrollmentStartDate'])); $start->day = date('d', strtotime($inputs['enrollmentStartDate'])); $end->year = date('Y', strtotime($inputs['enrollmentEndDate'])); $end->month = date('m', strtotime($inputs['enrollmentEndDate'])); $end->day = date('d', strtotime($inputs['enrollmentEndDate'])); $batch_data = BatchSchedule::where('batch_id', '=', $inputs['batchCbx'])->where('schedule_date', '>=', $start->toDateString())->where('schedule_date', '<=', $end->toDateString())->where('holiday', '!=', 1)->orderBy('id')->get(); $studentClasses['enrollment_start_date'] = $batch_data[0]['schedule_date']; $studentClasses['enrollment_end_date'] = $batch_data[count($batch_data) - 1]['schedule_date']; //Batch Start date $BatchDetails = Batches::where('id', '=', $inputs['batchCbx'])->first(); $reminderStartDate = $BatchDetails->start_date; $enrollment = StudentClasses::addStudentClass($studentClasses); $paymentDuesInput['student_id'] = $inputs['studentId']; $paymentDuesInput['customer_id'] = $inputs['customerId']; $paymentDuesInput['batch_id'] = $inputs['batchCbx']; $paymentDuesInput['class_id'] = $inputs['eligibleClassesCbx']; $paymentDuesInput['selected_sessions'] = $inputs['selectedSessions']; $paymentDuesInput['seasonId'] = $inputs['SeasonsCbx']; $paymentDuesInput['each_class_cost'] = $eachClassCost; $order['customer_id'] = $inputs['customerId']; $order['student_id'] = $inputs['studentId']; $order['seasonId'] = $inputs['SeasonsCbx']; $order['student_classes_id'] = $enrollment->id; $order['payment_mode'] = $inputs['paymentTypeRadio']; $order['payment_for'] = "enrollment"; $order['card_last_digit'] = $inputs['card4digits']; $order['card_type'] = $inputs['cardType']; $order['bank_name'] = $inputs['bankName']; $order['cheque_number'] = $inputs['chequeNumber']; //$order['each_class_cost'] =$eachClassCost; if (isset($inputs['membershipType'])) { $order['membershipType'] = $inputs['membershipType']; } $paydue_id; if ($inputs['paymentOptionsRadio'] == 'singlepay') { // for starting and end date of enrollment $enddate = Carbon::now(); $startdate = Carbon::now(); $startdate->year = date('Y', strtotime($inputs['enrollmentStartDate'])); $startdate->month = date('m', strtotime($inputs['enrollmentStartDate'])); $startdate->day = date('d', strtotime($inputs['enrollmentStartDate'])); $enddate->year = date('Y', strtotime($inputs['enrollmentEndDate'])); $enddate->month = date('m', strtotime($inputs['enrollmentEndDate'])); $enddate->day = date('d', strtotime($inputs['enrollmentEndDate'])); $batch_data = BatchSchedule::where('batch_id', '=', $inputs['batchCbx'])->where('schedule_date', '>=', $startdate->toDateString())->where('schedule_date', '<=', $enddate->toDateString())->where('holiday', '!=', 1)->orderBy('id')->get(); $paymentDuesInput['start_order_date'] = $batch_data[0]['schedule_date']; $paymentDuesInput['end_order_date'] = $batch_data[count($batch_data) - 1]['schedule_date']; $paymentDuesInput['payment_due_amount'] = $inputs['singlePayAmount']; $paymentDuesInput['payment_type'] = $inputs['paymentOptionsRadio']; $paymentDuesInput['payment_status'] = "paid"; $paymentDuesInput['discount_applied'] = $inputs['discountPercentage']; $paymentDuesInput['student_class_id'] = $enrollment->id; $paymentDuesInput['selected_order_sessions'] = $inputs['selectedSessions']; //$paymentDuesInput['start_order_date']=$studentClasses['enrollment_start_date']; //$paymentDuesInput['end_order_date']=$studentClasses['enrollment_end_date']; $paymentDuesInput['discount_amount'] = $inputs['discountPercentage'] / 100 * $inputs['singlePayAmount']; $order['amount'] = $inputs['singlePayAmount']; if ($inputs['CustomerType'] == 'OldCustomer') { $paymentDuesInput['created_at'] = date('Y-m-d H:i:s', strtotime($inputs['OrderDate'])); $order['created_at'] = $paymentDuesInput['created_at']; } $paymentDuesResult = PaymentDues::createPaymentDues($paymentDuesInput); $order['payment_dues_id'] = $paymentDuesResult->id; $order['order_status'] = "completed"; if ($inputs['selectedSessions'] > 8) { // creating followup for the single pay $presentDate = Carbon::now(); $startdate = Carbon::now(); $startdate->year = date('Y', strtotime($inputs['enrollmentStartDate'])); $startdate->month = date('m', strtotime($inputs['enrollmentStartDate'])); $startdate->day = date('d', strtotime($inputs['enrollmentStartDate'])); $batch_schedule_data = BatchSchedule::where('batch_id', '=', $inputs['batchCbx'])->where('schedule_date', '>=', $startdate->toDateString())->where('holiday', '!=', 1)->orderBy('id')->get(); $session_number = (int) ($inputs['selectedSessions'] / 2); $reminder_date = $batch_schedule_data[$session_number]['schedule_date']; $customer_log_data['customer_id'] = $paymentDuesResult->customer_id; $customer_log_data['student_id'] = $paymentDuesResult->student_id; $customer_log_data['franchisee_id'] = Session::get('franchiseId'); $customer_log_data['followup_type'] = 'PAYMENT'; $customer_log_data['followup_status'] = 'REMINDER_CALL'; $customer_log_data['comment_type'] = 'VERYINTERESTED'; $customer_log_data['reminderDate'] = $reminder_date; $remindDate = Carbon::now(); $remindDate = $remindDate->createFromFormat('Y-m-d', $reminder_date); if ($remindDate->gt($presentDate)) { $payment_followup_data = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['paymentfollowup_id'] = $payment_followup_data->id; Comments::addSinglePayComment($customer_log_data); } } } else { if ($inputs['paymentOptionsRadio'] == 'multipay') { $today = Carbon::now(); $paymentDuesInput['payment_type'] = $inputs['paymentOptionsRadio']; for ($i = 1; $i <= 4; $i++) { if (isset($inputs['multipayAmount' . $i])) { $firstBrushupCallReminderDate; $firstInitialPaymentCallReminderDate; $firstFinalPaymentCallReminderDate; if ($i == 1) { $paymentDuesInput['payment_status'] = "paid"; $order['amount'] = $inputs['multipayAmount' . $i]; $enddate = Carbon::now(); $startdate = Carbon::now(); $startdate->year = date('Y', strtotime($inputs['enrollmentStartDate'])); $startdate->month = date('m', strtotime($inputs['enrollmentStartDate'])); $startdate->day = date('d', strtotime($inputs['enrollmentStartDate'])); $enddate->year = date('Y', strtotime($inputs['enrollmentEndDate'])); $enddate->month = date('m', strtotime($inputs['enrollmentEndDate'])); $enddate->day = date('d', strtotime($inputs['enrollmentEndDate'])); $batch_data = BatchSchedule::where('batch_id', '=', $inputs['batchCbx'])->where('schedule_date', '>=', $startdate->toDateString())->where('schedule_date', '<=', $enddate->toDateString())->where('holiday', '!=', 1)->orderBy('id')->get(); $paymentDuesInput['start_order_date'] = $batch_data[0]['schedule_date']; $endorderdate = $batch_data[count($batch_data) - 1]['schedule_date']; //$paymentDuesInput['start_order_date']=$studentClasses['enrollment_start_date']; //$startdate= Carbon::create(date('Y,m,d,0', strtotime($inputs['enrollmentStartDate']))); $startdate = Carbon::now(); $startdate->year = date('Y', strtotime($inputs['enrollmentStartDate'])); $startdate->month = date('m', strtotime($inputs['enrollmentStartDate'])); $startdate->day = date('d', strtotime($inputs['enrollmentStartDate'])); $session_no = $inputs['multipayAmount' . $i] / $eachClassCost; $firstSessionNumber = $session_no; $batch_schedule_data = BatchSchedule::where('batch_id', '=', $inputs['batchCbx'])->where('schedule_date', '>=', $startdate->toDateString())->where('holiday', '!=', 1)->orderBy('id')->get(); $session_no = $session_no - 1; //$startdate=$startdate->addWeeks(($inputs['bipayAmount'.$i]/500)); //$startdate=$startdate->addWeeks(($inputs['multipayAmount'.$i]/500)); $paymentDuesInput['end_order_date'] = $batch_schedule_data[$session_no]['schedule_date']; if ($firstSessionNumber >= 6) { $firstBrushupCallReminderDate = $batch_schedule_data[$session_no - 2]['schedule_date']; $firstInitialPaymentCallReminderDate = $batch_schedule_data[$session_no - 1]['schedule_date']; $firstFinalPaymentCallReminderDate = $batch_schedule_data[$session_no]['schedule_date']; } else { $firstFinalPaymentCallReminderDate = $batch_schedule_data[$session_no]['schedule_date']; } $nextstartdate = $batch_schedule_data[$session_no]['schedule_date']; //$paymentDuesInput['end_order_date']=$startdate->toDateString(); $paymentDuesInput['discount_amount'] = $inputs['discountPercentage'] / 100 * $inputs['multipayAmount' . $i]; if ($inputs['CustomerType'] == 'OldCustomer') { $paymentDuesInput['created_at'] = date('Y-m-d H:i:s', strtotime($inputs['OrderDate'])); $order['created_at'] = $paymentDuesInput['created_at']; } } else { $paymentDuesInput['start_order_date'] = $nextstartdate; $batch_schedule_data = BatchSchedule::where('batch_id', '=', $inputs['batchCbx'])->where('schedule_date', '>=', $startdate->toDateString())->where('holiday', '!=', 1)->orderBy('id')->get(); $session_no = $session_no + $inputs['multipayAmount' . $i] / $eachClassCost; $firstBrushupCallReminderDate = $batch_schedule_data[$session_no - 2]['schedule_date']; $firstInitialPaymentCallReminderDate = $batch_schedule_data[$session_no - 1]['schedule_date']; $firstFinalPaymentCallReminderDate = $batch_schedule_data[$session_no]['schedule_date']; //$startdate=$startdate->addWeeks(($inputs['multipayAmount'.$i]/500)); $paymentDuesInput['end_order_date'] = $batch_schedule_data[$session_no]['schedule_date']; if ($i == 4) { //$paymentDuesInput['end_order_date']=date('Y-m-d', strtotime($inputs['enrollmentEndDate'])); $paymentDuesInput['end_order_date'] = $endorderdate; } $nextstartdate = $batch_schedule_data[$session_no]['schedule_date']; //$paymentDuesInput['end_order_date']= $startdate->toDateString(); $paymentDuesInput['payment_status'] = "pending"; $paymentDuesInput['discount_amount'] = $inputs['discountPercentage'] / 100 * $inputs['multipayAmount' . $i]; if ($i == 2 && $inputs['CustomerType'] == 'OldCustomer' && $inputs['OrderDate2'] != '') { $paymentDuesInput['created_at'] = date('Y-m-d H:i:s', strtotime($inputs['OrderDate2'])); $paymentDuesInput['payment_status'] = "paid"; } if ($i == 3 && $inputs['CustomerType'] == 'OldCustomer' && $inputs['OrderDate3'] != '') { $paymentDuesInput['created_at'] = date('Y-m-d H:i:s', strtotime($inputs['OrderDate3'])); $paymentDuesInput['payment_status'] = "paid"; } if ($i == 4 && $inputs['CustomerType'] == 'OldCustomer' && $inputs['OrderDate4'] != '') { $paymentDuesInput['created_at'] = date('Y-m-d H:i:s', strtotime($inputs['OrderDate4'])); $paymentDuesInput['payment_status'] = "paid"; } } $paymentDuesInput['payment_due_amount'] = $inputs['multipayAmount' . $i]; $paymentDuesInput['discount_applied'] = $inputs['discountPercentage']; $paymentDuesInput['selected_order_sessions'] = $inputs['multipayAmount' . $i] / $eachClassCost; $paymentDuesInput['student_class_id'] = $enrollment->id; $paymentDuesResult = PaymentDues::createPaymentDues($paymentDuesInput); if ($i >= 1 && $i <= 3) { if ($i == 1) { if ($firstSessionNumber >= 6) { $firstremind = Carbon::now(); $firstremind = $firstremind->createFromFormat('Y-m-d', $firstBrushupCallReminderDate); //return Response::json(array('status'=>$firstBrushupCallReminderDate,'today'=>$today)); if ($firstremind->gt($today)) { //create 3 payment followup $payment_followup_data1 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data2 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data3 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); //creating logs/followup for first payment $customer_log_data['customer_id'] = $paymentDuesResult->customer_id; $customer_log_data['student_id'] = $paymentDuesResult->student_id; $customer_log_data['franchisee_id'] = Session::get('franchiseId'); $customer_log_data['paymentfollowup_id'] = $payment_followup_data1->id; $customer_log_data['paymentfollowup_id2'] = $payment_followup_data2->id; $customer_log_data['paymentfollowup_id3'] = $payment_followup_data3->id; $customer_log_data['followup_type'] = 'PAYMENT'; $customer_log_data['followup_status'] = 'REMINDER_CALL'; $customer_log_data['comment_type'] = 'VERYINTERESTED'; $customer_log_data['firstReminderDate'] = $firstBrushupCallReminderDate; $customer_log_data['secondReminderDate'] = $firstInitialPaymentCallReminderDate; $customer_log_data['thirdReminderDate'] = $firstFinalPaymentCallReminderDate; Comments::addPaymentComments($customer_log_data); } else { $final_remind = Carbon::now(); $final_remind = $final_remind->createFromFormat('Y-m-d', $firstFinalPaymentCallReminderDate); if ($final_remind->gt($today)) { $payment_followup_data = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['customer_id'] = $paymentDuesResult->customer_id; $customer_log_data['student_id'] = $paymentDuesResult->student_id; $customer_log_data['franchisee_id'] = Session::get('franchiseId'); $customer_log_data['paymentfollowup_id'] = $payment_followup_data->id; //$customer_log_data['paymentfollowup_id2']=$payment_followup_data2->id; //$customer_log_data['paymentfollowup_id3']=$payment_followup_data3->id; $customer_log_data['followup_type'] = 'PAYMENT'; $customer_log_data['followup_status'] = 'REMINDER_CALL'; $customer_log_data['comment_type'] = 'VERYINTERESTED'; // $customer_log_data['firstReminderDate']=$firstBrushupCallReminderDate; // $customer_log_data['secondReminderDate']=$firstInitialPaymentCallReminderDate; $customer_log_data['reminderDate'] = $firstFinalPaymentCallReminderDate; Comments::addOnebiPaymentComment($customer_log_data); } } } else { $final_r = Carbon::now(); $final_r = $final_r->createFromFormat('Y-m-d', $firstFinalPaymentCallReminderDate); if ($final_r->gt($today)) { //create 1 followup $payment_followup_data = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['customer_id'] = $paymentDuesResult->customer_id; $customer_log_data['student_id'] = $paymentDuesResult->student_id; $customer_log_data['franchisee_id'] = Session::get('franchiseId'); $customer_log_data['paymentfollowup_id'] = $payment_followup_data->id; //$customer_log_data['paymentfollowup_id2']=$payment_followup_data2->id; //$customer_log_data['paymentfollowup_id3']=$payment_followup_data3->id; $customer_log_data['followup_type'] = 'PAYMENT'; $customer_log_data['followup_status'] = 'REMINDER_CALL'; $customer_log_data['comment_type'] = 'VERYINTERESTED'; // $customer_log_data['firstReminderDate']=$firstBrushupCallReminderDate; // $customer_log_data['secondReminderDate']=$firstInitialPaymentCallReminderDate; $customer_log_data['reminderDate'] = $firstFinalPaymentCallReminderDate; Comments::addOnebiPaymentComment($customer_log_data); } } } else { //when i>=3 $firstre = Carbon::now(); $firstre = $firstre->createFromFormat('Y-m-d', $firstBrushupCallReminderDate); if ($firstre->gt($today)) { $customer_log_data['customer_id'] = $paymentDuesResult->customer_id; $customer_log_data['student_id'] = $paymentDuesResult->student_id; $customer_log_data['franchisee_id'] = Session::get('franchiseId'); $customer_log_data['followup_type'] = 'PAYMENT'; $customer_log_data['followup_status'] = 'REMINDER_CALL'; $customer_log_data['comment_type'] = 'VERYINTERESTED'; $customer_log_data['firstReminderDate'] = $firstBrushupCallReminderDate; $customer_log_data['secondReminderDate'] = $firstInitialPaymentCallReminderDate; $customer_log_data['thirdReminderDate'] = $firstFinalPaymentCallReminderDate; if ($i == 2 && isset($inputs['multipayAmount3'])) { $payment_followup_data1 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data2 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data3 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['paymentfollowup_id'] = $payment_followup_data1->id; $customer_log_data['paymentfollowup_id2'] = $payment_followup_data2->id; $customer_log_data['paymentfollowup_id3'] = $payment_followup_data3->id; Comments::addPaymentComments($customer_log_data); } else { if ($i == 3 && isset($inputs['multipayAmount4'])) { $payment_followup_data1 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data2 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data3 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['paymentfollowup_id'] = $payment_followup_data1->id; $customer_log_data['paymentfollowup_id2'] = $payment_followup_data2->id; $customer_log_data['paymentfollowup_id3'] = $payment_followup_data3->id; Comments::addPaymentComments($customer_log_data); } else { if ($i != 3 && $i != 2) { $payment_followup_data1 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data2 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data3 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['paymentfollowup_id'] = $payment_followup_data1->id; $customer_log_data['paymentfollowup_id2'] = $payment_followup_data2->id; $customer_log_data['paymentfollowup_id3'] = $payment_followup_data3->id; Comments::addPaymentComments($customer_log_data); } } } } else { $final = Carbon::now(); $final = $final->createFromFormat('Y-m-d', $firstFinalPaymentCallReminderDate); if ($final->gt($today)) { $payment_followup_data = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['customer_id'] = $paymentDuesResult->customer_id; $customer_log_data['student_id'] = $paymentDuesResult->student_id; $customer_log_data['franchisee_id'] = Session::get('franchiseId'); $customer_log_data['paymentfollowup_id'] = $payment_followup_data->id; //$customer_log_data['paymentfollowup_id2']=$payment_followup_data2->id; //$customer_log_data['paymentfollowup_id3']=$payment_followup_data3->id; $customer_log_data['followup_type'] = 'PAYMENT'; $customer_log_data['followup_status'] = 'REMINDER_CALL'; $customer_log_data['comment_type'] = 'VERYINTERESTED'; // $customer_log_data['firstReminderDate']=$firstBrushupCallReminderDate; // $customer_log_data['secondReminderDate']=$firstInitialPaymentCallReminderDate; $customer_log_data['reminderDate'] = $firstFinalPaymentCallReminderDate; Comments::addOnebiPaymentComment($customer_log_data); } } } } $paydue_id[] = $paymentDuesResult->id; if ($i == 1) { $order['payment_dues_id'] = $paymentDuesResult->id; $order['order_status'] = "completed"; } } } /* $weeksDues = array("6", "9", "14", "19", "24", "29", "34"); $date = date('Y/m/d', strtotime($reminderStartDate)); foreach($weeksDues as $weeksDue){ $weeks = $weeksDue; // Create and modify the date. $dateTime = DateTime::createFromFormat('Y/m/d', $date); $dateTime->add(DateInterval::createFromDateString($weeks . ' weeks')); //$dateTime->modify('next monday'); // Output the new date. //echo $dateTime->format('Y-m-d')."<br>"; $paymentReminderInput['customerId'] = $inputs['customerId']; $paymentReminderInput['studentId'] = $inputs['studentId']; $paymentReminderInput['seasonId'] = $inputs['SeasonsCbx']; $paymentReminderInput['classId'] = $inputs['eligibleClassesCbx']; $paymentReminderInput['batchId'] = $inputs['batchCbx']; $paymentReminderInput['reminder_date'] = $dateTime->format('Y-m-d'); PaymentReminders::addReminderDates($paymentReminderInput); }*/ } else { if ($inputs['paymentOptionsRadio'] == 'bipay') { $followupFirstDate; $followupSecondDate; $followupThirdDate; $paymentDuesInput['payment_type'] = $inputs['paymentOptionsRadio']; for ($i = 1; $i <= 2; $i++) { if (isset($inputs['bipayAmount' . $i])) { if ($i == 1) { //for bipay enrollment classes $paymentDuesInput['payment_status'] = "paid"; $order['amount'] = $inputs['bipayAmount' . $i]; //$paymentDuesInput['start_order_date']=$studentClasses['enrollment_start_date']; //$startdate= Carbon::create(date('Y,m,d,0', strtotime($inputs['enrollmentStartDate']))); $startdate = Carbon::now(); $enddate = Carbon::now(); $startdate->year = date('Y', strtotime($inputs['enrollmentStartDate'])); $startdate->month = date('m', strtotime($inputs['enrollmentStartDate'])); $startdate->day = date('d', strtotime($inputs['enrollmentStartDate'])); $enddate->year = date('Y', strtotime($inputs['enrollmentEndDate'])); $enddate->month = date('m', strtotime($inputs['enrollmentEndDate'])); $enddate->day = date('d', strtotime($inputs['enrollmentEndDate'])); //return Response::json(array('status'=>'success')); $session_no = $inputs['bipayAmount' . $i] / $eachClassCost; $firstsessionno = $session_no; $batch_schedule_data = BatchSchedule::where('batch_id', '=', $inputs['batchCbx'])->where('schedule_date', '>=', $startdate->toDateString())->where('schedule_date', '<=', $enddate->toDateString())->where('holiday', '!=', 1)->orderBy('id')->get(); $session_no = $session_no - 1; //$startdate=$startdate->addWeeks(($inputs['bipayAmount'.$i]/500)); $paymentDuesInput['start_order_date'] = $batch_schedule_data[0]['schedule_date']; $paymentDuesInput['end_order_date'] = $batch_schedule_data[$session_no]['schedule_date']; $endorderdateforbipay = $batch_schedule_data[count($batch_schedule_data) - 1]['schedule_date']; if ($firstsessionno >= 10) { $followupFirstDate = $batch_schedule_data[$session_no - 2]['schedule_date']; $followupSecondDate = $batch_schedule_data[$session_no - 1]['schedule_date']; $followupThirdDate = $batch_schedule_data[$session_no]['schedule_date']; } else { $followupdate = $batch_schedule_data[$session_no]['schedule_date']; } $paymentDuesInput['discount_amount'] = $inputs['discountPercentage'] / 100 * $inputs['bipayAmount' . $i]; if ($inputs['CustomerType'] == 'OldCustomer') { $paymentDuesInput['created_at'] = date('Y-m-d H:i:s', strtotime($inputs['OrderDate'])); $order['created_at'] = $paymentDuesInput['created_at']; } } else { $paymentDuesInput['start_order_date'] = $batch_schedule_data[$session_no]['schedule_date']; //$startdate=$startdate->addWeeks(($inputs['bipayAmount'.$i]/500)); //$paymentDuesInput['end_order_date']= date('Y-m-d', strtotime($inputs['enrollmentEndDate'])); $paymentDuesInput['end_order_date'] = $endorderdateforbipay; $paymentDuesInput['payment_status'] = "pending"; $paymentDuesInput['discount_amount'] = $inputs['discountPercentage'] / 100 * $inputs['bipayAmount' . $i]; if ($inputs['CustomerType'] == 'OldCustomer' && $inputs['OrderDate2'] != '') { $paymentDuesInput['created_at'] = date('Y-m-d H:i:s', strtotime($inputs['OrderDate2'])); // $order['created_at']=$paymentDuesInput['created_at']; } } $paymentDuesInput['selected_order_sessions'] = $inputs['bipayAmount' . $i] / $eachClassCost; $paymentDuesInput['payment_due_amount'] = $inputs['bipayAmount' . $i]; $paymentDuesInput['discount_applied'] = $inputs['discountPercentage']; $paymentDuesInput['student_class_id'] = $enrollment->id; $paymentDuesResult = PaymentDues::createPaymentDues($paymentDuesInput); if ($i == 1) { $order['payment_dues_id'] = $paymentDuesResult->id; $order['order_status'] = "completed"; $paydueid1 = $paymentDuesResult->id; } if ($i == 2) { if ($firstsessionno >= 10) { // creating customer followup $customer_log_data['customer_id'] = $paymentDuesResult->customer_id; $customer_log_data['student_id'] = $paymentDuesResult->student_id; $customer_log_data['franchisee_id'] = Session::get('franchiseId'); $paydue_id2 = $paymentDuesResult->id; $paymentDuesResult->id = $paydueid1; $customer_log_data['followup_type'] = 'PAYMENT'; $customer_log_data['followup_status'] = 'REMINDER_CALL'; $customer_log_data['comment_type'] = 'VERYINTERESTED'; $customer_log_data['firstReminderDate'] = $followupFirstDate; $customer_log_data['secondReminderDate'] = $followupSecondDate; $customer_log_data['thirdReminderDate'] = $followupThirdDate; $brushupremind = Carbon::now(); $finalremind = Carbon::now(); $brushupremind = $brushupremind->createFromFormat('Y-m-d', $followupFirstDate); $finalremind = $finalremind->createFromFormat('Y-m-d', $followupThirdDate); $today = Carbon::now(); if ($brushupremind->gt($today)) { $payment_followup_data = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data2 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $payment_followup_data3 = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['paymentfollowup_id'] = $payment_followup_data->id; $customer_log_data['paymentfollowup_id2'] = $payment_followup_data2->id; $customer_log_data['paymentfollowup_id3'] = $payment_followup_data3->id; Comments::addPaymentComments($customer_log_data); } else { if ($finalremind->gt($today)) { //create single followup $payment_followup_data = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['customer_id'] = $paymentDuesResult->customer_id; $customer_log_data['student_id'] = $paymentDuesResult->student_id; $customer_log_data['franchisee_id'] = Session::get('franchiseId'); $customer_log_data['paymentfollowup_id'] = $payment_followup_data->id; $customer_log_data['followup_type'] = 'PAYMENT'; $customer_log_data['reminderDate'] = $followupThirdDate; $customer_log_data['followup_status'] = 'REMINDER_CALL'; $customer_log_data['comment_type'] = 'VERYINTERESTED'; Comments::addOnebiPaymentComment($customer_log_data); } } } else { $today = Carbon::now(); $reminddate = Carbon::now(); $reminddate = $reminddate->createFromFormat('Y-m-d', $followupdate); if ($reminddate->gt($today)) { $paymentDuesResult->id = $paydueid1; $payment_followup_data = PaymentFollowups::createPaymentFollowup($paymentDuesResult); $customer_log_data['customer_id'] = $paymentDuesResult->customer_id; $customer_log_data['student_id'] = $paymentDuesResult->student_id; $customer_log_data['franchisee_id'] = Session::get('franchiseId'); $customer_log_data['paymentfollowup_id'] = $payment_followup_data->id; $customer_log_data['followup_type'] = 'PAYMENT'; $customer_log_data['reminderDate'] = $followupdate; $customer_log_data['followup_status'] = 'REMINDER_CALL'; $customer_log_data['comment_type'] = 'VERYINTERESTED'; Comments::addOnebiPaymentComment($customer_log_data); } } } } } // to create payment reminders /* $weeksDues = array("6", "12", "19", "24", "34"); $date = date('Y/m/d', strtotime($reminderStartDate)); foreach($weeksDues as $weeksDue){ $weeks = $weeksDue; // Create and modify the date. $dateTime = DateTime::createFromFormat('Y/m/d', $date); $dateTime->add(DateInterval::createFromDateString($weeks . ' weeks')); //$dateTime->modify('next monday'); // Output the new date. //echo $dateTime->format('Y-m-d')."<br>"; $paymentReminderInput['customerId'] = $inputs['customerId']; $paymentReminderInput['studentId'] = $inputs['studentId']; $paymentDuesInput['seasonId'] =$inputs['SeasonsCbx']; $paymentReminderInput['classId'] = $inputs['eligibleClassesCbx']; $paymentReminderInput['batchId'] = $inputs['batchCbx']; $paymentReminderInput['seasonId'] =$inputs['SeasonsCbx']; $paymentDuesInput['seasonId'] = $inputs['SeasonsCbx']; $paymentReminderInput['reminder_date'] = $dateTime->format('Y-m-d'); PaymentReminders::addReminderDates($paymentReminderInput); } * */ //payment reminders for followups. if ($i == 1) { $order['payment_mode'] = $inputs['paymentTypeRadio']; $order['card_last_digit'] = $inputs['card4digits']; $order['cardType'] = $inputs['card_type']; $order['bank_name'] = $inputs['cardBankName']; $order['receipt_number'] = $inputs['cardRecieptNumber']; } } } } $orderCreated = Orders::createOrder($order); if ($inputs['CustomerType'] == 'OldCustomer' && $inputs['OrderDate2'] != '' && $inputs['paymentOptionsRadio'] == 'bipay') { $payment_due = new PaymentDues(); $payment_due = PaymentDues::find($paydue_id2); $payment_due->payment_status = 'paid'; $payment_due->save(); $order['created_at'] = $paymentDuesInput['created_at']; $order['amount'] = $paymentDuesResult->payment_due_amount - $paymentDuesResult->discount_amount; $order['payment_dues_id'] = $paydue_id2; if ($inputs['paymentTypeRadioOldCustomer2'] == 'cash') { $order['payment_mode'] = 'cash'; $orderCreated = Orders::createOrder($order); } elseif ($inputs['paymentTypeRadioOldCustomer2'] == 'cheque') { $order['payment_mode'] = 'cheque'; $order['bank_name'] = $inputs['bankName2']; $order['cheque_number'] = $inputs['chequeNumber2']; $orderCreated = Orders::createOrder($order); } elseif ($inputs['paymentTypeRadioOldCustomer2'] == 'card') { $order['payment_mode'] = 'card'; $order['card_type'] = $inputs['cardType2']; $order['card_last_digit'] = $inputs['card4digits2']; $order['bank_name'] = $inputs['cardBankName2']; $order['receipt_number'] = $inputs['cardRecieptNumber2']; $orderCreated = Orders::createOrder($order); } } if ($inputs['CustomerType'] == 'OldCustomer' && $inputs['OrderDate2'] != '' && $inputs['paymentOptionsRadio'] == 'multipay') { $paydue_data = PaymentDues::where('id', '=', $paydue_id[1])->get(); $paydue_data = $paydue_data[0]; $neworder = new Orders(); $neworder['customer_id'] = $paydue_data['customer_id']; $neworder['student_id'] = $paydue_data['student_id']; $neworder['season_id'] = $paydue_data['season_id']; $neworder['student_classes_id'] = $paydue_data['student_class_id']; $neworder['payment_for'] = "enrollment"; $neworder['payment_dues_id'] = $paydue_id[1]; $neworder['amount'] = $paydue_data['payment_due_amount']; $neworder['order_status'] = "completed"; if ($inputs['paymentTypeRadioOldCustomer2'] == 'cash') { $neworder['payment_mode'] = 'cash'; } else { if ($inputs['paymentTypeRadioOldCustomer2'] == 'cheque') { $neworder['payment_mode'] = 'cheque'; $neworder['bank_name'] = $inputs['bankName2']; $neworder['cheque_number'] = $inputs['chequeNumber2']; } else { if ($inputs['paymentTypeRadioOldCustomer2'] == 'card') { $neworder['payment_mode'] = 'card'; $neworder['card_type'] = $inputs['cardType2']; $neworder['card_last_digit'] = $inputs['card4digits2']; $neworder['bank_name'] = $inputs['cardBankName2']; $neworder['receipt_number'] = $inputs['cardRecieptNumber2']; } } } $neworder['created_at'] = $paydue_data['created_at']; $neworder->created_by = Session::get('userId'); $neworder->save(); } if ($inputs['CustomerType'] == 'OldCustomer' && $inputs['OrderDate3'] != '' && $inputs['paymentOptionsRadio'] == 'multipay') { $paydue_data = PaymentDues::where('id', '=', $paydue_id[2])->get(); $paydue_data = $paydue_data[0]; $neworder = new Orders(); $neworder['customer_id'] = $paydue_data['customer_id']; $neworder['student_id'] = $paydue_data['student_id']; $neworder['season_id'] = $paydue_data['season_id']; $neworder['student_classes_id'] = $paydue_data['student_class_id']; $neworder['payment_for'] = "enrollment"; $neworder['payment_dues_id'] = $paydue_id[2]; $neworder['amount'] = $paydue_data['payment_due_amount']; $neworder['order_status'] = "completed"; if ($inputs['paymentTypeRadioOldCustomer3'] == 'cash') { $neworder['payment_mode'] = 'cash'; } else { if ($inputs['paymentTypeRadioOldCustomer3'] == 'cheque') { $neworder['payment_mode'] = 'cheque'; $neworder['bank_name'] = $inputs['bankName3']; $neworder['cheque_number'] = $inputs['chequeNumber3']; } else { if ($inputs['paymentTypeRadioOldCustomer3'] == 'card') { $neworder['payment_mode'] = 'card'; $neworder['card_type'] = $inputs['cardType3']; $neworder['card_last_digit'] = $inputs['card4digits3']; $neworder['bank_name'] = $inputs['cardBankName3']; $neworder['receipt_number'] = $inputs['cardRecieptNumber3']; } } } $neworder['created_at'] = $paydue_data['created_at']; $neworder->created_by = Session::get('userId'); $neworder->save(); } if ($inputs['CustomerType'] == 'OldCustomer' && $inputs['OrderDate4'] != '' && $inputs['paymentOptionsRadio'] == 'multipay') { $paydue_data = PaymentDues::where('id', '=', $paydue_id[3])->get(); $paydue_data = $paydue_data[0]; $neworder = new Orders(); $neworder['customer_id'] = $paydue_data['customer_id']; $neworder['student_id'] = $paydue_data['student_id']; $neworder['season_id'] = $paydue_data['season_id']; $neworder['student_classes_id'] = $paydue_data['student_class_id']; $neworder['payment_for'] = "enrollment"; $neworder['payment_dues_id'] = $paydue_id[3]; $neworder['amount'] = $paydue_data['payment_due_amount']; $neworder['order_status'] = "completed"; if ($inputs['paymentTypeRadioOldCustomer4'] == 'cash') { $neworder['payment_mode'] = 'cash'; } else { if ($inputs['paymentTypeRadioOldCustomer4'] == 'cheque') { $neworder['payment_mode'] = 'cheque'; $neworder['bank_name'] = $inputs['bankName4']; $neworder['cheque_number'] = $inputs['chequeNumber4']; } else { if ($inputs['paymentTypeRadioOldCustomer4'] == 'card') { $neworder['payment_mode'] = 'card'; $neworder['card_type'] = $inputs['cardType4']; $neworder['card_last_digit'] = $inputs['card4digits4']; $neworder['bank_name'] = $inputs['cardBankName4']; $neworder['receipt_number'] = $inputs['cardRecieptNumber4']; } } } $neworder['created_at'] = $paydue_data['created_at']; $neworder->created_by = Session::get('userId'); $neworder->save(); } if (isset($inputs['membershipType'])) { $membershipInputs['customer_id'] = $inputs['customerId']; $membershipInputs['membership_type_id'] = $inputs['membershipType']; CustomerMembership::addMembership($membershipInputs); } $student = Students::with('Customers', 'StudentClasses')->where('id', '=', $enrollment->student_id)->get(); $class = Classes::where('id', '=', $enrollment->class_id)->get(); $CustomerObject = Customers::find($inputs['customerId']); $CustomerObject->stage = "ENROLLED"; $CustomerObject->save(); $customer = array(); $customer['customerName'] = $student['0']->Customers->customer_name; $customer['customerEmail'] = $student['0']->Customers->customer_email; $customer['kidName'] = $student['0']->student_name; $customer['className'] = $class['0']->class_name; $commentsInput['customerId'] = $inputs['customerId']; $commentsInput['commentText'] = Config::get('constants.ENROLLED') . ' for ' . $class['0']->class_name; $commentsInput['commentType'] = 'FOLLOW_UP'; $commentsInput['reminderDate'] = null; Comments::addComments($commentsInput); if (isset($inputs['emailOption']) && $inputs['emailOption'] == 'yes') { $orders = Orders::with('Customers', 'Students', 'StudentClasses')->where('id', '=', $orderCreated->id)->get(); $orders = $orders['0']; $paymentDues = PaymentDues::where('id', '=', $orders->payment_dues_id)->get(); $batchDetails = Batches::where('id', '=', $orders->StudentClasses->batch_id)->get(); $class = Classes::where('id', '=', $orders->StudentClasses->class_id)->where('franchisee_id', '=', Session::get('franchiseId'))->first(); $customerMembership = CustomerMembership::getCustomerMembership($orders->customer_id); $class = Classes::where('id', '=', $inputs['eligibleClassesCbx'])->where('franchisee_id', '=', Session::get('franchiseId'))->first(); $batch = Batches::where('id', '=', $inputs['batchCbx'])->first(); $orderDetailsTomail['orders'] = $orders; $orderDetailsTomail['customers'] = $customer; $orderDetailsTomail['paymentDues'] = $paymentDues; $orderDetailsTomail['customerMembership'] = $customerMembership; $orderDetailsTomail['class'] = $class; $orderDetailsTomail['batchDetails'] = $batchDetails; $orderDetailsTomail['studentbatch']['start_date'] = date('Y-m-d', strtotime($inputs['enrollmentStartDate'])); $orderDetailsTomail['studentbatch']['end_date'] = date('Y-m-d', strtotime($inputs['enrollmentEndDate'])); $orderDetailsTomail['customers']['customerMembership'] = CustomerMembership::getCustomerMembership($orders->customer_id); Mail::send('emails.account.enrollment', $orderDetailsTomail, function ($msg) use($orderDetailsTomail) { $msg->from(Config::get('constants.EMAIL_ID'), Config::get('constants.EMAIL_NAME')); $msg->to($orderDetailsTomail['customers']['customerEmail'], $orderDetailsTomail['customers']['customerName'])->subject('The Little Gym - Kids Enrollment Successful'); }); } if (isset($inputs['invoicePrintOption']) && $inputs['invoicePrintOption'] == 'yes') { $printUrl = url() . '/orders/print/' . Crypt::encrypt($orderCreated->id); } else { $printUrl = ""; } //header('Access-Control-Allow-Origin: *'); if ($enrollment) { return Response::json(array("status" => "success", "printUrl" => $printUrl)); } else { return Response::json(array("status" => "failed")); } }
public function actionKindCreate() { $model = new Expense(); $dates = date('Y-m-d H:i:s'); if (isset($_POST['product'])) { $transaction = Yii::app()->db->beginTransaction(); try { $messageType = 'warning'; $message = "There are some errors "; $model->order_date = $dates; $model->employee_id = 1; $model->table = 0; $model->status = 0; $model->kind = 1; //$uploadFile=CUploadedFile::getInstance($model,'filename'); if ($model->save()) { $messageType = 'success'; $message = "<strong>Well done!</strong> You successfully create data "; foreach ($_POST['product']['id'] as $key => $value) { $newModel = new Orders(); $newModel->expense_id = $model->expense_id; $newModel->just_id = $value; $newModel->type = 3; $newModel->count = $_POST['product']['count'][$key]; $newModel->save(); } $transaction->commit(); Yii::app()->user->setFlash($messageType, $message); //$this->redirect(array('create')); } } catch (Exception $e) { $transaction->rollBack(); Yii::app()->user->setFlash('error', "{$e->getMessage()}"); //$this->refresh(); } } $this->render('kindCreate', array('model' => $model)); }
public function actionSubmit() { $incart = $this->getUserState('cart', 'incart'); $order_list = '<b>Заказ:</b>'; $order_list .= '<table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse;">'; $order_list .= '<tr>'; $order_list .= '<td>Артикул</td>'; $order_list .= '<td>Наименование</td>'; $order_list .= '<td>Стоимость</td>'; $order_list .= '<td>Кол-во</td>'; $order_list .= '<td>Сумма</td>'; $order_list .= '</tr>'; foreach ($incart as $k => $v) { $order_list .= '<tr>'; $order_list .= '<td>' . $v['tovar']->art . '</td>'; $order_list .= '<td>' . $v['tovar']->name . '</td>'; $order_list .= '<td>' . $v['tovar']->getPrice() . '</td>'; $order_list .= '<td>' . $v['n'] . '</td>'; $order_list .= '<td>' . $v['summ'] . '</td>'; $order_list .= '</tr>'; } $order_list .= '<tr>'; $order_list .= '<td colspan="7" align="right">Итого: ' . $this->getUserState('cart', 'summ') . ' руб.</td>'; $order_list .= '</tr>'; $order_list .= '</table>'; /***** Привещите посмотреть ****/ $wishlist = Yii::app()->user->getState('wishlist'); if ($wishlist) { $order_list .= '<br /><b>Привезите посмотреть:</b>'; foreach ($wishlist as $k => $v) { $order_list .= '<div>' . $v->art . ', ' . $v->name . '</div>'; } } $order = new Orders(); $order->attributes = $_POST['Orders']; $order->date = date('Y-m-d H:i:s'); $order->order_list = $order_list; $order->summ = $this->getUserState('cart', 'summ'); $order_list .= '<br /><b>Ваши данные:</b>'; $order_list .= '<div>ФИО: ' . $order->name . '</div>'; $order_list .= '<div>E-mail: ' . $order->email . '</div>'; $order_list .= '<div>Телефон: ' . $order->phone . '</div>'; if ($order->address) { $order_list .= '<div>Адрес: ' . $order->address . '</div>'; } if ($order->text) { $order_list .= '<div>Примечание: ' . $order->text . '</div>'; } $order_list .= '<br /><div><b>Спасибо за заказ. Наши менеджеры свяжутся с вами вближайшее время.</b></div>'; $order_list .= '<br />----'; $order_list .= '<div>С уважением, Optoffka.</div>'; if ($order->save()) { Yii::app()->user->setState('cart', ''); Yii::app()->user->setState('wishlist', ''); Yii::app()->user->setFlash('message', 'Спасибо за заказ! Наш менеджер свяжется с Вами в ближайшее время.'); $mailer = Yii::app()->mailer; $mailer->CharSet = 'UTF-8'; $mailer->IsHTML(true); $mailer->From = $order->email; $mailer->FromName = 'OPTOFFKA'; $mailer->AddReplyTo('*****@*****.**'); $mailer->AddAddress($order->email); $mailer->AddBCC($this->getConfig('email')); $mailer->Subject = 'Заказ на сайте Optoffka.ru'; $mailer->Body = $order_list; $mailer->Send(); $this->redirect('/cart/'); } else { exit(var_dump($order->getErrors())); } }
/** * * @param Customer $cust * @param $ordersInfo * @throws Exception * @return Orders */ public function saveOrders(Customer $cust, $ordersInfo) { $currentOrder = new Orders(); $currentOrder->customer_id = $cust->id; $currentOrder->sub_total = @$ordersInfo['orderInformation']['sub_total']; $currentOrder->tax = @$ordersInfo['orderInformation']['tax']; $currentOrder->shipping_amt = @$ordersInfo['orderInformation']['shipping']; $currentOrder->total_amt = @$ordersInfo['orderInformation']['total']; $currentOrder->paid = @$ordersInfo['orderInformation']['paid']; $currentOrder->sales_person = @$ordersInfo['orderInformation']['sales_person']; $currentOrder->invoice_number = @$ordersInfo['orderInformation']['invoice_number']; $_shippingAddress = sprintf("%s , %s ,%s , %s", $ordersInfo['shippingAddress']['shipping_address_street'], $ordersInfo['shippingAddress']['shipping_address_city'], $ordersInfo['shippingAddress']['shipping_address_province'], $ordersInfo['shippingAddress']['shipping_address_country']); $currentOrder->shipping_address = $_shippingAddress; $currentOrder->note = $ordersInfo['orderInformation']['notes']; $shippingDateObj = strtotime($ordersInfo['orderInformation']['ship_date']); $currentOrder->ship_date = date("Y-m-d H:i:s", $shippingDateObj); $orderDateObj = strtotime($ordersInfo['orderInformation']['order_date']); $currentOrder->order_date = date("Y-m-d H:i:s", $orderDateObj); if (!$currentOrder->save()) { throw new Exception("Failed to save current order. Reason : " . CHtml::errorSummary($currentOrder)); } return $currentOrder; }
public function testSumReportThisMonth() { $this->totalPaid = 0; foreach (range(0, 6) as $key => $value) { /*insert 5 orders row*/ $newOrder = new Orders(); $newOrder->paid = 5000.0; $newOrder->order_date = (string) Carbon::parse('wednesday last week'); if ($newOrder->save(false)) { $this->totalPaid += doubleval($newOrder->paid); } } foreach (range(0, 5) as $key => $value) { /*insert 5 orders row*/ $newOrder = new Orders(); $newOrder->paid = 5000.0; $newOrder->order_date = date("Y-m-d H:i:s"); if ($newOrder->save(false)) { $this->totalPaid += doubleval($newOrder->paid); $this->insertedOrders[] = $newOrder; } } $sumReporter = new SumReportFetcher(); $firstDayOfMonth = Carbon::parse('first day of this month'); $lastDayOfMonth = Carbon::parse('last day of this month'); $tempContainer = $sumReporter->getSumReport((string) $firstDayOfMonth, (string) $lastDayOfMonth); $tempContainer = doubleval($tempContainer); $this->assertEquals($tempContainer, $this->totalPaid, "Asserting that the total for this month is equal to my calculated total this month. "); }
$order = Orders::model()->find($criteria); $stopVanha = ''; if (isset($order->id) and date("Ymd", strtotime($order->stop)) > date("Ymd")) { $start = date("Y-m-d", strtotime($order->stop)); } $model = new Orders(); $model->user_id = Yii::app()->user->id; $model->period = $_POST['period']; $model->status = 0; $model->sahkoposti = $sahkoposti; $model->start = $start; $model->alennus_prosentti = $_POST['alennus']; $model->hinta = $_POST['amount']; $model->koodi = Yii::app()->user->id . $koodi; $model->stop = date("Y-m-d", strtotime($start . " +" . $_POST['period'] . " day")); if ($model->save()) { $tilaus = $model->id; $prep = "{$kauppiasvarmenne}|{$MERCHANT_ID}|{$summa}|{$tilaus}||{$DESCRIPTION}|EUR|{$success}|{$cancel}||{$notify}|S1|fi_FI||1||"; $auth = md5($prep); $auth = strtoupper($auth); Orders::model()->updatebypk($model->id, array('authcode' => $auth)); } else { $bod .= 'Ei onnistu'; exit; } } else { $bod .= 'Virhe! Tunnukset eivät täsmää!'; exit; } $bod .= ' <div class="alert alert-danger">
public function createOrder() { $order_create = new Logger('OrderCreation'); $response = array(); $output = array(); try { $order = new Orders(); if (!Input::has('user_id') || !Input::has('items')) { /* * There shd be a single class which handles all this. */ $response['response_code'] = ResponseCodes::$response_code['missing_param']['code']; $response['response_message'] = ResponseCodes::$response_code['missing_param']['response_message']; echo json_encode($response); die; } // Save the order to the database $order->status = AppConstants::$avialable_status['created']; // the user id is assumed to be a part of the request. // Ideally it shouldn't be.The server shd be able to identify the user based on session id or token or any other method $order->user_id = Input::get('user_id'); $order->save(); /* * While saving items we assume that we are getting a json encoded data for the list of item. * like this [{"name":"shirt","quantity":"2"},{"name":"saree","quantity":"2"}] * with the product name and the quanity.Each item added belongs to a specific type which has a fixed price whc are intrenally mapped */ $list_of_items = json_decode(Input::get('items'), true); foreach ($list_of_items as $key => $item_data) { $item = new Items(); $item->order_id = $order->id; $item->name = $item_data['name']; $item->quantity = $item_data['quantity']; // assuming the item type is correct. $item->price = Price::$price_mapping[$item_data['name']] * $item_data['quantity']; $item->save(); } $output['order_id'] = $order->id; $response['response_code'] = ResponseCodes::$response_code['success']['code']; $response['response_message'] = ResponseCodes::$response_code['success']['response_message']; $response['output'] = $output; echo json_encode($response); } catch (Exception $e) { Log::error($e->getMessage()); $order_create->addInfo($e->getMessage()); $response['response_code'] = ResponseCodes::$response_code['internal_server_error']['code']; $response['response_message'] = ResponseCodes::$response_code['internal_server_error']['response_message']; $response['output'] = $output; echo json_encode($response); } }
public function actionUpdate($id) { $menuModel = Dishtype::model()->findAll('t.parent = :parent', array(':parent' => 0)); $updateDish = Expense::model()->with('order.dish', 'employee')->findByPk($id); $updateStuff = Expense::model()->with('order.halfstuff', 'employee')->findByPk($id); $updateProd = Expense::model()->with('order.products', 'employee')->findByPk($id); if (!empty($updateDish)) { $empId = $updateDish->employee_id; $table = $updateDish->table; $status = $updateDish->debt; } if (!empty($updateStuff)) { $empId = $updateStuff->employee_id; $table = $updateStuff->table; $status = $updateStuff->debt; } if (!empty($updateProd)) { $empId = $updateProd->employee_id; $table = $updateProd->table; $status = $updateProd->debt; } $orders = new Orders(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['expense_id'])) { $model = Expense::model()->findByPk($_POST['expense_id']); $_POST['Expense']['order_date'] = date('Y-m-d H:i:s'); if (isset($_POST['debt'])) { if ($_POST['debt'] == 1) { $_POST['status'] = 1; } } else { $_POST['debt'] = 0; $_POST['status'] = 0; } $transaction = Yii::app()->db->beginTransaction(); try { $archive = new ArchiveOrder(); $archive_message = ''; $messageType = 'warning'; $message = "There are some errors "; $model->table = $_POST['table']; $model->employee_id = $_POST['employee_id']; $model->status = $_POST['status']; $model->debt = $_POST['debt']; $model->comment = $_POST['comment']; if ($model->save()) { $orders->model()->deleteAll('expense_id = :expId', array(':expId' => $_POST['expense_id'])); $messageType = 'success'; $message = "<strong>Well done!</strong> You successfully create data "; if (isset($_POST['dish'])) { $archive_message .= '*dish=>'; foreach ($_POST['dish']['id'] as $key => $val) { $prodModel = new Orders(); $prodModel->expense_id = $_POST['expense_id']; $prodModel->just_id = $val; $prodModel->type = 1; $prodModel->count = $this->changeToFloat($_POST['dish']['count'][$key]); $prodModel->save(); $archive_message .= $val . ":" . $this->changeToFloat($_POST['dish']['count'][$key]) . ","; } } if (isset($_POST['stuff'])) { $archive_message .= '*stuff=>'; foreach ($_POST['stuff']['id'] as $key => $val) { $prodModel = new Orders(); $prodModel->expense_id = $_POST['expense_id']; $prodModel->just_id = $val; $prodModel->type = 2; $prodModel->count = $this->changeToFloat($_POST['stuff']['count'][$key]); $prodModel->save(); $archive_message .= $val . ":" . $this->changeToFloat($_POST['stuff']['count'][$key]) . ","; } } if (isset($_POST['product'])) { $archive_message .= '*prod=>'; foreach ($_POST['product']['id'] as $key => $val) { $prodModel = new Orders(); $prodModel->expense_id = $_POST['expense_id']; $prodModel->just_id = $val; $prodModel->type = 3; $prodModel->count = $this->changeToFloat($_POST['product']['count'][$key]); $prodModel->save(); $archive_message .= $val . ":" . $this->changeToFloat($_POST['product']['count'][$key]) . ","; } } $archive->setArchive('update', $model->expense_id, $archive_message); $transaction->commit(); Yii::app()->user->setFlash($messageType, $message); //$this->redirect(array('view','id'=>$model->expense_id)); } } catch (Exception $e) { $transaction->rollBack(); Yii::app()->user->setFlash('error', "{$e->getMessage()}"); //$this->refresh(); } } $this->render('update', array('model' => $model, 'menuModel' => $menuModel, 'updateDish' => $updateDish, 'updateStuff' => $updateStuff, 'updateProd' => $updateProd, 'empId' => $empId, 'table' => $table, 'debt' => $status, 'expense_id' => $id)); }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionImport() { $model = new Orders(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Orders'])) { if (!empty($_FILES)) { $tempFile = $_FILES['Orders']['tmp_name']['fileImport']; $fileTypes = array('xls', 'xlsx'); // File extensions $fileParts = pathinfo($_FILES['Orders']['name']['fileImport']); if (in_array(@$fileParts['extension'], $fileTypes)) { Yii::import('ext.heart.excel.EHeartExcel', true); EHeartExcel::init(); $inputFileType = PHPExcel_IOFactory::identify($tempFile); $objReader = PHPExcel_IOFactory::createReader($inputFileType); $objPHPExcel = $objReader->load($tempFile); $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true); $baseRow = 2; $inserted = 0; $read_status = false; while (!empty($sheetData[$baseRow]['A'])) { $read_status = true; //$order_id= $sheetData[$baseRow]['A']; $expense_id = $sheetData[$baseRow]['B']; $just_id = $sheetData[$baseRow]['C']; $type = $sheetData[$baseRow]['D']; $count = $sheetData[$baseRow]['E']; $table_id = $sheetData[$baseRow]['F']; $model2 = new Orders(); //$model2->order_id= $order_id; $model2->expense_id = $expense_id; $model2->just_id = $just_id; $model2->type = $type; $model2->count = $count; $model2->table_id = $table_id; try { if ($model2->save()) { $inserted++; } } catch (Exception $e) { Yii::app()->user->setFlash('error', "{$e->getMessage()}"); //$this->refresh(); } $baseRow++; } Yii::app()->user->setFlash('success', $inserted . ' row inserted'); } else { Yii::app()->user->setFlash('warning', 'Wrong file type (xlsx, xls, and ods only)'); } } $this->render('admin', array('model' => $model)); } else { $this->render('admin', array('model' => $model)); } }