| Server IP : 199.250.214.225 / Your IP : 3.129.21.30 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/funds.upgrade.nicn.gov.ng/funds-upgraded/app/Http/Controllers/ |
Upload File : |
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
//use Illuminate\Http\Support\Facade\View;
use App\Http\Requests;
use Illuminate\Support\Facades\Input;
use DB;
class ContractorListController extends ParentController
{
public function index(Request $request){
$data['error'] = "";
$data['warning'] = "";
$data['success'] = "";
$data['add_contractor'] = "";
$contractor = trim($request['contractor']);
$phone = trim($request['phone']);
$address = trim($request['address']);
$email = trim($request['email']);
$bank = trim($request['bank']);
$account = trim($request['account']);
$sortcode = trim($request['sortcode']);
$tin = trim($request['tin']);
$id = trim($request['C_id']);
$status = trim($request['status']);
$add_attachment = Input::get('add_attachment');
$data['documenttype']=DB::table('tbldocumenttypes')->get();
$data['contractorList'] = $this->getContractors();
$data['banklist'] = $this->GetBankList();//Pass the bank list to the data array
if(isset($_POST['add'])){
$this->validate($request, [
'contractor' => 'required',
'tin' => 'required',
]);
$cid=DB::table('tblcontractor_list')->insertGetId(array(
'contractor' => $contractor,
'address' => $address,
'phoneNo' => $phone,
'emailAddress' => $email,
'Banker' => $bank,
'AccountNo' => $account,
'sortCode' => $sortcode,
'TIN' => $tin,
'status' => 1,
));
$data['success'] = "$contractor successfully added";
$data['contractorList'] = $this->getContractors();
$data['add_contractor'] = "added";
return view('contractor.contractor_list', $data);
}
elseif(isset($_POST['add_attachment'])){
/*
$this->validate($request, [
'contractor' => 'required',
'tin' => 'required',
]);
$cid=DB::table('tblcontractor_temp_list')->insertGetId(array(
'contractor' => $contractor,
'address' => $address,
'phoneNo' => $phone,
'emailAddress' => $email,
'Banker' => $bank,
'AccountNo' => $account,
'sortCode' => $sortcode,
'TIN' => $tin,
'status' => 1,
));
*/
//$data['temp_id']=$cid;
//return view('contractor.attachment_list', $data);
if($request->hasfile('filename'))
{
$file=$request->file('filename');
$orgname=$file->getClientOriginalName();
$file->move(public_path().'/../../nfunds.nicn.gov.ng/contrator_attachments', $orgname);
DB::table('tblcontractor_attachment')->insert([
'filename' => $orgname,
'contractorID' => $cid,
]);
}
if($request->hasfile('filename3'))
{
foreach($request->file('filename3') as $file)
{
$i=1;
$originalname=$file->getClientOriginalName();
$file->move(public_path().'/../../nfunds.nicn.gov.ng/contrator_attachments', $originalname);
DB::table('tblcontractor_attachment')->insert([
'filename' => $originalname,
'contractorID' => $cid,
]);
}
}
$data['success'] = "$contractor successfully added";
$data['contractorList'] = $this->getContractors();
return view('contractor.contractor_list', $data);
}
else {
if(isset($_POST['edit'])){
$this->validate($request, [
'contractor' => 'required',
//'phone' => 'required',
]);
DB::table('tblcontractor_list')->where('id',$id)->update([
'contractor' => $contractor,
'address' => $address,
'phoneNo' => $phone,
'emailAddress' => $email,
'Banker' => $bank,
'AccountNo' => $account,
'sortCode' => $sortcode,
'TIN' => $tin,
'status' => $status,
]);
$data['success'] = "$contractor successfully Edited";
$data['contractorList'] = $this->getContractors();
return view('contractor.contractor_list', $data);
} elseif (isset($_POST['delete'])) {
# code...
$id = trim($request['C_id']);
$confirm = $this->checkContractor($id);
if ($confirm == TRUE) {
$data['warning'] = "Contractor cannot be deleted";
$data['contractorList'] = $this->getContractors();
return view('contractor.contractor_list', $data);
} else {
DB::table('tblcontractor_list')->where('id', $id)->delete();
DB::table('tblcontractor_attachment')->where('contractorID', $id)->delete();
$data['success'] = "$contractor successfully Deleted";
$data['contractorList'] = $this->getContractors();
return view('contractor.contractor_list', $data);
}
}
}
return view('contractor.contractor_list', $data);
}
/********** THIS FUNCTION GETS ALL BANKS TO BE DISPLAYED ON THE LAYOUT ***************/
public function GetBankList(){
$bank = DB::table('tblbanklist')->select('bankID', 'bank')->get(); //Select all banks form database
return $bank;
}
public function checkContractor($companyID){
$bank = DB::table('tblcontractDetails')
->select('*')
->where('companyID', $companyID)
->get(); //Select all banks form database
return $bank;
}
public function getContractors(){
$list = DB::table('tblcontractor_list')
->leftjoin('tblbanklist', 'tblbanklist.bankID', '=', 'tblcontractor_list.Banker')
//->leftjoin('tblcontractor_attachment', 'tblcontractor_list.id', '=', 'tblcontractor_attachment.contractorID')
->where('tblcontractor_list.id', '<>', 13)
->select('*')
->orderBy('contractor', 'Asc')
->get();
return $list;
}
}