public function checkmultiPayOrderDate() { $inputs = Input::all(); $batch_data = Batches::find($inputs['batchid']); $eachClassCost = $batch_data->class_amount; $startdate = new carbon(); $enddate = new carbon(); $startdate = $startdate->createFromFormat('m/d/Y', $inputs['startdate']); $enddate = $enddate->createFromFormat('m/d/Y', $inputs['enddate']); if (isset($inputs['multipayAmount1'])) { $firstPayWeeksNo = $inputs['multipayAmount1'] / $eachClassCost; } if (isset($inputs['multipayAmount2'])) { $secondPayWeeksNo = $inputs['multipayAmount2'] / $eachClassCost; } if (isset($inputs['multipayAmount3'])) { $thirdPayWeeksNo = $inputs['multipayAmount3'] / $eachClassCost; } if (isset($inputs['multipayAmount4'])) { $fourthPayWeeksNo = $inputs['multipayAmount4'] / $eachClassCost; } //$totalweekNo=$firstPayWeeksNo+$secondPayWeeksNo+$thirdPayWeeksNo+$fourthPayWeeksNo; $batch_data = BatchSchedule::where('batch_id', '=', $inputs['batchid'])->where('franchisee_id', '=', Session::get('franchiseId'))->where('season_id', '=', $inputs['seasonid'])->whereBetween('schedule_date', array($startdate->toDateString(), $enddate->toDateString()))->where('holiday', '!=', 1)->orderBy('id')->get(); $firstPayWeeksNo = $firstPayWeeksNo - 1; if (isset($inputs['multipayAmount2'])) { $secondPayWeeksNo = $secondPayWeeksNo + $firstPayWeeksNo; } if (isset($inputs['multipayAmount3'])) { $thirdPayWeeksNo = $secondPayWeeksNo + $thirdPayWeeksNo; } if (isset($inputs['multipayAmount4'])) { $fourthPayWeeksNo = $thirdPayWeeksNo + $fourthPayWeeksNo; } $presentdate = new carbon(); $presentdate = $presentdate->now(); $secondPaymentDate = new carbon(); $thirdPaymentDate = new carbon(); $fourthPaymentDate = new carbon(); if (isset($inputs['multipayAmount2'])) { $secondPaymentDate = $secondPaymentDate->createFromFormat('Y-m-d', $batch_data[$firstPayWeeksNo]['schedule_date']); } if (isset($inputs['multipayAmount3'])) { $thirdPaymentDate = $thirdPaymentDate->createFromFormat('Y-m-d', $batch_data[$secondPayWeeksNo]['schedule_date']); } if (isset($inputs['multipayAmount4'])) { $fourthPaymentDate = $fourthPaymentDate->createFromFormat('Y-m-d', $batch_data[$thirdPayWeeksNo]['schedule_date']); } if (isset($inputs['multipayAmount4'])) { if ($presentdate->gt($fourthPaymentDate)) { return Response::json(array('status' => 'four')); } } if (isset($inputs['multipayAmount3'])) { if ($presentdate->gt($thirdPaymentDate)) { return Response::json(array('status' => 'three')); } } if (isset($inputs['multipayAmount2'])) { if ($presentdate->gt($secondPaymentDate)) { return Response::json(array('status' => 'two', 'date' => $secondPaymentDate)); } } //return Response::json(array('status'=>$batch_data)); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $inputs = Input::all(); $batch_data = Batches::find($inputs['batchId']); $eachClassCost = $batch_data->class_amount; $availableSession = $inputs['availableSession']; $paymentTypes = array(); $modulus = ""; $round = ""; if ($availableSession > 30) { $modulus = $availableSession % 20; if ($modulus) { $round = $availableSession - $modulus; } $bipayInstallments = 2; $bipayFirstInstallment = $modulus; $bipaySecondInstallment = 20; $arrayCount['bipay']['eligible'] = "YES"; $arrayCount['bipay']['installments'] = 2; if ($modulus) { $arrayCount['bipay']['pays']['0']['dues'] = $modulus; $arrayCount['bipay']['pays']['0']['amount'] = $modulus * $eachClassCost; } else { $arrayCount['bipay']['pays']['0']['dues'] = 20; $arrayCount['bipay']['pays']['0']['amount'] = 20 * $eachClassCost; } $arrayCount['bipay']['pays']['1']['dues'] = 20; $arrayCount['bipay']['pays']['1']['amount'] = 20 * $eachClassCost; $modulus = $availableSession % 10; if ($modulus) { $round = $availableSession - $modulus; } $arrayCount['multipay']['eligible'] = "YES"; $arrayCount['multipay']['installments'] = 4; if ($modulus) { $arrayCount['multipay']['pays']['0']['dues'] = $modulus; $arrayCount['multipay']['pays']['0']['amount'] = $modulus * $eachClassCost; } else { $arrayCount['multipay']['pays']['0']['dues'] = 10; $arrayCount['multipay']['pays']['0']['amount'] = 10 * $eachClassCost; } $arrayCount['multipay']['pays']['1']['dues'] = 10; $arrayCount['multipay']['pays']['1']['amount'] = 10 * $eachClassCost; $arrayCount['multipay']['pays']['2']['dues'] = 10; $arrayCount['multipay']['pays']['2']['amount'] = 10 * $eachClassCost; $arrayCount['multipay']['pays']['3']['dues'] = 10; $arrayCount['multipay']['pays']['3']['amount'] = 10 * $eachClassCost; } else { if ($availableSession > 10 && $availableSession <= 20) { $modulus = $availableSession % 10; if ($modulus) { $round = $availableSession - $modulus; } $bipayInstallments = 2; $bipayFirstInstallment = $modulus; $bipaySecondInstallment = 10; $arrayCount['bipay']['eligible'] = "NO"; $arrayCount['multipay']['eligible'] = "YES"; $arrayCount['multipay']['installments'] = $bipayInstallments; if ($modulus) { $arrayCount['multipay']['pays']['0']['dues'] = $modulus; $arrayCount['multipay']['pays']['0']['amount'] = $modulus * $eachClassCost; } else { $arrayCount['multipay']['pays']['0']['dues'] = 10; $arrayCount['multipay']['pays']['0']['amount'] = 10 * $eachClassCost; } $arrayCount['multipay']['pays']['1']['dues'] = $bipaySecondInstallment; $arrayCount['multipay']['pays']['1']['amount'] = $bipaySecondInstallment * $eachClassCost; } else { if ($availableSession > 20 && $availableSession <= 30) { $modulus = $availableSession % 10; if ($modulus) { $round = $availableSession - $modulus; } $bipayInstallments = 2; $bipayFirstInstallment = $modulus; $bipaySecondInstallment = 10; $arrayCount['bipay']['eligible'] = "YES"; $arrayCount['bipay']['installments'] = 2; if ($modulus) { $arrayCount['bipay']['pays']['0']['dues'] = $modulus; $arrayCount['bipay']['pays']['0']['amount'] = $modulus * $eachClassCost; } else { $arrayCount['bipay']['pays']['0']['dues'] = 10; $arrayCount['bipay']['pays']['0']['amount'] = 10 * $eachClassCost; } $arrayCount['bipay']['pays']['1']['dues'] = 20; $arrayCount['bipay']['pays']['1']['amount'] = 20 * $eachClassCost; $arrayCount['multipay']['eligible'] = "YES"; $arrayCount['multipay']['installments'] = 3; if ($modulus) { $arrayCount['multipay']['pays']['0']['dues'] = $modulus; $arrayCount['multipay']['pays']['0']['amount'] = $modulus * $eachClassCost; } else { $arrayCount['multipay']['pays']['0']['dues'] = 10; $arrayCount['multipay']['pays']['0']['amount'] = 10 * $eachClassCost; } $arrayCount['multipay']['pays']['1']['dues'] = 10; $arrayCount['multipay']['pays']['1']['amount'] = 10 * $eachClassCost; $arrayCount['multipay']['pays']['2']['dues'] = 10; $arrayCount['multipay']['pays']['2']['amount'] = 10 * $eachClassCost; } else { if ($availableSession <= 10) { $modulus = $availableSession % 10; if ($modulus) { $round = $availableSession - $modulus; } $bipayInstallments = 2; $bipayFirstInstallment = $modulus; $bipaySecondInstallment = 10; $arrayCount['bipay']['eligible'] = "NO"; $arrayCount['bipay']['installments'] = 2; if ($modulus) { $arrayCount['bipay']['pays']['0']['dues'] = $modulus; $arrayCount['bipay']['pays']['0']['amount'] = $modulus * $eachClassCost; } else { $arrayCount['bipay']['pays']['0']['dues'] = 10; $arrayCount['bipay']['pays']['0']['amount'] = 10 * $eachClassCost; } $arrayCount['bipay']['pays']['1']['dues'] = 20; $arrayCount['bipay']['pays']['1']['amount'] = 20 * $eachClassCost; $arrayCount['multipay']['eligible'] = "NO"; $arrayCount['multipay']['installments'] = 3; if ($modulus) { $arrayCount['multipay']['pays']['0']['dues'] = $modulus; $arrayCount['multipay']['pays']['0']['amount'] = $modulus * $eachClassCost; } else { $arrayCount['multipay']['pays']['0']['dues'] = 10; $arrayCount['multipay']['pays']['0']['amount'] = 10 * $eachClassCost; } $arrayCount['multipay']['pays']['1']['dues'] = 10; $arrayCount['multipay']['pays']['1']['amount'] = 10 * $eachClassCost; $arrayCount['multipay']['pays']['2']['dues'] = 10; $arrayCount['multipay']['pays']['2']['amount'] = 10 * $eachClassCost; } else { if ($availableSession === 10) { $modulus = $availableSession % 10; if ($modulus) { $round = $availableSession - $modulus; } $bipayInstallments = 2; $bipayFirstInstallment = $modulus; $bipaySecondInstallment = 10; $arrayCount['bipay']['eligible'] = "NO"; $arrayCount['bipay']['installments'] = 2; if ($modulus) { $arrayCount['bipay']['pays']['0']['dues'] = $modulus; $arrayCount['bipay']['pays']['0']['amount'] = $modulus * $eachClassCost; } else { $arrayCount['bipay']['pays']['0']['dues'] = 10; $arrayCount['bipay']['pays']['0']['amount'] = 10 * $eachClassCost; } $arrayCount['bipay']['pays']['1']['dues'] = 20; $arrayCount['bipay']['pays']['1']['amount'] = 20 * $eachClassCost; $arrayCount['multipay']['eligible'] = "NO"; $arrayCount['multipay']['installments'] = 3; if ($modulus) { $arrayCount['multipay']['pays']['0']['dues'] = $modulus; $arrayCount['multipay']['pays']['0']['amount'] = $modulus * $eachClassCost; } else { $arrayCount['multipay']['pays']['0']['dues'] = 10; $arrayCount['multipay']['pays']['0']['amount'] = 10 * $eachClassCost; } $arrayCount['multipay']['pays']['1']['dues'] = 10; $arrayCount['multipay']['pays']['1']['amount'] = 10 * $eachClassCost; $arrayCount['multipay']['pays']['2']['dues'] = 10; $arrayCount['multipay']['pays']['2']['amount'] = 10 * $eachClassCost; } } } } } $arrayCount['round'] = $round; $arrayCount['modulus'] = $modulus; $arrayCount['singlepay'] = $availableSession * $eachClassCost; $arrayCount['status'] = "success"; //working for simple bipay bipay=(enrolled classes/2) if ($availableSession > 5) { $arrayCount['modifiedbipay']['elligible'] = 'YES'; $arrayCount['modifiedbipay']['installments'] = 2; if ($availableSession % 2 == 0) { $arrayCount['modifiedbipay']['pays']['0']['dues'] = $availableSession / 2; $arrayCount['modifiedbipay']['pays']['0']['amount'] = $availableSession / 2 * $eachClassCost; $arrayCount['modifiedbipay']['pays']['1']['dues'] = $availableSession / 2; $arrayCount['modifiedbipay']['pays']['1']['amount'] = $availableSession / 2 * $eachClassCost; } else { $firstsessioncount = (int) ($availableSession / 2); $secondsessioncount = (int) ($availableSession / 2) + 1; $arrayCount['modifiedbipay']['pays']['0']['dues'] = $firstsessioncount; $arrayCount['modifiedbipay']['pays']['0']['amount'] = $firstsessioncount * $eachClassCost; $arrayCount['modifiedbipay']['pays']['1']['dues'] = $secondsessioncount; $arrayCount['modifiedbipay']['pays']['1']['amount'] = $secondsessioncount * $eachClassCost; } } if ($arrayCount) { return Response::json(array("payments" => $arrayCount)); } return Response::json(array("status" => "failed")); }
}); Route::any('getCities', function () { $inputs = Input::all(); $id = $inputs['id']; $countryCode = $inputs['countryCode']; $cities = Cities::getCities($id, $countryCode); return Response::json($cities); }); Route::get('logout', "VaultController@logout"); }); Route::get('/test', function () { $base_price_no = Batches::find(130)->classes()->select('base_price_no')->get(); $base_price_no = $base_price_no[0]['base_price_no']; echo $base_price_no; die; var_dump(ClassBasePrice::where('base_price_no', '=', Batches::find(130)->classes()->base_price_no)->select('base_price')->get()); $classes_count = StudentClasses::where('student_id', '=', 88)->where('status', '=', 'enrolled')->distinct('class_id')->count(); var_dump($classes_count); exit; echo PaymentMaster::max('payment_no'); exit; echo Batches::where('id', '=', '2')->select('class_amount')->get(); exit; $data = IntroVisit::join('students', 'student_id', '=', 'students.id')->where('introvisit.customer_id', '=', '44')->get(); var_dump($data); exit; // 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]['membership']= CustomerMembership::where('customer_id','=',$birthday_data[$i]['customer_id'])->count(); //
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 getBatchRemainingClassesByBatchId() { $inputs = Input::all(); $batchClassesData = BatchSchedule::where('franchisee_id', '=', Session::get('franchiseId'))->where('batch_id', '=', $inputs['batchId'])->whereDate('schedule_date', '>=', $inputs['preferredStartDate'])->get(); $batchClassesCount = count($batchClassesData); $lastEndDate = $batchClassesData[$batchClassesCount - 1]['schedule_date']; $date = Carbon::now(); $date = $date->createFromFormat('Y-m-d', $lastEndDate); $date = $date->next(Carbon::MONDAY); //getting the batch cost from batch class //$class_data= ClassBasePrice::where('base_price_no','=',Batches::find($inputs['batchId'])->classes()->base_price_no)->select('base_price')->get(); //$classAmount=$batch_data->class_amount; $base_price_no = Batches::find($inputs['batchId'])->classes()->select('base_price_no')->get(); $base_price = ClassBasePrice::where('base_price_no', '=', $base_price_no[0]['base_price_no'])->get(); $base_price = $base_price[0]['base_price']; if ($batchClassesCount) { return Response::json(array('status' => 'success', 'classCount' => $batchClassesCount, 'lastdate' => $date->toDateString(), 'classAmount' => $base_price, 'enrollment_end_date' => $batchClassesData[count($batchClassesData) - 1]['schedule_date'], 'enrollment_start_date' => $batchClassesData[0]['schedule_date'])); } else { return Response::json(array('status' => 'failure')); } }