/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Sandwiches the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Sandwiches::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function actionCustomerReply() { if (isset($_POST['customer']) && isset($_POST['customer']['ajax'])) { // echo $_POST['customer']['provisional_date']; // print_r($_POST['customer']); // $customer_questions = $this->loadModel(getCurCusId()); $customer_questions = $this->loadModel(getCurCusId()); $customer_questions->provisional_date = isset($_POST['customer']['provisional_date']) ? $_POST['customer']['provisional_date'] : ""; $customer_questions->call_date = isset($_POST['customer']['call_date']) ? $_POST['customer']['call_date'] : ""; // mErrors($customer_questions); $customer_questions->save(); echo json_encode(array('success' => 1)); exit; } // $magic_spoon = MagicSpool::model()->findByAttributes(array('cus_id' => getCurCusId())); // $magic_spoon = MagicSpool::model()->find()->findByAttributes(array('cus_id' => getCurCusId())); $magic_spoon = MagicSpool::model()->findAll(array('select' => 'one,two,three,four,five', 'condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => getCurCusId()))); $lunch_count = Lunch::model()->count(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => getCurCusId()))); $break_count = Breakfast::model()->count(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => getCurCusId()))); $hotf_count = HotFood::model()->count(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => getCurCusId()))); $sandw_count = Sandwiches::model()->count(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => getCurCusId()))); $sundr_count = Sundries::model()->count(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => getCurCusId()))); $IndusFood_count = IndusFood::model()->count(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => getCurCusId()))); $customer = Customer::model()->findByPk(getCurCusId()); $criteria = new CDbCriteria(); $criteria->select = 't.name,t.desc'; $ee1 = explode(',', $customer->sel_products); $criteria->addInCondition('id', $ee1); $selProdt = Product::model()->findAll($criteria); $this->render('customerreply', array('magic_spoon' => $magic_spoon, 'lunch_count' => $lunch_count, 'break_count' => $break_count, 'hotf_count' => $hotf_count, 'sandw_count' => $sandw_count, 'sundr_count' => $sundr_count, 'indusFood_count' => $IndusFood_count, 'selProdt' => $selProdt)); }
public function actionAdminSolns1() { if (isset($_GET['id'])) { $id = intval($_GET['id']); $curUser = Customer::model()->findByPk($id); if (empty($curUser->id)) { throw new CHttpException(403, 'Customer Does\'t exists'); } Yii::app()->session['last_created_user'] = $curUser->attributes; } $cust = Customer::model()->findAll(array('condition' => 'id=:id ', 'params' => array(':id' => getCurCusId()))); $selProd = SelProducts::model()->findAll(array("condition" => "cus_id =" . getCurCusId(), "order" => "product_id asc")); $selData = CHtml::listData($selProd, 'id', 'product_id'); $criteria = new CDbCriteria(); $criteria->addInCondition('id', $selData); $selproducts = Product::model()->findAll($criteria); foreach ($cust as $k => $val) { $magicSpools = $val->magicSpools; $magicSpoolsAns = $val->magicSpoolsAns; $notes = $val->notes; $workingWells = $val->workingWells; $hotFoods = $val->hotFoods; $lunches = $val->lunches; $breakfasts = $val->breakfasts; $sundries = $val->sundries; $indusFoods = $val->indusFoods; $sandwiches = $val->sandwiches; } if (isset($_POST['ajax']) && $_POST['ajax'] == 1) { $cust[0]->unable_to_commit = $_POST['final_comment']; $cust[0]->save(); if (count($magicSpools)) { $mspoon = MagicSpoolAns::model()->findByAttributes(array('cus_id' => getCurCusId())); if ($mspoon === NULL) { $mspoon = new MagicSpoolAns(); $mspoon->cus_id = getCurCusId(); } $mspoon->one = isset($_POST['one']) ? $_POST['one'] : ""; $mspoon->two = isset($_POST['two']) ? $_POST['two'] : ""; $mspoon->three = isset($_POST['three']) ? $_POST['three'] : ""; $mspoon->four = isset($_POST['four']) ? $_POST['four'] : ""; $mspoon->five = isset($_POST['five']) ? $_POST['five'] : ""; $mspoon->one_comment = isset($_POST['magicspools']['one']['comment']) ? $_POST['magicspools']['one']['comment'] : ""; $mspoon->two_comment = isset($_POST['magicspools']['two']['comment']) ? $_POST['magicspools']['two']['comment'] : ""; $mspoon->three_comment = isset($_POST['magicspools']['three']['comment']) ? $_POST['magicspools']['three']['comment'] : ""; $mspoon->four_comment = isset($_POST['magicspools']['four']['comment']) ? $_POST['magicspools']['four']['comment'] : ""; $mspoon->five_comment = isset($_POST['magicspools']['five']['comment']) ? $_POST['magicspools']['five']['comment'] : ""; $mspoon->one_like = isset($_POST['magicspools']['one']['like']) ? intval($_POST['magicspools']['one']['like']) : "0"; $mspoon->two_like = isset($_POST['magicspools']['two']['like']) ? intval($_POST['magicspools']['two']['like']) : "0"; $mspoon->three_like = isset($_POST['magicspools']['three']['like']) ? intval($_POST['magicspools']['three']['like']) : "0"; $mspoon->four_like = isset($_POST['magicspools']['four']['like']) ? intval($_POST['magicspools']['four']['like']) : "0"; $mspoon->five_like = isset($_POST['magicspools']['five']['like']) ? intval($_POST['magicspools']['five']['like']) : "0"; // p($_POST['magicspools']); // exit; $mspoon->save(); } if (isset($_POST['hotFoods'])) { if (isset($_POST['hotFoods']['ans'])) { foreach ($_POST['hotFoods']['ans'] as $ans) { // p($ans); $model = HotFood::model()->findByPk(intval($ans['pro'])); $model->ans = $ans['comment']; $model->menu_name = $ans['menuname']; $model->price_per_head_f = $ans['price_per_head_pound']; $model->whats_included = $ans['whats_included']; if (isset($ans['like'])) { $model->like = $ans['like']; } if (isset($ans['cus_comment'])) { $model->comment = $ans['cus_comment']; } $model->save(); } } } if (isset($_POST['sandwiches'])) { if (isset($_POST['sandwiches']['ans'])) { foreach ($_POST['sandwiches']['ans'] as $ans) { $model = Sandwiches::model()->findByPk(intval($ans['pro'])); $model->ans = $ans['comment']; $model->menu_name = $ans['menuname']; $model->price_per_head_f = $ans['price_per_head_pound']; $model->whats_included = $ans['whats_included']; if (isset($ans['like'])) { $model->like = $ans['like']; } if (isset($ans['cus_comment'])) { $model->comment = $ans['cus_comment']; } $model->save(); } } } if (isset($_POST['breakfasts'])) { if (isset($_POST['breakfasts']['ans'])) { foreach ($_POST['breakfasts']['ans'] as $ans) { $model = Breakfast::model()->findByPk(intval($ans['pro'])); $model->ans = $ans['comment']; $model->menu_name = $ans['menuname']; $model->price_per_head_f = $ans['price_per_head_pound']; $model->whats_included = $ans['whats_included']; if (isset($ans['like'])) { $model->like = $ans['like']; } if (isset($ans['cus_comment'])) { $model->comment = $ans['cus_comment']; } // p($model->attributes); $model->save(); } } } if (isset($_POST['indusFoods'])) { if (isset($_POST['indusFoods']['ans'])) { foreach ($_POST['indusFoods']['ans'] as $ans) { $model = IndusFood::model()->findByPk(intval($ans['pro'])); $model->ans = $ans['comment']; $model->menu_name = $ans['menuname']; $model->price_per_head_f = $ans['price_per_head_pound']; $model->whats_included = $ans['whats_included']; if (isset($ans['like'])) { $model->like = $ans['like']; } if (isset($ans['cus_comment'])) { $model->comment = $ans['cus_comment']; } $model->save(); } } } if (isset($_POST['lunch'])) { if (isset($_POST['lunch']['ans'])) { foreach ($_POST['lunch']['ans'] as $ans) { $model = Lunch::model()->findByPk(intval($ans['pro'])); $model->ans = $ans['comment']; $model->menu_name = $ans['menuname']; $model->price_per_head_f = $ans['price_per_head_pound']; $model->whats_included = $ans['whats_included']; if (isset($ans['like'])) { $model->like = $ans['like']; } if (isset($ans['cus_comment'])) { $model->comment = $ans['cus_comment']; } // p($model->attributes); $model->save(); } } } if (isset($_POST['sundries'])) { // $model = Sundries::model()->findByPk($sundries[0]->id); // if ($model !== null) { // $model->ans = (isset($_POST['sundries']['ans']) ? $_POST['sundries']['ans'] : ""); // $model->comment = (isset($_POST['sundries']['comment']) ? $_POST['sundries']['comment'] : ""); // $model->save(); // } if (isset($_POST['sundries']['ans'])) { foreach ($_POST['sundries']['ans'] as $ans) { $model = Sundries::model()->findByPk(intval($ans['pro'])); $model->ans = $ans['comment']; $model->menu_name = $ans['menuname']; $model->price_per_head_f = $ans['price_per_head_pound']; $model->whats_included = $ans['whats_included']; if (isset($ans['like'])) { $model->like = $ans['like']; } if (isset($ans['cus_comment'])) { $model->comment = $ans['cus_comment']; } $model->save(); } } } if (isset($_POST['selproduct']['ans'])) { foreach ($_POST['selproduct']['ans'] as $ans) { $selProd = SelProducts::model()->findByPk($ans['pro']); if ($selProd) { $selProd->menu_name = $ans['menuname']; $selProd->price_per_head_f = $ans['price_per_head_pound']; $selProd->ans = $ans['comment']; $selProd->whats_included = $ans['whats_included']; $selProd->save(); } } } if (isset($_POST['selprod'])) { foreach ($_POST['selprod'] as $comment) { $selProd = SelProducts::model()->findByPk(intval($comment['id'])); $selProd->comment = $comment['comment']; $selProd->like = $comment['like']; $selProd->save(); } } echo json_encode(array('success' => '1')); exit; } $lunch_note = ""; $breakfast_note = ""; $sandwiches_note = ""; $hotfood_note = ""; $indusfood_note = ""; $sundries_note = ""; // e($notes); foreach ($notes as $value => $kval) { // print_r($kval); if ($kval['form'] == 'lunch') { $lunch_note = $kval['text']; } if ($kval['form'] == 'breakfast') { $breakfast_note = $kval['text']; } if ($kval['form'] == 'sandwiches') { $sandwiches_note = $kval['text']; } if ($kval['form'] == 'hotfood') { $hotfood_note = $kval['text']; } if ($kval['form'] == 'indusfood') { $indusfood_note = $kval['text']; } if ($kval['form'] == "sundries") { $sundries_note = $kval['text']; } if ($kval['form'] == 'magicspoon') { $mspoon_note = $kval['text']; } } $this->render('adminsolns_pdf', array('customer' => $cust, 'magic_spools' => $magicSpools, 'magicSpoolsAns' => $magicSpoolsAns, 'notes' => $notes, 'workingWells' => $workingWells, 'sundries' => $sundries, 'lunches' => $lunches, 'indusFoods' => $indusFoods, 'breakfasts' => $breakfasts, 'sandwiches' => $sandwiches, 'hotFoods' => $hotFoods, 'sundries_note' => $sundries_note, 'lunch_note' => $lunch_note, 'indusfood_note' => $indusfood_note, 'breakfast_note' => $breakfast_note, 'sandwiches_note' => $sandwiches_note, 'hotfood_note' => $hotfood_note, 'selproducts' => $selproducts, 'selproductsComment' => $selProd)); }
public function actionAdminSolns() { $cust = Customer::model()->findAll(array('condition' => 'id=:id ', 'params' => array(':id' => getCurCusId()))); foreach ($cust as $k => $val) { $magicSpools = $val->magicSpools; $notes = $val->notes; $workingWells = $val->workingWells; $hotFoods = $val->hotFoods; $lunches = $val->lunches; $breakfasts = $val->breakfasts; $sundries = $val->sundries; $indusFoods = $val->indusFoods; $sandwiches = $val->sandwiches; } if (isset($_POST['ajax']) && $_POST['ajax'] == 1) { if (count($magicSpools)) { //getCurCusId() $mspoon = MagicSpoolAns::model()->findByAttributes(array('cus_id' => getCurCusId())); if ($mspoon === NULL) { $mspoon = new MagicSpoolAns(); $mspoon->cus_id = getCurCusId(); } $mspoon->one = isset($_POST['one']) ? $_POST['one'] : ""; $mspoon->two = isset($_POST['two']) ? $_POST['two'] : ""; $mspoon->three = isset($_POST['three']) ? $_POST['three'] : ""; $mspoon->four = isset($_POST['four']) ? $_POST['four'] : ""; $mspoon->five = isset($_POST['five']) ? $_POST['five'] : ""; $mspoon->one_comment = isset($_POST['magicspools']['one']['comment']) ? $_POST['magicspools']['one']['comment'] : ""; $mspoon->two_comment = isset($_POST['magicspools']['two']['comment']) ? $_POST['magicspools']['two']['comment'] : ""; $mspoon->three_comment = isset($_POST['magicspools']['three']['comment']) ? $_POST['magicspools']['three']['comment'] : ""; $mspoon->four_comment = isset($_POST['magicspools']['four']['comment']) ? $_POST['magicspools']['four']['comment'] : ""; $mspoon->five_comment = isset($_POST['magicspools']['five']['comment']) ? $_POST['magicspools']['five']['comment'] : ""; $mspoon->one_like = isset($_POST['magicspools']['one']['like']) ? intval($_POST['magicspools']['one']['like']) : "0"; $mspoon->two_like = isset($_POST['magicspools']['two']['like']) ? intval($_POST['magicspools']['two']['like']) : "0"; $mspoon->three_like = isset($_POST['magicspools']['three']['like']) ? intval($_POST['magicspools']['three']['like']) : "0"; $mspoon->four_like = isset($_POST['magicspools']['four']['like']) ? intval($_POST['magicspools']['four']['like']) : "0"; $mspoon->five_like = isset($_POST['magicspools']['five']['like']) ? intval($_POST['magicspools']['five']['like']) : "0"; $mspoon->save(); } // if (isset($_POST['hotFoods'])) { $cusApp = CustAppoint::model()->findByAttributes(array('app_id' => 2, 'cus_id' => getCurCusId())); $cusApp->status = 2; $cusApp->save(); $model = HotFood::model()->findByPk($hotFoods[0]->id); if ($model !== null) { $model->ans = isset($_POST['hotFoods']['ans']) ? $_POST['hotFoods']['ans'] : ""; $model->comment = isset($_POST['hotFoods']['comment']) ? $_POST['hotFoods']['comment'] : ""; $model->save(); } } if (isset($_POST['sandwiches'])) { $model = Sandwiches::model()->findByPk($sandwiches[0]->id); if ($model !== null) { $model->ans = isset($_POST['sandwiches']['ans']) ? $_POST['sandwiches']['ans'] : ""; $model->comment = isset($_POST['sandwiches']['comment']) ? $_POST['sandwiches']['comment'] : ""; $model->save(); } } if (isset($_POST['breakfast'])) { $model = Breakfast::model()->findByPk($breakfast[0]->id); if ($model !== null) { $model->ans = isset($_POST['breakfast']['ans']) ? $_POST['breakfast']['ans'] : ""; $model->comment = isset($_POST['breakfast']['comment']) ? $_POST['breakfast']['comment'] : ""; $model->save(); } } if (isset($_POST['indusFoods'])) { $model = IndusFood::model()->findByPk($indusFoods[0]->id); if ($model !== null) { $model->ans = isset($_POST['indusFoods']['ans']) ? $_POST['indusFoods']['ans'] : ""; $model->comment = isset($_POST['indusFoods']['comment']) ? $_POST['indusFoods']['comment'] : ""; $model->save(); } } if (isset($_POST['lunch'])) { $model = Lunch::model()->findByPk($lunches[0]->id); if ($model !== null) { $model->ans = isset($_POST['lunch']['ans']) ? $_POST['lunch']['ans'] : ""; $model->comment = isset($_POST['lunch']['comment']) ? $_POST['lunch']['comment'] : ""; $model->save(); } } if (isset($_POST['sundries'])) { $model = Sundries::model()->findByPk($sundries[0]->id); if ($model !== null) { $model->ans = isset($_POST['sundries']['ans']) ? $_POST['sundries']['ans'] : ""; $model->comment = isset($_POST['sundries']['comment']) ? $_POST['sundries']['comment'] : ""; $model->save(); } } echo json_encode(array('success' => '1')); exit; } $lunch_note = ""; $breakfast_note = ""; $sandwiches_note = ""; $hotfood_note = ""; $indusfood_note = ""; $sundries_note = ""; foreach ($notes as $value => $kval) { // print_r($kval); if ($kval['form'] == 'lunch') { $lunch_note = $kval['text']; } if ($kval['form'] == 'breakfast') { $breakfast_note = $kval['text']; } if ($kval['form'] == 'sandwiches') { $sandwiches_note = $kval['text']; } if ($kval['form'] == 'hotfood') { $hotfood_note = $kval['text']; } if ($kval['form'] == 'indusfood') { $indusfood_note = $kval['text']; } if ($kval['form'] == "sundries") { $sundries_note = $kval['text']; } if ($kval['form'] == 'magicspoon') { $mspoon_note = $kval['text']; } } $this->render('adminsolns', array('customer' => $cust, 'magic_spools' => $magicSpools, 'notes' => $notes, 'workingWells' => $workingWells, 'sundries' => $sundries, 'lunches' => $lunches, 'indusFoods' => $indusFoods, 'breakfasts' => $breakfasts, 'sandwiches' => $sandwiches, 'hotFoods' => $hotFoods, 'sundries_note' => $sundries_note, 'lunch_note' => $lunch_note, 'indusfood_note' => $indusfood_note, 'breakfast_note' => $breakfast_note, 'sandwiches_note' => $sandwiches_note, 'hotfood_note' => $hotfood_note)); }
public function actionCustomerReply() { $this->layout = '//layouts/maindate'; if (isset($_POST['customer']) && isset($_POST['customer']['ajax'])) { $customer_questions = $this->loadModel(getCurCusId()); $customer_questions->provisional_date = isset($_POST['customer']['provisional_date']) ? $_POST['customer']['provisional_date'] : ""; $customer_questions->call_date = isset($_POST['customer']['call_date']) ? $_POST['customer']['call_date'] : ""; // mErrors($customer_questions); $customer_questions->save(); echo json_encode(array('success' => 1)); exit; } DynamicCall::GetEdit1stPdf(getCurCusId()); $id = $_GET['id']; $customer = Customer::model()->findByPk($id); // $magic_spoon = MagicSpool::model()->findByAttributes(array('cus_id' => getCurCusId())); // $magic_spoon = MagicSpool::model()->find()->findByAttributes(array('cus_id' => getCurCusId())); $magic_spoon = MagicSpool::model()->findAll(array('select' => 'one,two,three,four,five', 'condition' => 'cus_id=:cus_id', 'limit' => 1, 'params' => array(':cus_id' => $id))); $lunch_count = Lunch::model()->findAll(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => $id))); $break_count = Breakfast::model()->findAll(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => $id))); $hotf_count = HotFood::model()->findAll(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => $id))); $sandw_count = Sandwiches::model()->findAll(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => $id))); $sundr_count = Sundries::model()->findAll(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => $id))); $IndusFood_count = IndusFood::model()->findAll(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => $id))); $Christmas_count = Christmas::model()->findAll(array('condition' => 'cus_id=:cus_id', 'params' => array(':cus_id' => $id))); $customer = Customer::model()->findByPk($id); $selProdt = array(); if (count(Yii::app()->session['sel_prod'])) { $criteria = new CDbCriteria(); $criteria->select = 't.name,t.desc'; $criteria->addInCondition('id', Yii::app()->session['sel_prod']); $selProdt = Product::model()->findAll($criteria); } $this->render('customerreply', array('magic_spoon' => $magic_spoon, 'lunch_count' => $lunch_count, 'break_count' => $break_count, 'hotf_count' => $hotf_count, 'sandw_count' => $sandw_count, 'sundr_count' => $sundr_count, 'indusFood_count' => $IndusFood_count, 'christmas_count' => $Christmas_count, 'selProdt' => $selProdt, 'customer' => $customer)); }