EVOLUTION-NINJA
Edit File: Asset.php
<?php namespace App\Controllers; class Asset extends BaseController { public function index() { $id=session()->get('id'); if($id){ return view('Asset/add_asset'); }else{ return redirect()->to('/'); } } public function add_asset_form() { $data=$this->request->getVar(); $data['created_at']=date('Y-m-d H:i:s'); $data['created_by']=session()->get('username'); $purchase_bill = $this->request->getFile('purchase_bill'); if ($purchase_bill->isValid() && !$purchase_bill->hasMoved()) { $newNamepurchase_bill = uniqid() . '.' . $purchase_bill->getClientExtension(); $purchase_bill->move('public/assets/asset_management', $newNamepurchase_bill); } else { return $this->response->setJSON(['result' => 0, 'message' => 'Failed to upload purchase bill']); // exit(); } $data['purchase_bill']=$newNamepurchase_bill; $upload_document = $this->request->getFile('upload_document'); if ($upload_document->isValid() && !$upload_document->hasMoved()) { $newNameupload_document = uniqid() . '.' . $upload_document->getClientExtension(); $upload_document->move('public/assets/asset_management', $newNameupload_document); } else { return $this->response->setJSON(['result' => 0, 'message' => 'Failed to upload document']); // exit(); } $data['upload_document']=$newNameupload_document; $agreement_document = $this->request->getFile('agreement_document'); if ($agreement_document->isValid() && !$agreement_document->hasMoved()) { $newNameagreement_document = uniqid() . '.' . $agreement_document->getClientExtension(); $agreement_document->move('public/assets/asset_management', $newNameagreement_document); } else { return $this->response->setJSON(['result' => 0, 'message' => 'Failed to agreement document']); // exit(); } $data['agreement_document']=$newNameagreement_document; $db=\Config\Database::connect(); $builder=$db->table('asset'); $insert=$builder->insert($data); if($insert){ return $this->response->setJSON(['result'=>1,'message'=>'Asset Added Successfully']); }else{ return $this->response->setJSON(['result'=>0,'message'=>'Asset Added failed']); } } public function update_asset_form() { $db = \Config\Database::connect(); $data = $this->request->getVar(); $sid = $this->request->getVar('id'); $data['created_at'] = date('Y-m-d H:i:s'); $data['created_by'] = session()->get('username'); $purchase_bill = $this->request->getFile('purchase_bill'); if ($purchase_bill->isValid() && !$purchase_bill->hasMoved()) { $newNamepurchase_bill = uniqid() . '.' . $purchase_bill->getClientExtension(); $purchase_bill->move('public/assets/asset_management', $newNamepurchase_bill); $data['purchase_bill'] = $newNamepurchase_bill; } else { $imagename = $db->table('asset')->select('purchase_bill')->where('id', $sid)->get()->getRowArray(); $data['purchase_bill'] = $imagename['purchase_bill']; } $upload_document = $this->request->getFile('upload_document'); if ($upload_document->isValid() && !$upload_document->hasMoved()) { $newNameupload_document = uniqid() . '.' . $upload_document->getClientExtension(); $upload_document->move('public/assets/asset_management', $newNameupload_document); $data['upload_document'] = $newNameupload_document; } else { $imagename = $db->table('asset')->select('upload_document')->where('id', $sid)->get()->getRowArray(); $data['upload_document'] = $imagename['upload_document']; } $agreement_document = $this->request->getFile('agreement_document'); if ($agreement_document->isValid() && !$agreement_document->hasMoved()) { $newNameagreement_document = uniqid() . '.' . $agreement_document->getClientExtension(); $agreement_document->move('public/assets/asset_management', $newNameagreement_document); $data['agreement_document'] = $newNameagreement_document; } else { $imagename = $db->table('asset')->select('agreement_document')->where('id', $sid)->get()->getRowArray(); $data['agreement_document'] = $imagename['agreement_document']; } $builder = $db->table('asset'); $update = $builder->where('id', $sid)->update($data); if ($update) { return $this->response->setJSON(['result' => 1, 'message' => 'Asset updated successfully']); } else { return $this->response->setJSON(['result' => 0, 'message' => 'Asset update failed']); } } public function asset_list() { $id=session()->get('id'); if($id){ return view('Asset/asset_list'); }else{ return redirect()->to('/'); } } public function asset_list_data() { $id=session()->get('id'); if($id){ $db = \Config\Database::connect(); $builder = $db->table('asset'); $data = $builder->get()->getResultArray(); // print_r($data);die(); if($data){ return $this->response->setJSON($data); }else{ return $this->response->setJSON(['result'=>0,'message'=>'Failed to load data']); } }else{ // echo 'hello';die(); return $this->response->setJSON(['result'=>0,'message'=>'please login']); } } public function asset_delete() { $id=$this->request->getVar('id'); // echo $id;die(); $db=\Config\Database::connect(); $builder=$db->table('asset'); $builder->where('id',$id); $delete=$builder->delete(); if($delete){ return $this->response->setJSON(['result'=>1]); }else{ return $this->response->setJSON(['result'=>0]); } } public function asset_edit() { $id=session()->get('id'); if($id){ $sid=$this->request->getVar('id'); // echo $sid;die(); $db=\Config\Database::connect(); $builder=$db->table('asset'); $builder->where('id',$sid); $data=$builder->get()->getRowArray(); // print_r($data);die(); // $data['value']=$data; return view('Asset/edit_asset',$data); }else{ return $this->response->setJSON(['result'=>0,'message'=>'please login']); } } } ?>