Exemple #1
0
 public function index()
 {
     if (!G::isLoggedIn()) {
         return Login::controller(Login::DEF);
     }
     $crud = new CRUD('tblConfig', ['insDefaults' => ['fldUserID' => G::getUserID()], 'primaryKey' => 'fldKey']);
     $crud->setColDisplay('fldUserID', CRUD::HIDDEN);
     $crud->columnAttrib('fldValue', ['size' => 60]);
     return $crud->index();
 }
Exemple #2
0
 /**
  * @return string
  */
 public function index()
 {
     $dao = new CronDAO();
     $cols = array_flip($dao->objToRel(['command' => 0, 'priority' => 1, 'result' => 2, 'runTime' => 3]));
     $crud = new CRUD($dao->tableName);
     $crud->setColDisplay($cols[0], CRUD::DISPLAY);
     $crud->setColDisplay($cols[1], [CRUD::SELECT, [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]]);
     $crud->setColDisplay($cols[2], CRUD::DISPLAY);
     $crud->setColDisplay($cols[3], CRUD::TIMESTAMP);
     return $crud->index();
 }
Exemple #3
0
 public function index($tName = '')
 {
     if (($tableName = Request::get('tblName', $tName)) == '') {
         return '';
     }
     $crud = CRUD::factory($tableName, ['topPager' => false])->copyVarsFromRequest('tblName');
     if (preg_match('/^tblMod([A-Z]+[a-z]+)/', $tableName, $matches)) {
         foreach (Cfg::get('modules', []) as $moduleClass) {
             eval($moduleClass . '::' . Module::CRUD_MOD . '($crud);');
         }
     } else {
         switch ($tableName) {
             case 'tblNextNumber':
                 $crud->setColDisplay('fldTable', [CRUD::SELECT, DBMaintenance::getTableList(), true]);
                 break;
             case 'tblSecPrivUserMap':
                 $userSql = DB::driver() == DB::MYSQL ? Admin::USER_SQL_MYSQL : Admin::USER_SQL_MYSQL;
                 $crud->setColDisplay('fldUserID', [CRUD::SELECT, $userSql, true]);
                 $crud->setColDisplay('fldGroupID', [CRUD::SELECT, Admin::GROUP_SQL, true]);
                 $crud->setColDisplay('fldPrivilegeID', [CRUD::SELECT, Admin::PRIV_SQL, true]);
                 $crud->setColDisplay('fldLevelID', [CRUD::SELECT, Admin::LEVEL_SQL]);
                 break;
             case 'tblUserGroupMap':
                 $userSql = DB::driver() == DB::MYSQL ? Admin::USER_SQL_MYSQL : Admin::USER_SQL_SQLITE;
                 $crud->setColDisplay('fldUserID', [CRUD::SELECT, $userSql, true]);
                 $crud->setColDisplay('fldGroupID', [CRUD::SELECT, Admin::GROUP_SQL, true]);
                 break;
             case 'tblUser':
                 $crud->setColDisplay('fldLevel', [CRUD::SELECT, Admin::LEVEL_SQL]);
                 $crud->setColDisplay('fldTimeZone', [CRUD::SELECT, Admin::TZ_SQL]);
                 break;
         }
     }
     $resp = Response::factory()->set('tblName', $tableName);
     return Tag::hTag('b') . 'Editing Table: ' . $tableName . Tag::_hTag('b') . ' ' . Tag::hRef('ajax.php?' . $resp->action(__CLASS__ . '->csv()'), 'CSV') . ' ' . Tag::hRef('ajax.php?' . $resp->action(__CLASS__ . '->xls()'), 'XLS') . $crud->index();
 }
Exemple #4
0
 protected function getTableMetaData()
 {
     $parentMeta = parent::getTableMetaData();
     $tab = new DBTable($this->db, $this->gridQuery . ' LIMIT 1', null, DB::FETCH_ASSOC);
     if (!$tab->ok()) {
         return false;
     }
     foreach (array_keys($tab->getRow(0)) as $col) {
         if (!isset($this->columnTitles[$col])) {
             $this->columnTitles[$col] = $this->convertColumnToTitle($col);
             $this->cellAttributes[$col] = [];
         }
     }
     $displayColumns = array_keys($tab->getRow(0));
     $columnNames = array_keys($this->columnTitles);
     foreach ($columnNames as $columnName) {
         if (!in_array($columnName, $displayColumns)) {
             unset($this->columnTitles[$columnName]);
             unset($this->cellAttributes[$columnName]);
             unset($this->displayType[$columnName]);
         }
     }
     return true;
 }
Exemple #5
0
 public function manageUsersToGroups()
 {
     $key = Request::get('KEY');
     if ($key == '') {
         return 'KEY missing';
     }
     $userSql = DB::driver() == DB::MYSQL ? self::USER_SQL_MYSQL : self::USER_SQL_SQLITE;
     $row = DB::oneRow(DB::DEF, 'SELECT * FROM tblGroup WHERE fldGroupID=?', $key);
     return Tag::hTag('h4') . Tag::e('Editing Users in ' . $row['fldName'] . '(' . $row['fldLongName'] . ')') . Tag::_hTag('h4') . CRUD::factory('tblUserGroupMap', ['topPager' => false, 'where' => ['fldGroupID' => $key]])->setColDisplay('fldUserID', [CRUD::SELECT, $userSql, true])->setColDisplay('fldGroupID', CRUD::DISPLAY)->copyVarsFromRequest('KEY')->index();
 }