static function addMembership($inputs) { $present_date = Carbon::now(); $customerMembership = new CustomerMembership(); $customerMembership->customer_id = $inputs['customer_id']; $customerMembership->membership_type_id = $inputs['membership_type_id']; $customerMembership->status = "active"; $customerMembership->action = "default"; $customerMembership->membership_start_date = $present_date->toDateString(); if (isset($inputs['membership_type_id'])) { $interval = MembershipTypes::find($inputs['membership_type_id']); $present_date = $present_date->addYears($interval->year_interval); $customerMembership->membership_end_date = $present_date->toDateString(); } $customerMembership->created_by = Session::get('userId'); $customerMembership->created_at = date("Y-m-d H:i:s"); $customerMembership->save(); return $customerMembership; }
echo $form->labelEx($model, 'regionID'); ?> <?php echo CHtml::activeDropDownList($model, 'regionID', Chtml::listData(Regions::model()->findAll(), 'regionID', 'regionName'), array('empty' => 'Select a Region')); ?> <?php echo $form->error($model, 'regionID'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'membershipTypeID'); ?> <?php echo CHtml::activeDropDownList($model, 'membershipTypeID', Chtml::listData(MembershipTypes::model()->findAll(), 'membershipTypeID', 'membershipTypeName'), array('empty' => 'Select Membership Type')); ?> <?php echo $form->error($model, 'membershipTypeID'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'memberName'); ?> <?php echo $form->textField($model, 'memberName', array('size' => 60, 'maxlength' => 100)); ?> <?php echo $form->error($model, 'memberName');
/** * 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 MembershipTypes the loaded model * @throws CHttpException */ public function loadModel($id) { $model = MembershipTypes::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
static function getMembershipTypeByID($membershipId) { return MembershipTypes::find($membershipId); }
public function addbirthdayParty() { $inputs = Input::all(); $taxAmtapplied = $inputs['taxAmount']; if ($inputs['membershipType'] != "" && $inputs['membershipPriceBday'] != 0) { $membershipInput['customer_id'] = $inputs['customerId']; $membershipInput['membership_type_id'] = $inputs['membershipType']; $customerMembershipData = CustomerMembership::addMembership($membershipInput); if ($customerMembershipData->membership_type_id == 1) { $followupMembershipData = Comments::addFollowupForMembership($customerMembershipData); } } $addBirthday = BirthdayParties::addbirthdayParty($inputs); if ($inputs['remainingAmount'] != 0) { if (isset($customerMembershipData)) { $addBirthday['membership_id'] = $customerMembershipData->id; $membership_data = MembershipTypes::find($customerMembershipData->membership_type_id); $addBirthday['membership_amount'] = $membership_data->fee_amount; } $firstpayment = PaymentDues::createBirthdaypaymentFirstdues($addBirthday); $addPaymentDues = PaymentDues::createBirthdaypaymentdues($addBirthday); } if (isset($addPaymentDues)) { $addBirthdayOrder = Orders::createBOrder($addBirthday, $firstpayment, $taxAmtapplied, $inputs); } else { $addBirthdayOrder = Orders::createBOrderwithoutPaymentDue($addBirthday, $addPaymentDues, $taxAmtapplied); } $addPaymentremainder = PaymentReminders::addReminderDates($addBirthday); $input['customerId'] = $addBirthday->customer_id; $input['birthday_id'] = $addBirthday->id; $input['student_id'] = $addBirthday->student_id; $input['commentType'] = 'ACTION_LOG'; $student_data = Students::find($addBirthday->student_id); $input['commentText'] = "Birthday celebration added for kid " . $student_data['student_name']; $input['commentStatus'] = 'ACTIVE/SCHEDULED'; Comments::addComments($input); $input['followupType'] = 'PAYMENT'; $input['commentStatus'] = 'REMINDER_CALL'; $input['commentType'] = 'VERYINTERESTED'; $input['commentText'] = "Call for Birthday celebration for kid " . $student_data['student_name']; $celebration_date = Carbon::createFromFormat('d M Y', $inputs['birthdayCelebrationDate']); if ($celebration_date->eq(carbon::now())) { Comments::addComments($input); } else { $celebration_date->subDay(); $input['reminderDate'] = $celebration_date->toDateString(); Comments::addComments($input); } if (isset($inputs['invoicePrintOption']) && $inputs['invoicePrintOption'] == 'yes') { $printUrl = url() . '/orders/Bprint/' . Crypt::encrypt($addBirthdayOrder); //$printUrl = url().'/orders/Bprint/'.$addBirthdayOrder; } else { $printUrl = ""; } //header('Access-Control-Allow-Origin: *'); if ($addBirthdayOrder) { return Response::json(array("status" => "success", "printUrl" => $printUrl)); } return Response::json(array("status" => "failed")); }
public function printBdayOrder($oid) { $orderid = Crypt::decrypt($oid); $order_data = Orders::where('orders.id', '=', $orderid)->get(); $customer_data = Customers::where('id', '=', $order_data[0]['customer_id'])->get(); $birthday_data = BirthdayParties::where('id', '=', $order_data[0]['birthday_id'])->get(); $student_data = Students::where('id', '=', $order_data[0]['student_id'])->get(); $order_data = $order_data[0]; if (isset($order_data['payment_dues_id'])) { $payment_due_data = PaymentDues::where('id', '=', $order_data['payment_dues_id'])->get(); $payment_due_data = $payment_due_data[0]; if (isset($payment_due_data->membership_id)) { $membershipData = CustomerMembership::find($payment_due_data->membership_id); $membershipTypeData = MembershipTypes::getMembershipTypeByID($membershipData->membership_type_id); $payment_due_data->description = $membershipTypeData->description; } } $customer_data = $customer_data[0]; $birthday_data = $birthday_data[0]; $student_data = $student_data[0]; $data = array('order_data', 'customer_data', 'birthday_data', 'student_data', 'payment_due_data'); // print_r($data); return View::make('pages.orders.bdayprintorder', compact($data)); }
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("/"); } }