/** * Метод получает все содержимое таблицы $this->tableName по запросу SELECT и записывает в свойство $this->tableFormDB * вызывает метод draw() и возвращет готовую таблицу * @return string */ public function getTable(){ $query = new QueryOld(); $sql = "SELECT * FROM {$this->tableName}"; $this->tableFromDB = $query->runSql($sql); return $this->draw(); }
public function __construct($login, $id_client) { $this->login = $login; $this->id_client = $id_client; $this->permission_table = []; $this->permission_action = []; $query = new QueryOld(); $sql = sprintf( "SELECT pt.table_name, pt.permission FROM ref_users u JOIN ref_permissions_for_tables pt ON u.id = pt.id_ref_users WHERE u.id_ref_clients = %d AND u.login = '******'", $this->id_client, $this->login ); $result = $query->runSql($sql); foreach ($result as $row) { $this->permission_table[$row['table_name']] = $row['permission']; } $sql = sprintf("get_permissions('%s', %d)", $this->login, $this->id_client); $result = $query->callProcedure($sql); foreach ($result as $row) { $this->permission_action[] = $row['name']; } }
private function load_constraints() { $constraints = []; $sql = sprintf("SELECT c.name, rc.value, rc.relative_html_input_name FROM ui_input_fields_rules_constraints rc JOIN ui_input_fields_rules r ON r.id = rc.id_ui_input_fields_rules AND r.name = '%s' JOIN ui_input_fields_constraints c ON c.id = rc.id_ui_input_fields_constraints", $this->rule_name); $query = new QueryOld(); $result = $query->runSql($sql); foreach ($result as $row) { $constraints[$row['name']] = $row; } return $constraints; }
/** * ui_inputField constructor. * @param null $id_field */ public function __construct($id_field = NULL) { if (isset($id_field)) { $this->id_field = $id_field; # если передан $id_field, то ищем в базе и заполняем свойства $sql = sprintf("SELECT f.html_name, f.html_type, f.html_class, f.html_id, f.html_value, f.html_placeholder, f.label, f.db_table_name, f.db_field_name, f.npp, r.name as rule_name, r.id as rule_id FROM ui_input_fields f LEFT JOIN ui_input_fields_rules r ON r.id = f.id_ui_input_fields_rules WHERE f.id=%d ORDER BY f.npp", $this->id_field); $query = new QueryOld(); $result = $query->runSql($sql); if(empty($result)){ # исключение id не найден }else{ $this->html_name = $result[0]['html_name']; $this->html_type = $result[0]['html_type']; $this->html_class = $result[0]['html_class']; $this->html_id = $result[0]['html_id']; $this->html_value = $result[0]['html_value']; $this->label = $result[0]['label']; $this->db_table_name = $result[0]['db_table_name']; $this->db_field_name = $result[0]['db_field_name']; $this->npp = $result[0]['npp']; $this->html_placeholder = $result[0]['html_placeholder'] ?: 'Введите значение ' . $this->html_name; $this->rule = new ui_fieldRule($result[0]['rule_name']); $this->changed=false; } } }
$query = new QueryOld(); foreach($mas as $table => $fields) { $sql = "insert into $table ("; $comma = $values = ''; foreach($fields as $fieldName => $value) { $sql .= "$comma $fieldName"; $values .= "$comma '$value'"; $comma = ','; } echo '<br>' . ($sql .= " ) values ( $values )"). '<br>'; $result = $query->runSql($sql); var_dump($result); } echo '<pre>Преобразованный массив POST<br>'; var_dump($mas); echo '</pre>'; echo '<pre>Массив имен таблиц<br>'; var_dump($tableName); echo '</pre>'; echo 'Осуществляем сверку массивов mas[0], mas[1] ... mas[n] с таблицами<br>'; for($i = 0; $i<count($tableName); $i++)