Ejemplo n.º 1
0
 public static function limited_by_membership($id_seller)
 {
     if (intval(${${"GLOBALS"}["tpubctvvlkrd"]}) > 0 and Module::isInstalled("agilemembership") and intval(Configuration::get("AGILE_MEMBERSHIP_SELLER_INTE")) > 0) {
         include_once _PS_ROOT_DIR_ . "/modules/agilemultipleseller/SellerInfo.php";
         $igckop = "id_seller";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/agilemembership.php";
         $kkyparclft = "membershiptype";
         $lbvzyb = "membership";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/MembershipType.php";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/CustomerMembership.php";
         ${${"GLOBALS"}["qwrpbc"]} = new SellerInfo(SellerInfo::getIdBSellerId(${$igckop}));
         ${"GLOBALS"}["sjqvdo"] = "num";
         ${${"GLOBALS"}["rzogbmiaosx"]} = new CustomerMembership(CustomerMembership::getIdByCustomerId($sellerinfo->id_customer));
         if (!Validate::isLoadedObject(${$lbvzyb})) {
             return true;
         }
         ${$kkyparclft} = new MembershipType($membership->id_membership_type);
         if (!Validate::isLoadedObject(${${"GLOBALS"}["mbcacw"]})) {
             return true;
         }
         if (!AgileMembership::isActivated($sellerinfo->id_customer) or !AgileMembership::isMemberFeePaid($sellerinfo->id_customer)) {
             return true;
         }
         ${${"GLOBALS"}["sjqvdo"]} = AgileSellerManager::getAcitveProductsListed(${${"GLOBALS"}["tpubctvvlkrd"]});
         ${"GLOBALS"}["aeoptjd"] = "num";
         if (${${"GLOBALS"}["aeoptjd"]} >= intval($membershiptype->listing_max) and intval($membershiptype->listing_max) > 0) {
             return true;
         }
         return false;
     }
     return false;
 }
Ejemplo n.º 2
0
 public static function limited_by_membership($id_seller)
 {
     if (intval(${${"GLOBALS"}["pbiyrsaos"]}) > 0 and Module::isInstalled("agilemembership") and intval(Configuration::get("AGILE_MEMBERSHIP_SELLER_INTE")) > 0) {
         include_once _PS_ROOT_DIR_ . "/modules/agilemultipleseller/SellerInfo.php";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/agilemembership.php";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/MembershipType.php";
         $fufeamxcyjr = "membership";
         ${"GLOBALS"}["bqmujrr"] = "membership";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/CustomerMembership.php";
         $yltnxtalslm = "sellerinfo";
         ${$yltnxtalslm} = new SellerInfo(SellerInfo::getIdBSellerId(${${"GLOBALS"}["pbiyrsaos"]}));
         ${"GLOBALS"}["jarywcgnwfk"] = "id_seller";
         ${${"GLOBALS"}["bqmujrr"]} = new CustomerMembership(CustomerMembership::getIdByCustomerId($sellerinfo->id_customer));
         $iyqbnpykyel = "num";
         if (!Validate::isLoadedObject(${$fufeamxcyjr})) {
             return true;
         }
         ${${"GLOBALS"}["hjvoddgpxb"]} = new MembershipType($membership->id_membership_type);
         if (!Validate::isLoadedObject(${${"GLOBALS"}["hjvoddgpxb"]})) {
             return true;
         }
         if (!AgileMembership::isActivated($sellerinfo->id_customer) or !AgileMembership::isMemberFeePaid($sellerinfo->id_customer)) {
             return true;
         }
         ${$iyqbnpykyel} = AgileSellerManager::getAcitveProductsListed(${${"GLOBALS"}["jarywcgnwfk"]});
         if (${${"GLOBALS"}["vuefcasbu"]} >= intval($membershiptype->listing_max) and intval($membershiptype->listing_max) > 0) {
             return true;
         }
         return false;
     }
     return false;
 }
Ejemplo n.º 3
0
 static function getAllCustomerNonMembersByFranchiseeId($franchiseeId)
 {
     $presentdate = Carbon::now();
     $customer_members = CustomerMembership::where('membership_start_date', '<=', $presentdate->toDateString())->where('membership_end_date', '>=', $presentdate->toDateString())->select('customer_id')->get();
     $id;
     foreach ($customer_members as $c) {
         $id[] = $c['customer_id'];
     }
     $customers = Customers::where('franchisee_id', '=', $franchiseeId)->whereNotIn('id', $id)->orderBy('id', 'Desc')->get();
     return $customers;
 }
Ejemplo n.º 4
0
 static function getMemberCount()
 {
     return CustomerMembership::join('customers', 'customer_membership.customer_id', '=', 'customers.id')->where('customers.franchisee_id', '=', Session::get('franchiseId'))->count();
 }
Ejemplo n.º 5
0
 public static function limited_by_membership($id_seller)
 {
     if (intval(${${"GLOBALS"}["ghjbfbenq"]}) > 0 and Module::isInstalled("agilemembership") and intval(Configuration::get("AGILE_MEMBERSHIP_SELLER_INTE")) > 0) {
         $fdlzwmoqj = "num";
         include_once _PS_ROOT_DIR_ . "/modules/agilemultipleseller/SellerInfo.php";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/agilemembership.php";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/MembershipType.php";
         $wpdcvqoxy = "sellerinfo";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/CustomerMembership.php";
         ${$wpdcvqoxy} = new SellerInfo(SellerInfo::getIdBSellerId(${${"GLOBALS"}["ghjbfbenq"]}));
         ${${"GLOBALS"}["wvxnbvhc"]} = new CustomerMembership(CustomerMembership::getIdByCustomerId($sellerinfo->id_customer));
         if (!Validate::isLoadedObject(${${"GLOBALS"}["wvxnbvhc"]})) {
             return true;
         }
         ${${"GLOBALS"}["ulmwafwenh"]} = new MembershipType($membership->id_membership_type);
         if (!Validate::isLoadedObject(${${"GLOBALS"}["ulmwafwenh"]})) {
             return true;
         }
         if (!AgileMembership::isActivated($sellerinfo->id_customer) or !AgileMembership::isMemberFeePaid($sellerinfo->id_customer)) {
             return true;
         }
         ${${"GLOBALS"}["ntqtncirr"]} = AgileSellerManager::getAcitveProductsListed(${${"GLOBALS"}["ghjbfbenq"]});
         if (${$fdlzwmoqj} >= intval($membershiptype->listing_max) and intval($membershiptype->listing_max) > 0) {
             return true;
         }
         return false;
     }
     return false;
 }
Ejemplo n.º 6
0
 public static function limited_by_membership($id_seller)
 {
     if (intval($id_seller) > 0 and Module::isInstalled('agilemembership') and intval(Configuration::get('AGILE_MEMBERSHIP_SELLER_INTE')) > 0) {
         include_once _PS_ROOT_DIR_ . "/modules/agilemultipleseller/SellerInfo.php";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/agilemembership.php";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/MembershipType.php";
         include_once _PS_ROOT_DIR_ . "/modules/agilemembership/CustomerMembership.php";
         $sellerinfo = new SellerInfo(SellerInfo::getIdBSellerId($id_seller));
         $membership = new CustomerMembership(CustomerMembership::getIdByCustomerId($sellerinfo->id_customer));
         if (!Validate::isLoadedObject($membership)) {
             return true;
         }
         $membershiptype = new MembershipType($membership->id_membership_type);
         if (!Validate::isLoadedObject($membershiptype)) {
             return true;
         }
         if (!AgileMembership::isActivated($sellerinfo->id_customer) or !AgileMembership::isMemberFeePaid($sellerinfo->id_customer)) {
             return true;
         }
         $num = AgileSellerManager::getAcitveProductsListed($id_seller);
         if ($num >= intval($membershiptype->listing_max) and intval($membershiptype->listing_max) > 0) {
             return true;
         }
         return false;
     }
     return false;
 }
Ejemplo n.º 7
0
 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"));
 }
Ejemplo n.º 8
0
 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));
 }
Ejemplo n.º 9
0
 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("/");
     }
 }
Ejemplo n.º 10
0
 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     if (Auth::check()) {
         $currentPage = "";
         $mainMenu = "DASHBOARD";
         //customers or Inquiries
         $todaysCustomerReg = Customers::getCustomertodaysRegCount();
         $customerCount = Customers::getCustomerCount();
         //Members or Family Members
         $todaysMemberReg = CustomerMembership::getMembertodaysRegCount();
         $membersCount = CustomerMembership::getMemberCount();
         //Non Members or prospects
         $todaysNonmemberReg = CustomerMembership::getNonMembertodaysRegCount();
         $NonmembersCount = CustomerMembership::getNonMemberCount();
         //Enrolled customers(kids)
         $todaysEnrolledCustomers = StudentClasses::getTodaysEnrolledCustomers();
         $enrolledCustomers = StudentClasses::getEnrolledCustomers();
         //for followups
         $reminderCount = Comments::getReminderCountByFranchiseeId();
         //Introvisit
         $totalIntrovisitCount = IntroVisit::getIntrovistCount();
         $introVisitCount = IntroVisit::getIntrovisitBytoday();
         $allIntrovisits = IntroVisit::getAllActiveIntrovisit();
         for ($i = 0; $i < count($allIntrovisits); $i++) {
             $data = Comments::where('introvisit_id', '=', $allIntrovisits[$i]['id'])->orderBy('id', 'DESC')->first();
             if (isset($data)) {
                 $allIntrovisits[$i]['followup_status'] = $data['followup_status'];
             }
         }
         //for courses
         $totalParentchildCourse = Classes::getallParentchildCourseCount();
         $totalPrekgKindergarten = Classes::getallPrekgKindergartenCount();
         $totalGradeschool = Classes::getallGradeschoolCount();
         $totalCourses = $totalParentchildCourse + $totalPrekgKindergarten + $totalGradeschool;
         //for birthdayparty
         $totalbpartyCount = BirthdayParties::getBpartyCount();
         $todaysbpartycount = BirthdayParties::getBpartyCountBytoday();
         $todaysFollowup = Comments::getAllFollowup();
         $todaysIntrovisit = BatchSchedule::getTodaysIntroVisits();
         $activeRemindersCount = Comments::getAllFollowupActive();
         //get birthday dates
         $startdate = new carbon();
         $startdate->startOfYear();
         $endofyear = new carbon();
         $endofyear = $endofyear->endOfYear();
         $student_id = array();
         $birthday_celebration_data = BirthdayParties::where('created_at', '>=', $startdate->toDateString())->where('created_at', '<=', $endofyear->toDateString())->select('student_id')->get();
         //var_dump($birthday_celebration_data); die();
         for ($i = 0; $i < count($birthday_celebration_data); $i++) {
             $student_id[$i] = $birthday_celebration_data[$i]['student_id'];
         }
         $dat = new carbon();
         $month = $dat->month;
         $presentdate = $dat->day;
         // for rest of the days of month
         $birthday_data = Students::whereNotIn('id', $student_id)->where('student_date_of_birth', '<>', '')->where(DB::raw('MONTH(student_date_of_birth)'), '=', $month)->where(DB::raw('DATE(student_date_of_birth)'), '>', $presentdate)->where('franchisee_id', '=', Session::get('franchiseId'))->orderBy(DB::raw('DAY(student_date_of_birth)'))->get();
         //  echo $month; die();
         for ($i = 0; $i < count($birthday_data); $i++) {
             $customer_data = Customers::where('id', '=', $birthday_data[$i]['customer_id'])->get();
             $birthday_data[$i]['customer_name'] = $customer_data[0]['customer_name'];
             $birthday_data[$i]['mobile_no'] = $customer_data[0]['mobile_no'];
             $birthday_data[$i]['membership'] = CustomerMembership::where('customer_id', '=', $birthday_data[$i]['customer_id'])->count();
         }
         $m = $month;
         $m++;
         while ($m <= 12) {
             $birthday_data_month[] = Students::whereNotIn('id', $student_id)->where('student_date_of_birth', '<>', '')->where(DB::raw('MONTH(student_date_of_birth)'), '=', $m)->where('franchisee_id', '=', Session::get('franchiseId'))->orderBy(DB::raw('DAY(student_date_of_birth)'))->get();
             $m++;
         }
         // for starting months
         $m = 1;
         while ($m < $month) {
             $birthday_data_month[] = Students::whereNotIn('id', $student_id)->where('student_date_of_birth', '<>', '')->where(DB::raw('MONTH(student_date_of_birth)'), '=', $m)->where('franchisee_id', '=', Session::get('franchiseId'))->orderBy(DB::raw('DAY(student_date_of_birth)'))->get();
             $m++;
         }
         for ($i = 0; $i < count($birthday_data_month); $i++) {
             for ($j = 0; $j < count($birthday_data_month[$i]); $j++) {
                 $customer_data = Customers::where('id', '=', $birthday_data_month[$i][$j]['customer_id'])->get();
                 $birthday_data_month[$i][$j]['customer_name'] = $customer_data[0]['customer_name'];
                 $birthday_data_month[$i][$j]['mobile_no'] = $customer_data[0]['mobile_no'];
                 $birthday_data_month[$i][$j]['membership'] = CustomerMembership::where('customer_id', '=', $birthday_data_month[$i][$j]['customer_id'])->count();
             }
         }
         // var_dump($birthday_data_month);exit();
         //for starting days of present month
         $birthday_month_startdays = Students::whereNotIn('id', $student_id)->where('student_date_of_birth', '<>', '')->where(DB::raw('MONTH(student_date_of_birth)'), '=', $month)->where(DB::raw('DATE(student_date_of_birth)'), '<', $presentdate)->where('franchisee_id', '=', Session::get('franchiseId'))->orderBy(DB::raw('DAY(student_date_of_birth)'))->get();
         for ($i = 0; $i < count($birthday_month_startdays); $i++) {
             $customer_data = Customers::where('id', '=', $birthday_month_startdays[$i]['customer_id'])->get();
             $birthday_month_startdays[$i]['customer_name'] = $customer_data[0]['customer_name'];
             $birthday_month_startdays[$i]['mobile_no'] = $customer_data[0]['mobile_no'];
             $birthday_month_startdays[$i]['membership'] = CustomerMembership::where('customer_id', '=', $birthday_month_startdays[$i]['customer_id'])->count();
         }
         //for birthday celebration this week
         $presentdate = new carbon();
         $weeekdate = new carbon();
         $weeekdate->addDays(7);
         $birthdayPresentWeek = BirthdayParties::where('birthday_party_date', '>=', $presentdate->toDateString())->where('birthday_party_date', '<=', $weeekdate->toDateString())->get();
         for ($i = 0; $i < count($birthdayPresentWeek); $i++) {
             $customer_data = Customers::where('id', '=', $birthdayPresentWeek[$i]['customer_id'])->get();
             $birthdayPresentWeek[$i]['customer_name'] = $customer_data[0]['customer_name'];
             $birthdayPresentWeek[$i]['mobile_no'] = $customer_data[0]['mobile_no'];
             $birthdayPresentWeek[$i]['franchisee_id'] = $customer_data[0]['franchisee_id'];
             $student_data = Students::where('id', '=', $birthdayPresentWeek[$i]['student_id'])->get();
             $birthdayPresentWeek[$i]['student_name'] = $student_data[0]['student_name'];
         }
         $f_id = Session::get('franchiseId');
         $viewData = array('currentPage', 'mainMenu', 'f_id', 'birthday_data', 'birthday_data_month', 'birthday_month_startdays', 'birthdayPresentWeek', 'todaysMemberReg', 'membersCount', 'todaysNonmemberReg', 'NonmembersCount', 'customerCount', "reminderCount", 'totalbpartyCount', 'todaysbpartycount', 'totalParentchildCourse', 'totalPrekgKindergarten', 'totalGradeschool', 'totalCourses', 'todaysCustomerReg', 'todaysEnrolledCustomers', 'enrolledCustomers', 'totalIntrovisitCount', 'introVisitCount', 'allIntrovisits', 'todaysFollowup', 'todaysIntrovisit', 'activeRemindersCount');
         return View::make('pages.dashboard.upcoming', compact($viewData));
     } else {
         return Redirect::to("/");
     }
 }