49 lines
1.3 KiB
PHP
49 lines
1.3 KiB
PHP
<?php
|
|
|
|
namespace App\Controllers;
|
|
|
|
class Insts extends BaseController {
|
|
|
|
public function index() {
|
|
$db = \Config\Database::connect();
|
|
$sql = "SELECT * FROM dict_insts";
|
|
$query = $db->query($sql);
|
|
$results = $query->getResultArray();
|
|
$data['insts'] = $results;
|
|
return view('insts_index.php', $data);
|
|
}
|
|
|
|
public function edit($instid) {
|
|
$data = array();
|
|
if ($instid != 0) {
|
|
$db = \Config\Database::connect();
|
|
$sql = "SELECT * FROM dict_insts where instid='$instid'";
|
|
$query = $db->query($sql);
|
|
$results = $query->getResultArray();
|
|
$data['insts'] = $results;
|
|
}
|
|
if ($this->request->getMethod() === 'post') {
|
|
$rules = [ 'instname' => 'required' ];
|
|
$instname = $this->request->getPost('instname');
|
|
if($this->validate($rules)){
|
|
if($instid == 0 ) {
|
|
$db = \Config\Database::connect();
|
|
$sql = "insert into dict_insts(instname, createdate) values ('$instname', NOW())";
|
|
$query = $db->query($sql);
|
|
return redirect()->to('/insts');
|
|
} else {
|
|
$db = \Config\Database::connect();
|
|
$sql = "update dict_insts set instname='$instname' where instid='$instid'";
|
|
$query = $db->query($sql);
|
|
return redirect()->to('/insts');
|
|
}
|
|
} else {
|
|
$data['validation'] = $this->validator;
|
|
return view('insts_editor',$data);
|
|
}
|
|
} else {
|
|
return view('insts_editor', $data);
|
|
}
|
|
}
|
|
}
|