| Server IP : 199.250.214.225 / Your IP : 3.17.177.180 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\Support\Facades\Log;
use Illuminate\Http\Request;
use App\Http\Requests;
use DB;
use Session;
class functions23Controller extends Controller{
public function getList($table){
$list = DB::table($table)->get();
return $list;
}
public function getsubmodule($category)
{
$list = DB::table('submodule')
->where('moduleID', '=', $category)
->get();
return $list;
}
public function getTechStaff()
{
$list = DB::table('users')
->where('user_type', '=', 'TECHNICAL')
->get();
return $list;
}
public function getData($username, $category, $module)
{
if($category == "" && $module == ""){
$list = DB::Table('tbltechdocumentation')
->where('tbltechdocumentation.developedby', $username)
->leftjoin('module', 'tbltechdocumentation.categoryID', '=', 'module.moduleID')
->leftjoin('submodule', 'tbltechdocumentation.moduleID', '=', 'submodule.submoduleID')
->select('tbltechdocumentation.*', 'submodule.submodulename', 'module.modulename')
->get();
return $list;
} else {
$list = DB::Table('tbltechdocumentation')
->where('tbltechdocumentation.developedby', $username)
->where('tbltechdocumentation.categoryID', $category)
->where('tbltechdocumentation.moduleID', $module)
->leftjoin('module', 'tbltechdocumentation.categoryID', '=', 'module.moduleID')
->leftjoin('submodule', 'tbltechdocumentation.moduleID', '=', 'submodule.submoduleID')
->select('tbltechdocumentation.*', 'submodule.submodulename', 'module.modulename')
->get();
return $list;
}
}
public function getInfo($id)
{
$res = DB::table('tbltechdocumentation')
->where('id', $id)
->leftjoin('module', 'tbltechdocumentation.categoryID', '=', 'module.moduleID')
->leftjoin('submodule', 'tbltechdocumentation.moduleID', '=', 'submodule.submoduleID')
->select('tbltechdocumentation.*', 'module.modulename', 'submodule.submodulename')
->get();
return $res;
}
public function getDataModification($moduleID){
$res = DB::table('tbltechdocumentationmodification')
->where('moduleID', $moduleID)
->get();
return $res;
}
}