<?php

namespace App\Http\Controllers;
namespace App\Http\Controllers\Admin;

use App\User;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Input;

use App\Center4Tech\Admin\Attendance;
use App\Center4Tech\Admin\Student;
use App\Center4Tech\Admin\Studentphoto;
use App\Center4Tech\Admin\Studentparent;
use App\Center4Tech\Admin\Enrollment;
use App\Center4Tech\Admin\Studentpickup;
use App\Center4Tech\Admin\Pin;
use App\Center4Tech\Admin\Studentproxy;
use App\Center4Tech\Admin\Studentcourse;
use App\Center4Tech\Admin\Studentproxyphoto;
use App\Center4Tech\Admin\Parentphone;
use App\Center4Tech\Admin\Course;
use App\Center4Tech\Admin\Studentfeeding;
use App\Center4Tech\Admin\Studentlaptoprental;
use App\Center4Tech\Admin\Studentexpo;
use App\Center4Tech\Admin\Payment;
use App\Center4Tech\Admin\Paymentmethod;
use App\Center4tech\Admin\Studentcampmaterial;
use App\Center4Tech\Admin\Cpaneldeploy;

use Hash;
use Validator;
use Redirect;
use Session;
use Mail;
use File;
use Image;
use Crypt;
use Auth;
use DB;

class C4techDataController extends Controller
{

    public function result(){

        // return dd( Input::all() );

        $center = Input::get("center");
        $course = Input::get("course");
        $parentInfo = Input::get("parent-info");
        $feedingList = Input::get("feeding-list");
        $kitCollectionList = Input::get("kit-colection-list");
        $paymentStatus = Input::get("payment-status");
        $verifiedPayment = Input::get("verified-payments");
        $attendanceList = Input::get("attendance-list");
        $laptopRentalList = Input::get("laptop-rental-list");
        $pinList = Input::get("pins-list");
        $siblings = Input::get("siblings");
        $gender = Input::get("gender");
        $birthday = Input::get("birthdays");
        $schoolList = Input::get("school-list");
        $schoolLocation = Input::get("school-location");
        $studentAge = Input::get("student-age");
        $studentClass = Input::get("student-class");
        $stateOfOrigin = Input::get("state-of-origin");
        $chequeList = Input::get("cheque-list");



        $results = DB::table('enrollments')
                 ->join('students', 'enrollments.id', '=', 'students.enrollment_id')
                 ->join('parents', 'enrollments.id', '=', 'parents.enrollment_id')
                 // ->join('student_pickups', 'enrollments.id', '=', 'student_pickups.enrollment_id')
                 ->join('pins', 'enrollments.id', '=', 'pins.enrollment_id')
                 ->join('student_proxies', 'enrollments.id', '=', 'student_proxies.enrollment_id')
                 ->join('student_courses', 'enrollments.id', '=', 'student_courses.enrollment_id')
                 ->join('student_feedings', 'enrollments.id', '=', 'student_feedings.enrollment_id')
                 ->join('student_laptop_rentals', 'enrollments.id', '=', 'student_laptop_rentals.enrollment_id')
                 ->join('student_expos', 'enrollments.id', '=', 'student_expos.enrollment_id')
                 ->join('payments', 'enrollments.id', '=', 'payments.enrollment_id')
                 ->join('payment_methods', 'enrollments.id', '=', 'payment_methods.enrollment_id')
                 ->join('student_camp_materials', 'enrollments.id', '=', 'student_camp_materials.enrollment_id')
                 ->join('attendances', 'enrollments.id', '=', 'attendances.enrollment_id')
                 ->select('students.center',
                          'students.student_name',
                          'students.student_dob',
                          'students.student_sex',
                          'students.student_email',
                          'students.student_phone',
                          'students.student_home_address',
                          'students.student_city',
                          'students.student_school_name',
                          'students.student_school_city',
                          'students.student_school_state',
                          'students.student_state_of_origin',
                          'students.student_school_address',
                          'students.student_school_class',
                          'students.created_at',
                          'parents.parent_title',
                          'parents.parent_name',
                          'parents.relationship',
                          'parents.parent_email',
                          'parents.parent_phone',
                          'parents.parent_home_address',
                          'parents.parent_work_address',
                          'parents.parent_office_address',
                          'parents.created_at',
                          /*'student_pickups.child_self_pickup',
                          'student_pickups.drop_off_by_center4tech',
                          'student_pickups.parent_or_guardian_pick_up',
                          'student_pickups.proxy_pick_up',
                          'student_pickups.created_at',*/
                          'pins.pin_owner_name',
                          'pins.user_type',
                          'pins.status',
                          'pins.sign_in_pin',
                          'pins.sign_out_pin',
                          'pins.pick_up_pin',
                          'pins.drop_off_pin',
                          'pins.created_at',
                          'student_proxies.proxy_title',
                          'student_proxies.proxy_name',
                          'student_proxies.proxy_gender',
                          'student_proxies.proxy_phone',
                          'student_proxies.proxy_relationship',
                          'student_proxies.created_at',
                          'student_courses.course_name',
                          'student_courses.course_type',
                          'student_courses.course_price',
                          'student_courses.center',
                          'student_courses.computer_usage_proficiency',
                          'student_courses.created_at',
                          'student_feedings.feeding_pack_label',
                          'student_feedings.feeding_price',
                          'student_feedings.feeding_start_date',
                          'student_feedings.feeding_end_date',
                          'student_feedings.feeding_expire_notification_sms',
                          'student_feedings.feeding_expire_notification_email',
                          'student_feedings.feeding_expire_notification_parent_reminder',
                          'student_feedings.created_at',
                          'student_laptop_rentals.laptop_rental_label',
                          'student_laptop_rentals.laptop_rental_price',
                          'student_laptop_rentals.laptop_rental_start_date',
                          'student_laptop_rentals.laptop_rental_end_date',
                          'student_laptop_rentals.laptop_rental_expire_notification_sms',
                          'student_laptop_rentals.laptop_rental_expire_notification_email',
                          'student_laptop_rentals.laptop_rental_expire_notification_parent_reminder',
                          'student_laptop_rentals.is_rented',
                          'student_laptop_rentals.is_returned',
                          'student_laptop_rentals.created_at',
                          'student_expos.expo_fees',
                          'student_expos.expo_price',
                          'student_expos.created_at',
                          'payments.payment_type',
                          'payments.invoice_number',
                          'payments.item_description',
                          'payments.quantity',
                          'payments.rate',
                          'payments.discount',
                          'payments.total',
                          'payments.transaction_date',
                          'payments.verified',
                          'payments.invoice_sent',
                          'payments.invoice_sent_by_sms',
                          'payments.invoice_sent_by_email',
                          'payments.invoice_sent_date',
                          'payments.created_at',
                          'payment_methods.payment_option',
                          'payment_methods.payment_amount',
                          'payment_methods.cash_payment_confirmation',
                          'payment_methods.cash_transaction_timestamp',
                          'payment_methods.bank_pos_provider',
                          'payment_methods.bank_pos_transaction_date',
                          'payment_methods.bank_pos_transaction_time',
                          'payment_methods.bank_pos_stan',
                          'payment_methods.bank_pos_rrn',
                          'payment_methods.bank_pos_ref_no',
                          'payment_methods.bank_online_sender_account_name',
                          'payment_methods.bank_online_sender_account_number',
                          'payment_methods.bank_online_sender_bank',
                          'payment_methods.bank_online_transaction_date',
                          'payment_methods.bank_online_miu_research_bank_acc_paid_into',
                          'payment_methods.bank_online_payment_channel',
                          'payment_methods.cheque_name',
                          'payment_methods.cheque_date_to_pay_in',
                          'payment_methods.cheque_to_be_paid_in_now',
                          'payment_methods.cheque_is_post_dated',
                          'payment_methods.cheque_notification_reminder',
                          'payment_methods.bank_teller_depositor_name',
                          'payment_methods.bank_teller_transaction_date',
                          'payment_methods.bank_teller_miu_research_bank_acc_paid_into',
                          'payment_methods.is_splited_by_cash',
                          'payment_methods.split_pay_cash_amount',
                          'payment_methods.is_splited_by_pos',
                          'payment_methods.split_pay_pos_amount',
                          'payment_methods.is_splited_by_bank_transfer_online',
                          'payment_methods.split_pay_bank_transfer_pc_mobile_amount',
                          'payment_methods.is_splited_by_teller',
                          'payment_methods.split_pay_deposit_teller_amount',
                          'payment_methods.is_splited_by_cheque',
                          'payment_methods.split_pay_cheque_amount',
                          'payment_methods.is_parted_by_cash',
                          'payment_methods.is_parted_by_pos',
                          'payment_methods.is_parted_by_bank_transfer',
                          'payment_methods.is_parted_by_teller',
                          'payment_methods.is_parted_by_cheque',
                          'payment_methods.advance_payment_amount',
                          'payment_methods.balance_payment_outstanding',
                          'payment_methods.balance_payment_due_date',
                          'payment_methods.balance_payment_status',
                          'payment_methods.pdf_generated',
                          'payment_methods.receipt_sent',
                          'payment_methods.receipt_sent_by_sms',
                          'payment_methods.receipt_sent_by_email',
                          'payment_methods.receipt_sent_by_pdf',
                          'payment_methods.receipt_sent_date',
                          'payment_methods.status',
                          'payment_methods.created_at',
                          'student_camp_materials.course_material_given',
                          'student_camp_materials.electronic_kit_given',
                          'student_camp_materials.enrollment_completed',
                          'student_camp_materials.enrollment_not_completed',
                          'student_camp_materials.created_at',
                          'attendances.present',
                          'attendances.absent',
                          'attendances.sign_in',
                          'attendances.sign_out',
                          'attendances.operation',
                          'attendances.extra',
                          'attendances.created_at',
                         )
                // ->orWhere('students.center','LIKE','%'.$center.'%')
                 ->orWhere('students.center',$center)
                 ->orWhere('student_courses.course_name',$course)
                 ->orWhere('parents.parent_phone')
                 ->orWhere('parents.parent_email')
                 ->orWhere('parents.parent_office_address')
                 /*->orWhere(function($query){

                    $parentInfo = Input::get("parent-info");

                    if ( $parentInfo == "parent-phone" ) {
                        $query->where('parents.parent_phone');
                    }

                    if ( $parentInfo == "parent-email" ) {
                        $query->where('parents.parent_email');
                    }

                    if ( $parentInfo == "parent-address" ) {
                        $query->where('parents.parent_address');
                    }

                    if ( $parentInfo == "parent-office-address" ) {
                        $query->where('parents.parent_office_address');
                    }
                })*/
                 ->orWhere('student_courses.course_name',$course)
                 ->get();


        /*if ( isset($center) ) {

            $results = Student::where("center",$center)->get();
        }

        if ( isset($course) ) {

            $results = Studentcourse::where("course_name",$course)->get();
        }*/

        return $results;

        // return view('app_views.admin.data-list-results')->with( 'results' , $results );




    }


}