/** * User Delete Form Builder. */ function user_delete_form($user_id) { $user = new User(); $user->byID($user_id); if ($user->affected > 0) { $frm = new DbForm(); $user->first_last_name = $user->first_name . ' ' . $user->last_name; $frm->build('user_delete_form', $user, $_SESSION['log_access_level']); } else { natural_set_message('Problems loading user ' . $user_id, 'error'); return FALSE; } }
function menu_delete_form($data) { $menu = new Menu(); $menu->byID($data['id']); if ($menu->affected > 0) { $frm = new DbForm(); $frm->build('menu_delete_form', $menu, $_SESSION['log_access_level']); } else { natural_set_message('Problems loading menu ' . $data['id'], 'error'); return FALSE; } }
function categories_delete_form($data) { $categories = new Categories(); $categories->byID($data['id']); //$categories->loadSingle('id='.$data['categories_id']); if ($categories->affected > 0) { $frm = new DbForm(); $frm->build('categories_delete_form', $categories, $_SESSION['log_access_level']); } else { return FALSE; } }
function subscribers_delete_form($data) { $subscribers = new Subscribers(); $subscribers->byID($data['id']); //$subscribers->loadSingle('id='.$data['subscribers_id']); if ($subscribers->affected > 0) { $frm = new DbForm(); $frm->build('subscribers_delete_form', $subscribers, $_SESSION['log_access_level']); } else { return FALSE; } }
function create_form($table_name) { //$ft = new DataManager; //$ff = new DataManager; $db = DataConnection::readOnly(); $dbform = new DbForm(); $dbfield = new DbField(); $param = ""; $fnm = ""; $param['form_method'] = "POST"; $form_add = $table_name . '_create_form'; $form_edit = $table_name . '_edit_form'; $form_delete = $table_name . '_delete_form'; //Saving form parameters for the create form $param['form_id'] = $form_add; $param['form_name'] = $form_add; $param['form_title'] = 'Add New ' . ucwords(str_replace("_", " ", strtolower($table_name))); $param['form_action'] = "javascript:process_information('" . $table_name . "_create_form', '" . $table_name . "_create_form_submit', '" . $table_name . "', null, null, null, null, 'create_row');"; //$ft->dmInsert("" . FORM_TABLE, $param); $create = $dbform->create($param); $form_add_id = $create['id']; //Saving form parameters for edit form $param['form_id'] = $form_edit; $param['form_name'] = $form_edit; $param['form_title'] = 'Edit ' . ucwords(str_replace("_", " ", strtolower($table_name))); $param['form_action'] = "javascript:process_information('" . $table_name . "_edit_form', '" . $table_name . "_edit_form_submit', '" . $table_name . "', null, null, null, null, 'edit_row');"; //$ft->dmInsert("" . FORM_TABLE, $param); $edit = $dbform->create($param); $form_edit_id = $edit['id']; //Saving form parameters for delete form $param['form_id'] = $form_delete; $param['form_name'] = $form_delete; $param['form_title'] = 'Delete ' . ucwords(str_replace("_", " ", strtolower($table_name))); $param['form_action'] = "javascript:process_information('" . $table_name . "_delete_form', '" . $table_name . "_delete_form_submit', '" . $table_name . "', null, null, null, null, 'delete_row');"; //$ft->dmInsert("" . FORM_TABLE, $param); $delete = $dbform->create($param); $form_delete_id = $delete['id']; //$dblink = mysql_connect(NATURAL_DBHOST, NATURAL_DBUSER, NATURAL_DBPASS); /*if (!$dblink) { //die('Could not connect: ' . mysql_error()); natural_set_message('Failed to connect with the database '.NATURAL_DBNAME.'!', 'error'); }*/ $today = date("m-d-Y H:i:s"); $now = date("M-D-Y"); $query = 'SHOW COLUMNS FROM ' . NATURAL_DBNAME . '.' . $table_name; $query_result = mysql_query($query, $dblink); $pdo = new PDO(NATURAL_PDO_DSN_READ, NATURAL_PDO_USER_READ, NATURAL_PDO_PASS_READ); $q = $pdo->prepare('SHOW COLUMNS FROM ' . NATURAL_DBNAME . '.' . $table_name); $q->execute(); $columns = $q->fetchAll(PDO::FETCH_COLUMN); $i = 0; if (count($columns) > 0) { foreach ($columns as $key => $val) { $label = ""; $nam_ar = explode("_", $val); if (is_array($nam_ar)) { for ($x = 0; $x < count($nam_ar); $x++) { if ($nam_ar[$x] != "id") { $label .= ucfirst($nam_ar[$x]) . " "; } } $label = substr($label, 0, -1); } else { $label = ucfirst($val); } $field['form_reference'] = $form_add; $field['form_template_id'] = $form_add_id; $field['field_id'] = $val; $field['field_name'] = $val; $field['form_field_order'] = $i; if ($val == "id") { $field['html_type'] = "hidden"; } else { $field['html_type'] = "text"; } $field['def_val'] = ""; $field['def_label'] = $label; //Insert template new //$ff->dmInsert("" . FIELD_TABLE, $field); $dbfield->create($field); //$form_add_id = $create['id']; //Insert template edit $field['form_reference'] = $form_edit; $field['form_template_id'] = $form_edit_id; $field['def_val'] = "{$val}"; $dbfield->create($field); if ($val == 'id') { //Insert delete id $field['form_reference'] = $form_delete; $field['form_template_id'] = $form_delete_id; $field['def_val'] = "{$val}"; $field['html_type'] = "hidden"; $field['def_label'] = 'ID'; $dbfield->create($field); } if ($i == 1) { //Insert delete message $field['form_reference'] = $form_delete; $field['form_template_id'] = $form_delete_id; $field['field_id'] = 'message'; $field['field_name'] = 'message'; $field['form_field_order'] = $i; $field['def_label'] = ''; $field['def_val'] = 'Are you sure you want to delete this ' . $table_name . '?'; $field['html_type'] = 'message'; $dbfield->create($field); //Insert delete object $field['form_reference'] = $form_delete; $field['form_template_id'] = $form_delete_id; $field['field_id'] = "{$val}"; $field['field_name'] = "{$val}"; $field['form_field_order'] = $i + 1; $field['def_label'] = ''; $field['def_val'] = "{$val}"; $field['html_type'] = 'message'; $dbfield->create($field); } $i++; } $field['form_reference'] = $form_add; $field['form_template_id'] = $form_add_id; $field['field_id'] = "sub"; $field['field_name'] = "sub"; $field['form_field_order'] = $i; $field['def_label'] = ''; $field['def_val'] = ''; $field['html_type'] = 'submit'; $dbfield->create($field); $field['form_reference'] = $form_edit; $field['form_template_id'] = $form_edit_id; $dbfield->create($field); $field['form_reference'] = $form_delete; $field['form_template_id'] = $form_delete_id; $dbfield->create($field); } natural_set_message('Done creating the form for the table ' . $table_name . '!', 'success'); }
function deposit_delete_form($data) { $deposit = new Deposit(); $deposit->byID($data['id']); //$deposit->loadSingle('id='.$data['deposit_id']); if ($deposit->affected > 0) { $frm = new DbForm(); $frm->build('deposit_delete_form', $deposit, $_SESSION['log_access_level']); } else { return FALSE; } }
function mvno_delete_form($data) { $mvno = new Mvno(); $mvno->byID($data['id']); //$mvno->loadSingle('id='.$data['mvno_id']); if ($mvno->affected > 0) { $frm = new DbForm(); $frm->build('mvno_delete_form', $mvno, $_SESSION['log_access_level']); } else { return FALSE; } }
function bank_delete_form($data) { $bank = new Bank(); $bank->byID($data['id']); //$bank->loadSingle('id='.$data['bank_id']); if ($bank->affected > 0) { $frm = new DbForm(); $frm->build('bank_delete_form', $bank, $_SESSION['log_access_level']); } else { return FALSE; } }
function report_delete_form($data) { $report = new Report(); $report->byID($data['id']); //$report->loadSingle('id='.$data['report_id']); if ($report->affected > 0) { $frm = new DbForm(); $frm->build('report_delete_form', $report, $_SESSION['log_access_level']); } else { return FALSE; } }
function dashboard_widgets_delete_form($data) { $dashboard_widgets = new DashboardWidgets(); $dashboard_widgets->byID($data['id']); $frm = new DbForm(); return $frm->build('dashboard_widgets_delete_form', $dashboard_widgets, $_SESSION['log_access_level']); }
function impression_delete_form($data) { $impression = new Impression(); $impression->byID($data['id']); //$impression->loadSingle('id='.$data['impression_id']); if ($impression->affected > 0) { $frm = new DbForm(); $frm->build('impression_delete_form', $impression, $_SESSION['log_access_level']); } else { return FALSE; } }
function church_delete_form($data) { $church = new Church(); $church->byID($data['id']); //$church->loadSingle('id='.$data['church_id']); if ($church->affected > 0) { $frm = new DbForm(); $frm->build('church_delete_form', $church, $_SESSION['log_access_level']); } else { return FALSE; } }