public function maintenanceCustomer()
{
$ids = DB::table('tblCustomer')->select('strCustId')->orderBy('created_at', 'desc')->orderBy('strCustId', 'desc')->take(1)->get();
$ID = $ids["0"]->strCustId;
$newID = $this->smart($ID);
$cust = MCustomer::all();
$carmodel = MCarModel::all();
return View::make('customerMaintenance')->with('customers', $cust)->with('carmodel', $carmodel)->with('newID', $newID);
}
public function carDetails()
{
$sum = 0;
$label = '';
$custid = Input::get('customerId');
$custcar = DB::table('tblCustCar')->join('tblCustomer', 'tblCustCar.strCCCust', '=', 'tblCustomer.strCustId')->join('tblCarModel', 'tblCustCar.strCCModel', '=', 'tblCarModel.strCarModelId')->join('tblCarType', 'tblCarModel.strCMType', '=', 'tblCarType.strCarTypeId')->join('tblCarBrand', 'tblCarModel.strCMBrand', '=', 'tblCarBrand.strCarBrandId')->select('tblCustCar.*', 'tblCarModel.strCarModelDesc', 'tblCustomer.strCustFName', 'tblCustomer.strCustMInit', 'tblCustomer.strCustLName', 'tblCarType.strCarTypeName', 'tblCarBrand.strCarBrandDesc')->get();
$carmodel = MCarModel::all();
return View::make('custcarMaintenance')->with('custcars', $custcar)->with('custid', $custid)->with('carmodels', $carmodel);
}