public function actionComplaintAdd() { if (Yii::app()->request->isPostRequest) { $model = Yii::app()->request->getPost('model'); $external_id = Yii::app()->request->getPost('external_id'); $store = $model::model()->findByPk($external_id); $profile = Yii::app()->user->getProfile(); $Company = $profile->company; // if ($Company->id == $store->user->company->id ) { // throw new CHttpException(403); // } $complaint = new Complaint(); $complaint->from_company_id = $Company->id; $complaint->user_id = Yii::app()->user->id; $complaint->to_company_id = $store->user->company->id; $complaint->model = $model; $complaint->record_id = $external_id; if ($complaint->validate()) { $complaint->save(); echo CJSON::encode(['status' => 'success', 'data' => '/cabinet/complaint/success']); } else { echo CJSON::encode(['status' => 'error', 'data' => print_r($complaint->getErrors(), true)]); } } }
public function actionReadTopic($id) { $thread = Thread::model()->getThreadInfoById($id); $this->areaLarge = $thread['program_name']; $this->areaSmall = $thread['semester_name']; $reply = new Reply(); $complaint = new Complaint('postComplaint'); if (isset($_POST['Reply'])) { $reply->attributes = $_POST['Reply']; $reply->post_item_id = $id; if ($reply->save()) { Yii::app()->user->setFlash('success', Yii::t('forum', 'forum.view.reply.success')); $reply->unsetAttributes(); } else { Yii::app()->user->setFlash('error', Yii::t('forum', 'forum.view.reply.error')); } } if (isset($_POST['Complaint'])) { $complaint->attributes = $_POST['Complaint']; if ($complaint->save()) { if ($complaint->post_item_id == $id) { Yii::app()->user->setFlash('success', Yii::t('forum', 'forum.view.complaint.success')); } else { Yii::app()->user->setFlash('success', Yii::t('forum', 'forum.view.complaint.success')); } $complaint->unsetAttributes(); } else { Yii::app()->clientScript->registerScript('show_modal', "\$('#reportModal').modal('show');", CClientScript::POS_READY); } } $dataProvider = Thread::model()->getPostsDataInThread($id); Yii::log(CVarDumper::dumpAsString($dataProvider->getData())); $this->render('application.modules.community.views.front.post.view', array('thread' => $thread, 'threadId' => $id, 'dataProvider' => $dataProvider, 'reply' => $reply, 'complaint' => $complaint)); }
public function actionReadTopic($id) { $thread = Thread::model()->getThreadInfoById($id); $this->forumBreadcrumb = array('Programs' => array('forum/index'), $thread['program_name'] => array('forum/programView', 'programId' => $thread['program_id']), $thread['semester_name'] => array('forum/viewTopics', 'programId' => $thread['program_id'], 'semesterId' => $thread['semester_id']), $thread['title'] < Yii::app()->params['forum_max_crumb_length'] ? $thread['title'] : substr($thread['title'], 0, Yii::app()->params['forum_max_crumb_length']) . '...'); $this->areaLarge = $thread['program_name']; $this->areaSmall = $thread['semester_name']; $reply = new Reply(); $complaint = new Complaint('postComplaint'); if (isset($_POST['Reply'])) { $reply->attributes = $_POST['Reply']; $reply->post_item_id = $id; if ($reply->save()) { Yii::app()->user->setFlash('success', Yii::t('forum', 'forum.view.reply.success')); $reply->unsetAttributes(); } else { Yii::app()->user->setFlash('error', Yii::t('forum', 'forum.view.reply.error')); } } if (isset($_POST['Complaint'])) { $complaint->attributes = $_POST['Complaint']; if ($complaint->save()) { if ($complaint->post_item_id == $id) { Yii::app()->user->setFlash('success', Yii::t('forum', 'forum.view.complaint.success')); } else { Yii::app()->user->setFlash('success', Yii::t('forum', 'forum.view.complaint.success')); } $complaint->unsetAttributes(); } else { Yii::app()->clientScript->registerScript('show_modal', "\$('#reportModal').modal('show');", CClientScript::POS_READY); } } $dataProvider = Thread::model()->getPostsDataInThread($id); Yii::log(CVarDumper::dumpAsString($dataProvider->getData())); $this->render('view', array('thread' => $thread, 'threadId' => $id, 'dataProvider' => $dataProvider, 'reply' => $reply, 'complaint' => $complaint)); }
public function adminSection() { $adminId = Session::get('admin_id'); if (!isset($adminId)) { return Redirect::to('/'); } $orderCount = Order::where('status', '=', 'pending')->count(); $userCount = User::where('status', '=', 'active')->count(); $softwareUserCount = SoftwareUser::where('status', '=', 'active')->count(); $complaintCount = Complaint::whereIn('status', array('Complaint', 'Problem'))->count(); return View::make('admin.admin-section')->with('orderCount', $orderCount)->with('userCount', $userCount)->with('complaintCount', $complaintCount)->with('softwareUserCount', $softwareUserCount); }
function __construct($tablename = 'qc_complaints') { // Register non-persistent attributes // Contruct the object parent::__construct($tablename); // Set specific characteristics // Define relationships // Define field formats // Define validation // Define enumerated types // Define system defaults $this->type = 'RR'; $this->getField('type')->setDefault('RR'); }
header("Content-Type:text/html;charset=utf-8"); require '../include/init.inc.php'; $arr = array('month', 'buss_name_detail'); $month = $buss_name_detail = ""; extract($_GET, EXTR_IF_EXISTS); $user_info = UserSession::getSessionInfo(); $province_id = $user_info['province_id'] ? $user_info['province_id'] : $province_id; $menus = MenuUrl::getMenuByIds($user_info['shortcuts']); foreach ($arr as $key => $value) { if (${$value}) { $param[$value] = ${$value}; } } $province = Info::getProvince(); // $start_date = $param['start_date'] = $_GET['start_date'] = $_GET['start_date']?$_GET['start_date']:date('Y-m'); $data['result'] = Complaint::getSingleDetail($buss_name_detail, $month); foreach ($data['result'] as $key => $value) { $tmp['name'][(string) ($value['num'] + rand(1, 1000) / 1000)] = $province[$value['province_id']]['name']; $tmp['value'][] = $value['num']; } rsort($tmp['value']); krsort($tmp['name']); $data['name'] = '"' . implode('","', $tmp['name']) . '"'; $data['value'] = '"' . implode('","', $tmp['value']) . '"'; // if (Common::isPost ()) { // if($start_date != '' && $end_date !=''){ $page_size = PAGE_SIZE; $page_no = $page_no < 1 ? 1 : $page_no; $start = ($page_no - 1) * $page_size; // if($_GET['download']==1) // {
if (${$value}) { $param[$value] = ${$value}; } } $start_date = $param['start_date'] = $_GET['start_date'] = $_GET['start_date'] ? $_GET['start_date'] : date('Y-m'); // if (Common::isPost ()) { // if($start_date != '' && $end_date !=''){ $page_size = PAGE_SIZE; $page_no = $page_no < 1 ? 1 : $page_no; $start = ($page_no - 1) * $page_size; if ($_GET['download'] == 1) { $data['result'] = Complaint::complaintsSearch($param, $start, 0); } else { $data['result'] = Complaint::complaintsSearch($param, $start, $page_size); } $row_count = Complaint::complaintsSearchCount($param); // } $data['buss_class'] = Info::getProductType(); $data['province'] = Info::getProvince(false); $data['complaintType'] = Info::getComplaintType('complaint_type', false); $data['questionType'][1] = Info::getQuestionType(1, 'question_type', true); $data['questionType'][2] = Info::getQuestionType(2, 'question_type', true); $data['questionType'][3] = Info::getQuestionType(3, 'question_type', true); $data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false); $data['bussType'] = Info::getBussLine('buss_type', true); //导出excel下载 if ($_GET['download'] == 1) { $downloadStr = array_to_string($data); //var_dump($data);exit; Common::exportExcel($downloadStr, 'black_list'); exit;
$sortTmp[$key]['score'] = $tmp['value'][$key]; $sortTmp[$key]['name'] = $value['class']; } if (isset($tmp['value']) && is_array($tmp['value'])) { array_multisort($tmp['value'], SORT_DESC, $tmp['typeName'], SORT_DESC, $sortTmp); } $tmpName = $tmpScore = array(); foreach ($sortTmp as $key => $value) { $tmpName[] = $value['name']; $tmpScore[] = $value['score']; } $total['cos'] = Complaint::getValueTotal(strtotime($start_date . "-01")) / 10000000; // $total['cos'] = 1000; $total['increase'] = $total['num'] - Complaint::getComplaintTotal(strtotime($start_date . "-01 -1 month"), $province_id); $data['total'] = $total; $row_count = Complaint::complaintsAnalayze2Count($param); // $data['month'] = Complaint::baseAnalayzeMonth($param); // $r = Complaint::complaintsAnalayzeType($param); // var_dump($r); // $data['provinces'] = implode(',',Complaint::complaintsAnalayzeType($param)['province']); // $data['complaints'] = Complaint::complaintsAnalayzeType($param)['complaints']; $province = Info::getProvince(); foreach ($province as $key => $value) { $data['provinceMap'][$key] = $value['name']; } if (isset($tmp['typeName'])) { $data['zhuString'] = '"' . implode('","', $tmpName) . '"'; $data['zhuData'] = implode(',', $tmpScore); } $data['pie'] = json_encode($data['pie']); // }
} else { if ($_GET['download'] == 1) { $data['result'] = Complaint::customSpAnalayze($param, $start, 0); } else { $data['result'] = Complaint::customSpAnalayze($param, $start, $page_size); } $row_count = Complaint::customSpAnalayzeNum($param); } $wan = array_slice($wanResult, 0, 20); foreach ($wan as $key => $value) { $name[] = $value['name']; $score[] = sprintf("%.2f", $value['score']); } $data['wanName'] = $name ? '"' . implode('","', $name) . '"' : ''; $data['chartWan'] = $score ? '' . implode(',', $score) . '' : ''; $charData = Complaint::customSpAnalayze($param, 0, 20); if ($charData) { foreach ($charData as $key => $value) { $tmp['name'][] = $value['part_name']; $tmp['value'][] = $value['num']; $tmp['wan'][] = $value['wan']; } $data['chartName'] = '"' . implode('","', $tmp['name']) . '"'; $data['chartValue'] = implode(',', $tmp['value']); // $data['chartWan'] = implode(',', $tmp['wan']); } // $row_count = 20; // $data['month'] = Complaint::customAnalayzeMonth($param); // $data['provinces'] = Complaint::customAnalayzeArea($param); $province = Info::getProvince(); foreach ($province as $key => $value) {
foreach ($data['result'] as $key => $value) { // $total += $value['num']; $name = mb_substr($value['sp_name'], 0, 20); $tmp['name'][] = $name; $tmp['value'][] = $value['num']; $tmp['wan'][] = round($value['wan'], 2); $data['wanString'][(string) $value['wan']] = $name; } rsort($tmp['wan']); krsort($data['wanString']); $data['wanString'] = '"' . implode('","', $data['wanString']) . '"'; $data['chartName'] = '"' . implode('","', $tmp['name']) . '"'; $data['chartValue'] = implode(',', $tmp['value']); $data['chartWan'] = implode(',', $tmp['wan']); } $row_count = Complaint::baseSpAnalayzeCount($param); if ($wan) { $row_count = count($data['result']); } // $data['month'] = Complaint::customAnalayzeMonth($param); // $data['provinces'] = Complaint::customAnalayzeArea($param); $province = Info::getProvince(); foreach ($province as $key => $value) { $data['provinceMap'][$key] = $value['name']; } $data['provinceString'] = '"' . implode('","', $data['provinceMap']) . '"'; // } $data['total'] = $total; $data['province'] = Info::getProvince(false); $data['complaintType'] = Info::getComplaintType('complaint_type', false); $data['questionType'][1] = Info::getQuestionType(1, 'question_type', true);
$param['complaint_level'] = $data['complaintLevel'][$param['complaint_level']]; } } $start_date = $param['start_date'] = $_GET['start_date'] = $_GET['start_date'] ? $_GET['start_date'] : date('Y-m'); //var_dump($param);exit; // if (Common::isPost ()) { if ($start_date != '') { $page_size = PAGE_SIZE; $page_no = $page_no < 1 ? 1 : $page_no; $start = ($page_no - 1) * $page_size; if ($_GET['download'] == 1) { $data['result'] = Complaint::search($param, $start, 0); } else { $data['result'] = Complaint::search($param, $start, $page_size); } $row_count = Complaint::searchCount($param); } $data['province'] = Info::getProvince(false); $data['bussLine'] = Info::getBussLine('buss_line', false); //导出excel下载 if ($_GET['download'] == 1) { $downloadStr = array_to_string($data); Common::exportExcel($downloadStr, 'search'); exit; } $page_html = Pagination::showPager("search.php?" . $http_query, $page_no, PAGE_SIZE, $row_count); // $page_html=Pagination::showPager("search.php?class_name=$class_name&user_name=$user_name&start_date=$start_date&end_date=$end_date",$page_no,PAGE_SIZE,$row_count); $export_excel = "search.php?download=1&" . $http_query; Template::assign("error", $error); Template::assign("_POST", $_POST); Template::assign('_GET', $_GET);
public function softwareUserComplaints($id) { if (isset($id)) { $softwareUser = SoftwareUser::find($id); if (isset($softwareUser)) { $complaints = Complaint::where('software_user_id', $id)->get(); if (isset($complaints)) { return json_encode(array('message' => 'found', 'complaints' => $complaints->toArray())); } else { return json_encode(array('message' => 'empty')); } } else { return json_encode(array('message' => 'invalid')); } } else { return json_encode(array('message' => 'invalid')); } }
private function deleteComplaint(\User $user) { $data = 'user_id = :user_id'; $param = array(':user_id' => $user->id); if ($this->debug) { echo " ... Complaint: del " . Complaint::model()->count($data, $param) . " \n"; } else { Complaint::model()->deleteAll($data, $param); } }
if (${$value}) { $param[$value] = ${$value}; } } $start_date = $param['start_date'] = $_GET['start_date'] = $_GET['start_date'] ? $_GET['start_date'] : date('Y-m'); // if (Common::isPost ()) { // if($start_date != '' && $end_date !=''){ $page_size = PAGE_SIZE; $page_no = $page_no < 1 ? 1 : $page_no; $start = ($page_no - 1) * $page_size; if ($_GET['download'] == 1) { $data['result'] = Complaint::customAnalayze($param, $start, 0); } else { $data['result'] = Complaint::customAnalayze($param, $start, $page_size); } $row_count = Complaint::customAnalayzeCount($param); $param['flag'] = 1; #$data['provinces'] = Complaint::customAnalayzeArea($param); $province = Info::getProvince(); foreach ($province as $key => $value) { $data['provinces'][$value['id']]['name'] = $value['name']; $data['provinces'][$value['id']]['wan'] = 0; $data['provinceMap'][$key] = $value['name']; } foreach ($data['result'] as $key => $value) { $data['provinces'][$value['province_id']]['wan'] = $value['wan']; } foreach ($data['provinces'] as $key => $row) { $volume[$key] = $row['wan']; $edition[$key] = $row['name']; }
$data['result'] = Complaint::complaintsSpAnalayze($param, $start, 0); } else { $data['result'] = Complaint::complaintsSpAnalayze($param, $start, $page_size); } if ($data['result']) { foreach ($data['result'] as $key => $value) { // var_dump($value); $tmp['name'][] = mb_substr(str_replace("\n", "", trim($value['sp_corp_name'])), 0, 18, 'utf-8'); $tmp['value'][] = $value['num']; $tmp['wan'][] = $value['wan']; } $data['chartName'] = '"' . implode('","', $tmp['name']) . '"'; $data['chartValue'] = implode(',', $tmp['value']); $data['chartWan'] = implode(',', $tmp['wan']); } $row_count = Complaint::complaintsSpAnalayzeCount($param); // $data['month'] = Complaint::customAnalayzeMonth($param); // $data['provinces'] = Complaint::customAnalayzeArea($param); $province = Info::getProvince(); foreach ($province as $key => $value) { $data['provinceMap'][$key] = $value['name']; } $data['provinceString'] = '"' . implode('","', $data['provinceMap']) . '"'; // } $data['province'] = Info::getProvince(false); $data['complaintType'] = Info::getComplaintType('complaint_type', false); $data['questionType'][1] = Info::getQuestionType(1, 'question_type', true); $data['questionType'][2] = Info::getQuestionType(2, 'question_type', true); $data['questionType'][3] = Info::getQuestionType(3, 'question_type', true); $data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false); $data['bussLine'] = Info::getBussLine('buss_type', false);
static function getComplaintByCustomerId($customerId) { return Complaint::where('customer_id', '=', $customerId)->where('franchisee_id', '=', Session::get('franchiseId'))->get(); }
public function details($id) { if (Auth::check()) { $currentPage = "CUSTOMERS_LIST"; $mainMenu = "CUSTOMERS_MAIN"; $inputs = Input::all(); if (isset($inputs['customerName'])) { if (Customers::addCustomers($inputs)) { Session::flash('msg', "Customer added successfully."); } else { Session::flash('warning', "Customer, Course Could not be added at the moment."); } } $customer = Customers::getCustomersById($id); $students = Students::getStudentByCustomer($id); $comments = Comments::getCommentByCustomerId($id); $provinces = Provinces::getProvinces("IN"); $kidsSelect = Students::getStudentsForSelectBox($id); $membershipTypes = MembershipTypes::getMembershipTypesForSelectBox(); $birthdays = BirthdayParties::getBirthdaysByCustomer($id); //return $customer; //Membership if (isset($inputs['membershipTypesMembersDiv'])) { /* echo '<pre>'; print_r($inputs); echo '</pre>'; exit(); */ if ($inputs['membershipTypesMembersDiv'] != "") { $membershipInput['customer_id'] = $id; $membershipInput['membership_type_id'] = $inputs['membershipTypesMembersDiv']; CustomerMembership::addMembership($membershipInput); $order['customer_id'] = $id; $order['payment_for'] = "membership"; $order['payment_dues_id'] = ''; $order['payment_mode'] = $inputs['paymentTypeRadio']; $order['card_last_digit'] = $inputs['card4digits']; $order['card_type'] = $inputs['cardType']; $order['bank_name'] = $inputs['bankName']; $order['cheque_number'] = $inputs['chequeNumber']; $order['amount'] = $inputs['membershipPrice']; $order['order_status'] = "completed"; Orders::createOrder($order); } } //$customerMembership = ""; /* echo '<pre>'; print_r($customer); echo '</pre>'; exit(); */ $presentDate = Carbon::now(); $membershipStartDate = Carbon::now(); $membershipEndDate = Carbon::now(); $customerMembershipId = ''; if (isset($customer->CustomerMembership['0'])) { $select = count($customer->CustomerMembership) - 1; $membershipStartDate = $membershipStartDate->createFromFormat('Y-m-d', $customer->CustomerMembership[$select]->membership_start_date); $membershipEndDate = $membershipEndDate->createFromFormat('Y-m-d', $customer->CustomerMembership[$select]->membership_end_date); if ($membershipStartDate->lte($presentDate) && $membershipEndDate->gte($presentDate)) { $customerMembershipId = $customer->CustomerMembership[$select]->membership_type_id; } } if (isset($customerMembershipId)) { $customerMembership = MembershipTypes::getMembershipTypeByID($customerMembershipId); } $membershipTypesAll = MembershipTypes::getMembershipTypes(); $birthdaypaiddata = Orders::getBirthdayfulldata($id); for ($i = 0; $i < count($birthdaypaiddata); $i++) { $studentData = Students::getStudentById($birthdaypaiddata[$i]['student_id']); $birthdaypaiddata[$i]['student_name'] = $studentData[0]['student_name']; $birthdaypaiddata[$i]['student_date_of_birth'] = $studentData[0]['student_date_of_birth']; $birthdayData = BirthdayParties::getBirthdaybyId($birthdaypaiddata[$i]['birthday_id']); $birthdaypaiddata[$i]['birthday_party_date'] = $birthdayData[0]['birthday_party_date']; $birthdaypaiddata[$i]['tax_amount'] = $birthdaypaiddata[0]['tax_amount']; $user_data = User::getUsersByUserId($birthdaypaiddata[$i]['created_by']); $birthdaypaiddata[$i]['name'] = $user_data[0]['first_name'] . $user_data[0]['last_name']; $birthdaypaiddata[$i]['encrypted_id'] = Crypt::encrypt($birthdaypaiddata[$i]['id']); } $birthdayDuedata = PaymentDues::getPaymentpendingfulldata($id); for ($i = 0; $i < count($birthdayDuedata); $i++) { $studentData = Students::getStudentById($birthdayDuedata[$i]['student_id']); $birthdayDuedata[$i]['student_name'] = $studentData[0]['student_name']; $user_data = User::getUsersByUserId($birthdayDuedata[$i]['created_by']); $birthdayDuedata[$i]['name'] = $user_data[0]['first_name'] . $user_data[0]['last_name']; $birthdayData = BirthdayParties::getBirthdaybyId($birthdayDuedata[$i]['birthday_id']); $birthdayDuedata[$i]['birthday_party_date'] = $birthdayData[0]['birthday_party_date']; } //followup_data $iv_data = IntroVisit::where('customer_id', '=', $id)->get(); for ($i = 0; $i < count($iv_data); $i++) { $comments_data = Comments::where('introvisit_id', '=', $iv_data[$i]['id'])->orderBy('id', 'DESC')->first(); $iv_data[$i]['comment_data'] = $comments_data; $student = Students::find($iv_data[$i]['student_id']); $iv_data[$i]['student_name'] = $student['student_name']; $iv_data[$i]['iv_date'] = date("Y-m-d", strtotime($iv_data[$i]['iv_date'])); } $birthday_data = BirthdayParties::where('customer_id', '=', $id)->get(); for ($i = 0; $i < count($birthday_data); $i++) { $birthday_comments = Comments::where('birthday_id', '=', $birthday_data[$i]['id'])->orderBy('id', 'DESC')->first(); $birthday_data[$i]['comment_data'] = $birthday_comments; $student_data = Students::find($birthday_data[$i]['student_id']); $birthday_data[$i]['student_name'] = $student_data['student_name']; $birthday_data[$i]['birthday_party_date'] = date("Y-m-d", strtotime($birthday_data[$i]['birthday_party_date'])); } //for complaints $complaint_data = Complaint::getComplaintByCustomerId($id); //Comments::where('customer_id','=',$id)->get(); for ($i = 0; $i < count($complaint_data); $i++) { $complaint_data[$i]['comments'] = Comments::where('complaint_id', '=', $complaint_data[$i]['id'])->orderBy('id', 'DESC')->first(); $student_data = Students::find($complaint_data[$i]['student_id']); $complaint_data[$i]['student_name'] = $student_data['student_name']; } //for retention $retention_data = Retention::getRetentionByCustomerId($id); for ($i = 0; $i < count($retention_data); $i++) { $retention_data[$i]['comments'] = Comments::where('retention_id', '=', $retention_data[$i]['id'])->orderBy('id', 'DESC')->first(); $student_data = Students::find($retention_data[$i]['student_id']); $retention_data[$i]['student_name'] = $student_data['student_name']; } //for inquiry $inuiry_data = Inquiry::getInquiryByCustomerId($id); for ($i = 0; $i < count($inuiry_data); $i++) { $inuiry_data[$i]['comments'] = Comments::where('inquiry_id', '=', $inuiry_data[$i]['id'])->orderBy('id', 'DESC')->first(); } //for enrollment payment followup/brush up calls $enrollmentFollowupData = PaymentFollowups::getPaymentFollowupByCustomerId($id); for ($i = 0; $i < count($enrollmentFollowupData); $i++) { $enrollmentFollowupData[$i]['comments'] = Comments::where('paymentfollowup_id', '=', $enrollmentFollowupData[$i]['id'])->orderBy('id', 'DESC')->first(); $student_data = Students::find($enrollmentFollowupData[$i]['student_id']); $enrollmentFollowupData[$i]['student_name'] = $student_data['student_name']; $paymentDueData = PaymentDues::find($enrollmentFollowupData[$i]['payment_due_id']); $enrollmentFollowupData[$i]['payment_date'] = $paymentDueData['end_order_date']; } // for customer kids enrollment. $customer_student_data = Students::where('customer_id', '=', $id)->where('franchisee_id', '=', Session::get('franchiseId'))->select('id', 'student_name')->get(); for ($i = 0; $i < count($customer_student_data); $i++) { $student_classes = StudentClasses::getEnrolledStudentBatch($customer_student_data[$i]['id']); //return $student_classes[0]['batch_id']; $customer_student_data[$i]['student_classes_data'] = $student_classes; } //return $customer_student_data; for ($i = 0; $i < count($customer_student_data); $i++) { for ($j = 0; $j < count($customer_student_data[$i]['student_classes_data']); $j++) { $find = Batches::find($customer_student_data[$i]['student_classes_data'][$j]['batch_id']); $customer_student_data[$i]['student_classes_data'][$j]['batch_name'] = $find->batch_name; } } //return the customer membership follolwup $customer_membership_data = MembershipFollowup::where('customer_id', '=', $id)->get(); for ($i = 0; $i < count($customer_membership_data); $i++) { $membershipid[$i] = $customer_membership_data[$i]['id']; } if (isset($membershipid)) { for ($i = 0; $i < count($membershipid); $i++) { $membership_followup_data[$i] = Comments::where('membership_followup_id', '=', $membershipid[$i])->orderBy('id', 'DESC')->first(); $memfollowup_data = MembershipFollowup::find($membershipid[$i]); $Customer_membership_data = CustomerMembership::find($memfollowup_data->membership_id); $membership_followup_data[$i]['membership_end_date'] = $Customer_membership_data->membership_end_date; } } $viewData = array('birthdaypaiddata', 'birthdayDuedata', 'customer', 'students', 'currentPage', 'mainMenu', 'comments', 'provinces', 'customerMembership', 'kidsSelect', 'membershipTypes', 'membershipTypesAll', 'birthdays', 'iv_data', 'birthday_data', 'complaint_data', 'retention_data', 'inuiry_data', 'enrollmentFollowupData', 'customer_student_data', 'membership_followup_data'); return View::make('pages.customers.details', compact($viewData)); } else { return Redirect::to("/"); } }
public function createFollowup() { $inputs = Input::all(); if ($inputs['followupType'] == 'COMPLAINTS') { $createComplaint = Complaint::createComplaint($inputs); $input['complaint_id'] = $createComplaint->id; } else { if ($inputs['followupType'] == 'RETENTION') { $createRetention = Retention::createRetention($inputs); $input['retention_id'] = $createRetention->id; } else { if ($inputs['followupType'] == 'INQUIRY') { $createInquiry = Inquiry::createInquiry($inputs); $input['inquiry_id'] = $createInquiry->id; } } } //create comment if (isset($createComplaint)) { $input['customerId'] = $inputs['customer_id']; $input['student_id'] = $inputs['student_id']; $input['followupType'] = $inputs['followupType']; $input['commentStatus'] = $inputs['followupstatus']; $input['commentText'] = $inputs['otherCommentTxtarea']; $input['commentType'] = $inputs['comment_type']; $input['reminderDate'] = $inputs['remindDate']; $comments_data = Comments::addComments($input); } if (isset($createRetention)) { $input['customerId'] = $inputs['customer_id']; $input['student_id'] = $inputs['student_id']; $input['followupType'] = $inputs['followupType']; $input['commentStatus'] = $inputs['followupstatus']; $input['commentText'] = $inputs['otherCommentTxtarea']; $input['commentType'] = $inputs['comment_type']; $input['reminderDate'] = $inputs['remindDate']; $comments_data = Comments::addComments($input); } if (isset($createInquiry)) { $input['customerId'] = $inputs['customer_id']; $input['followupType'] = $inputs['followupType']; $input['commentStatus'] = $inputs['followupstatus']; $input['commentText'] = $inputs['otherCommentTxtarea']; $input['commentType'] = $inputs['comment_type']; $input['reminderDate'] = $inputs['remindDate']; $comments_data = Comments::addComments($input); } if ($comments_data) { return Response::json(array('status' => 'success')); } else { return Response::json(array('status' => 'failure')); } }
$http_query .= $value . '=' . ${$value} . '&'; if (${$value}) { $param[$value] = ${$value}; } } // if (Common::isPost ()) { // if($start_date != '' && $end_date !=''){ $page_size = PAGE_SIZE; $page_no = $page_no < 1 ? 1 : $page_no; $start = ($page_no - 1) * $page_size; if ($_GET['download'] == 1) { $data['result'] = Complaint::getBlackList($param, $start, 0); } else { $data['result'] = Complaint::getBlackList($param, $start, $page_size); } $row_count = Complaint::getBlackListCount($param); // } $data['province'] = Info::getProvince(false); $data['complaintType'] = Info::getComplaintType('complaint_type', false); $data['questionType'][1] = Info::getQuestionType(1, 'question_type', true); $data['questionType'][2] = Info::getQuestionType(2, 'question_type', true); $data['questionType'][3] = Info::getQuestionType(3, 'question_type', true); $data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false); $data['bussLine'] = Info::getBussLine('buss_type', false); // var_dump($data['bussLine']); //导出excel下载 if ($_GET['download'] == 1) { $downloadStr = array_to_string($data); //var_dump($data);exit; Common::exportExcel($downloadStr, 'black_list'); exit;
//init code $routes = BusRoute::find_all(); $stops = BusStop::find_all(); $buses = Bus::find_all(); $bus_personnel = BusPersonnel::find_all(); $complaint_types = ComplaintType::find_all(); $complaint_status = ComplaintStatus::find_all(); //check login if ($session->is_logged_in()) { if ($session->object_type == 6) { //commuter $user = $commuter_object->find_by_id($_SESSION['id']); $profile_picture = $photo_object->get_profile_picture(6, $user->id); if (isset($_POST['submit'])) { $complaint_to_create = new Complaint(); $complaint_to_create->bus_route_id = $_POST['bus_route_id']; $complaint_to_create->stop_id = $_POST['stop_id']; $complaint_to_create->bus_id = $_POST['bus_id']; $complaint_to_create->bus_personnel_id = $_POST['bus_personnel_id']; $complaint_to_create->complaint_type = $_POST['complaint_type']; $complaint_to_create->status = $_POST['status']; $complaint_to_create->content = $_POST['content']; if (isset($_POST['bus_route_id'])) { $complaint_to_create->related_object_type = 1; $complaint_to_create->related_object_id = $_POST['bus_route_id']; } else { if (isset($_POST['stop_id'])) { $complaint_to_create->related_object_type = 2; $complaint_to_create->related_object_id = $_POST['stop_id']; } else {
public function save() { $type = (string) Input::get('type'); if (!in_array($type, array('mismatch', 'spam', 'flood', 'rude', 'obscene'))) { return $this->respondWithError('Set incorrect complaint type'); } $complaint = new Complaint(); $complaint->owner_id = Auth::user()->id; $complaint->type = $type; if (Input::has('post_id')) { $post = Post::find((int) Input::get('post_id')); if (!$post) { return $this->respondWithError('Post isn\'t found'); } else { if ($post->user_id == Auth::user()->id) { return $this->respondWithError('Can\'t complain to your post'); } } if (Complaint::where('owner_id', Auth::user()->id)->where('post_id', $post->id)->first()) { return $this->respondNoContent(); } $complaint->post_id = $post->id; } else { if (Input::has('user_id')) { $user = User::find((int) Input::get('user_id')); if (!$user) { return $this->respondWithError('User isn\'t found'); } else { if ($user->id == Auth::user()->id) { return $this->respondWithError('Can\'t complain to your profile'); } } if (Complaint::where('owner_id', Auth::user()->id)->where('user_id', $user->id)->first()) { return $this->respondNoContent(); } $complaint->user_id = $user->id; } else { if (Input::has('comment_id')) { $comment = Comment::find((int) Input::get('comment_id')); if (!$comment) { return $this->respondWithError('Comment isn\'t found'); } else { if ($comment->user_id == Auth::user()->id) { return $this->respondWithError('Can\'t complain to your comment'); } } if (Complaint::where('owner_id', Auth::user()->id)->where('comment_id', $comment->id)->first()) { return $this->respondNoContent(); } $complaint->comment_id = $comment->id; } elseif (Input::has('emergency_id')) { $emergency = Emergency::find(Input::get('emergency_id')); if (!$emergency) { return $this->respondNotFound('Emergency not found'); } if ($emergency->receiver != Auth::id()) { return $this->respondInsufficientPrivileges('This emergency is not for you to complain'); } $emergency->complained_at = Carbon::now(); $emergency->save(); $emergency->getMembersTokens()->each(function ($token) use($emergency) { $state = new StateSender($token->auth_token); $state->setEmergencyAsComplained($emergency->id, $emergency->complained_at); }); return $this->respondNoContent(); } } } $complaint->save(); return $this->respondNoContent(); }
/** * 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 Complaint the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Complaint::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
<?php header("Content-Type:text/html;charset=utf-8"); require '../include/init.inc.php'; $arr = array('month', 'sp_corp_code'); $month = $sp_corp_code = ""; extract($_GET, EXTR_IF_EXISTS); $user_info = UserSession::getSessionInfo(); $menus = MenuUrl::getMenuByIds($user_info['shortcuts']); foreach ($arr as $key => $value) { if (${$value}) { $param[$value] = ${$value}; } } // $start_date = $param['start_date'] = $_GET['start_date'] = $_GET['start_date']?$_GET['start_date']:date('Y-m'); $data['result'] = Complaint::getCustomSpDetail($sp_corp_code, $month); // if (Common::isPost ()) { // if($start_date != '' && $end_date !=''){ $page_size = PAGE_SIZE; $page_no = $page_no < 1 ? 1 : $page_no; $start = ($page_no - 1) * $page_size; // if($_GET['download']==1) // { // $data['result'] = Complaint::baseSpAnalayze($param,$start,0); // } // else // { // $data['result'] = Complaint::baseSpAnalayze($param,$start,$page_size); // } // $total = Complaint::getProMonthTotal($province_id,$start_date); $province = Info::getProvince();
if (${$value}) { $param[$value] = ${$value}; } } $start_date = $param['month'] = $_GET['month'] = $_GET['month'] ? $_GET['month'] : date('Y-m'); // if (Common::isPost ()) { // if($start_date != '' && $end_date !=''){ $page_size = PAGE_SIZE; $page_no = $page_no < 1 ? 1 : $page_no; $start = ($page_no - 1) * $page_size; if ($_GET['download'] == 1) { $data['result'] = Complaint::customSearch($param, $start, 0); } else { $data['result'] = Complaint::customSearch($param, $start, $page_size); } $row_count = Complaint::customSearchCount($param); // } $data['province'] = Info::getProvince(false); $data['complaintType'] = Info::getComplaintType('complaint_type', false); $data['questionType'][1] = Info::getQuestionType(1, 'question_type', true); $data['questionType'][2] = Info::getQuestionType(2, 'question_type', true); $data['questionType'][3] = Info::getQuestionType(3, 'question_type', true); $data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false); $data['bussLine'] = Info::getBussLine('buss_type', false); //导出excel下载 if ($_GET['download'] == 1) { $downloadStr = array_to_string($data); //var_dump($data);exit; Common::exportExcel($downloadStr, 'black_list'); exit; }
if ($value['buss_name'] == '') { unset($data['result'][$key]); // var_dump(current($data['result'])); // if($key == 0){ // $data['result'][0] = current($data['result']); // } continue; } $tmp['name'][] = $value['buss_name']; $tmp['value'][] = $value['num']; } $data['chartName'] = '"' . implode('","', $tmp['name']) . '"'; $data['chartValue'] = implode(',', $tmp['value']); } // rsort($tmp['wan']); $row_count = Complaint::customSingleCount($param); // $data['month'] = Complaint::customAnalayzeMonth($param); // $data['provinces'] = Complaint::customAnalayzeArea($param); $province = Info::getProvince(); foreach ($province as $key => $value) { $data['provinceMap'][$key] = $value['name']; } $data['provinceString'] = '"' . implode('","', $data['provinceMap']) . '"'; // } $data['province'] = Info::getProvince(false); $data['complaintType'] = Info::getComplaintType('complaint_type', false); $data['questionType'][1] = Info::getQuestionType(1, 'question_type', true); $data['questionType'][2] = Info::getQuestionType(2, 'question_type', true); $data['questionType'][3] = Info::getQuestionType(3, 'question_type', true); $data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false); $data['bussLine'] = Info::getBussLine('buss_type', false);
foreach ($arr as $key => $value) { $http_query .= $value . '=' . ${$value} . '&'; if (${$value}) { $param[$value] = ${$value}; } } $page_size = PAGE_SIZE; //$page_no=$page_no<1?1:$page_no; $page_no = !isset($_GET['page_no']) || intval($_GET['page_no']) < 1 ? 1 : intval($_GET['page_no']); $start = ($page_no - 1) * $page_size; if ($_GET['download'] == 1) { $data['result'] = Complaint::getUnicomBusinessWithSpList($param, $start, 0); } else { $data['result'] = Complaint::getUnicomBusinessWithSpList($param, $start, $page_size); } $row_count = Complaint::getUnicomBusinessWithSpListCount($param); $row_count = isset($row_count[0]['c']) ? $row_count[0]['c'] : 0; //导出excel下载 if ($_GET['download'] == 1) { $downloadStr = array_to_string($data); //var_dump($data);exit; Common::exportExcel($downloadStr, 'unicom_business_list_with_sp'); exit; } $page_html = Pagination::showPager("sp_search.php?" . $http_query, $page_no, PAGE_SIZE, $row_count); $export_excel = "sp_search.php?download=1&" . $http_query; // $page_html=Pagination::showPager("black_list.php?class_name=$class_name&user_name=$user_name&start_date=$start_date&end_date=$end_date",$page_no,PAGE_SIZE,$row_count); Template::assign("error", $error); Template::assign("_POST", $_POST); Template::assign('_GET', $_GET); Template::assign("data", $data);
<?php ob_start(); include "../includes/tellsafe.inc"; session_start(); if (!isset($_SESSION[user])) { error_log("Attempting to access complaint page without signing in.", 0); header("Location: signin.php"); exit; } $u = new Contact($_SESSION[user]); $c = new Complaint($_GET[c]); if ($u->company != $c->company) { CriticalError("Invalid Complaint: User[{$_SESSION['user']}] Complaint[{$_GET['c']}]"); } if (isset($_POST[confirm])) { if ($u->name != "Guest Account") { $c->ConfirmReceipt($u->id); } header("Location: members.php"); exit; } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE>TellSafe - Review Complaint</TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <?php include "../includes/header.inc"; ?>
<?php include "../includes/tellsafe.inc"; $m = new Complaint($_GET[m]); $c = new Company($m->company); if ($_GET[cmd] == "delete") { $m->Delete(); header("Location: company.php?c=" . $c->id . "&"); exit; } ?> <?php include "adminheader.inc"; ?> <TABLE BORDER=1 CELLSPACING=1 CELLPADDING=10 style="background-color=#006699; width:100%"> <TR style="background-color=#f5f5f5"><TD> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 style="width:100%"> <tr><td> <TABLE BORDER=0 CELLSPACING=2 CELLPADDING=0> <tr><td><a href="admin.php">Administration</a></td></tr> <tr><td><a href="companylist.php">View Company List</a></td></tr> <tr><td><a href="company.php?c=<?php print $c->id; ?> &"><?php print k($c->name); ?> </a></td></tr>
} else { $data['result'] = Complaint::complaintsAnalayze($param, $start, $page_size); foreach ($data['result'] as $key => $value) { $total['num'] += $value['num']; $total['cos'] += $value['cos']; $total['wan'] += $value['wan']; $total['month'] = date('Y-m', $value['month']); } } $total['increase'] = $total['num'] - Complaint::getComplaintTotal(strtotime($start_date . "-01 -1 month"), $province_id); $data['total'] = $total; $row_count = Complaint::customAnalayzeCount($param); $data['month'] = Complaint::complaintsAnalayzeMonth($param); // $data['provinces'] = implode(',',Complaint::complaintsAnalayzeProvince($param)['province']); // $data['complaints'] = implode(',',Complaint::complaintsAnalayzeProvince($param)['complaints']); $tmp = Complaint::complaintsAnalayzeProvince($param); $provincesData = $tmp['province']; $complaintsData = $tmp['complaints']; $province = Info::getProvince(); foreach ($province as $key => $value) { $data['provinceMap'][$key] = $value['name']; $province[$key] = $data['provinces'][$key]['name'] = $data['complaints'][$key]['name'] = $value['name']; $data['provinces'][$key]['score'] = $provincesData[$key]; $data['complaints'][$key]['score'] = $complaintsData[$key]; // $data['provinces']['name'] = $provincesData[$key]; } array_multisort($provincesData, SORT_DESC, $province, SORT_ASC, $data['provinces']); array_multisort($complaintsData, SORT_DESC, $province, SORT_ASC, $data['complaints']); $proName = $proScore = array(); foreach ($data['provinces'] as $key => $value) { if (!$value['name'] || $value['score'] == 0) {
<?php require '../include/init.inc.php'; $method = $id = $keywords = ''; extract($_REQUEST, EXTR_IF_EXISTS); if ($method == 'update' && $id > 0) { $complaints_type = Complaint::getComplaintsTypeById($id); if (empty($complaints_type)) { echo -1; exit; } if (Common::isPost()) { $update_data = array('keywords' => $keywords, 'update_time' => date('Y-m-d H:i:s', time())); $result = Complaint::updateComplaintsTypeKeywords($id, $update_data); if ($result >= 0) { SysLog::addLog(UserSession::getUserName(), 'MODIFY', 'ComplaintsTypeKeywords', $id, json_encode($update_data)); echo 1; exit; //Common::exitWithSuccess ( '投诉分级关键词修改完成','complaints/complaints_type_manage.php' ); } else { echo -2; exit; } } } $complaints_types = Complaint::getAllComplaintsType(); Template::assign('complaints_types', $complaints_types); Template::display('complaint/complaints_type_manage.tpl');