コード例 #1
0
/**
 * 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;
    }
}
コード例 #2
0
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;
    }
}
コード例 #3
0
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;
    }
}
コード例 #4
0
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;
    }
}
コード例 #5
0
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');
}
コード例 #6
0
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;
    }
}
コード例 #7
0
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;
    }
}
コード例 #8
0
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;
    }
}
コード例 #9
0
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;
    }
}
コード例 #10
0
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']);
}
コード例 #11
0
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;
    }
}
コード例 #12
0
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;
    }
}