Exemple #1
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->person_id = new TableColumn('int', '11', true, '', '');
     $this->guardian_id = new TableColumn('int', '11', true, '', '');
     $this->class_id = new TableColumn('int', '11', true, '', '');
     $this->section = new TableColumn('int', '11', false, '', '');
     $this->roll_num = new TableColumn('int', '11', true, '', '');
     $this->subj_combination = new TableColumn('int', '11', true, '', '');
     $this->status = new TableColumn('enum', '0', true, '', '', array('enrolled', 'expelled', 'left'));
     $this->annual_dues = new TableColumn('int', '11', true, '', '');
     $this->last_class_arrears = new TableColumn('int', '11', false, '0', '');
     $this->start_date = new TableColumn('date', '0', true, '', '');
     $this->end_date = new TableColumn('date', '0', true, '', '');
     $this->admission_date = new TableColumn('date', '0', true, '', '');
     $this->last_date_for_fee_submission = new TableColumn('int', '2', true, '', '');
     $this->comments = new TableColumn('text', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'students';
         }
     }
     parent::__construct($id);
 }
Exemple #2
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->first_name = new TableColumn('varchar', '30', true, '', 'MUL');
     $this->last_name = new TableColumn('varchar', '30', true, '', '');
     $this->dob = new TableColumn('date', '0', false, '', '');
     $this->gender = new TableColumn('enum', '0', false, '', '', array('Male', 'Female'));
     $this->religion = new TableColumn('varchar', '30', false, '', '');
     $this->phone = new TableColumn('varchar', '11', true, '', '');
     $this->cnic = new TableColumn('varchar', '13', false, '', '');
     $this->city = new TableColumn('varchar', '25', false, '', '');
     $this->tehsil = new TableColumn('varchar', '25', false, '', '');
     $this->district = new TableColumn('varchar', '25', false, '', '');
     $this->address = new TableColumn('text', '0', false, '', '');
     $this->father_id = new TableColumn('int', '11', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'persons';
         }
     }
     parent::__construct($id);
 }
Exemple #3
0
 function __construct($id = null)
 {
     $this->user_roles_id = new TableColumn('int', '11', true, '', '');
     $this->pages_id = new TableColumn('int', '11', true, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'user_roles__pages';
         }
     }
     parent::__construct($id);
 }
Exemple #4
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->title = new TableColumn('varchar', '30', true, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'exams';
         }
     }
     parent::__construct($id);
 }
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->config_classes_id = new TableColumn('int', '11', true, '', '');
     $this->subject_combinations_id = new TableColumn('int', '11', true, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'config_classes__subject_combinations';
         }
     }
     parent::__construct($id);
 }
Exemple #6
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->action = new TableColumn('text', '0', true, '', '');
     $this->user_id = new TableColumn('int', '11', true, '', '');
     $this->time = new TableColumn('timestamp', '0', false, 'CURRENT_TIMESTAMP', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'log_messages';
         }
     }
     parent::__construct($id);
 }
Exemple #7
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->key_name = new TableColumn('varchar', '100', true, '', '');
     $this->value = new TableColumn('text', '0', true, '', '');
     $this->comments = new TableColumn('text', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'default_values';
         }
     }
     parent::__construct($id);
 }
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->advance_record_id = new TableColumn('int', '11', true, '', '');
     $this->date = new TableColumn('date', '0', true, '', '');
     $this->amount = new TableColumn('int', '11', true, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'advance_return_records';
         }
     }
     parent::__construct($id);
 }
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->category = new TableColumn('varchar', '40', true, '', '');
     $this->depreciation = new TableColumn('int', '11', true, '', '');
     $this->depreciation_schedule = new TableColumn('int', '11', true, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'config_asset_categories';
         }
     }
     parent::__construct($id);
 }
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->class_attendance_record_id = new TableColumn('int', '11', true, '', '');
     $this->student_id = new TableColumn('int', '11', true, '', '');
     $this->lectures_attended = new TableColumn('int', '1', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'student_attendance_records';
         }
     }
     parent::__construct($id);
 }
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->employee_id = new TableColumn('int', '11', true, '', '');
     $this->date = new TableColumn('date', '0', true, '', '');
     $this->status = new TableColumn('enum', '0', true, '', '', array('Present', 'Absent', 'Leave'));
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'emplyee_attendance_records';
         }
     }
     parent::__construct($id);
 }
Exemple #12
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->test_id = new TableColumn('int', '11', true, '', '');
     $this->student_id = new TableColumn('int', '11', true, '', '');
     $this->obtained_marks = new TableColumn('varchar', '3', false, '0', '');
     $this->comments = new TableColumn('text', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'test_records';
         }
     }
     parent::__construct($id);
 }
Exemple #13
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->loan_id = new TableColumn('int', '11', true, '', '');
     $this->interest_rate = new TableColumn('int', '11', true, '', '');
     $this->repayment_schedule = new TableColumn('int', '11', true, '', '');
     $this->comments = new TableColumn('text', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'loan_interest_rates';
         }
     }
     parent::__construct($id);
 }
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->config_class_id = new TableColumn('int', '11', true, '', '');
     $this->month = new TableColumn('int', '2', true, '', '');
     $this->fee_category_id = new TableColumn('int', '11', true, '', '');
     $this->amount = new TableColumn('int', '6', true, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'default_installments';
         }
     }
     parent::__construct($id);
 }
Exemple #15
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->fee_voucher_id = new TableColumn('int', '11', true, '', '');
     $this->fee_category_id = new TableColumn('int', '11', true, '', '');
     $this->amount = new TableColumn('int', '11', true, '', '');
     $this->comments = new TableColumn('text', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'fee_voucher_datails';
         }
     }
     parent::__construct($id);
 }
Exemple #16
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->text = new TableColumn('text', '0', true, '', '');
     $this->date = new TableColumn('date', '0', true, '', '');
     $this->user_id = new TableColumn('int', '11', true, '', '');
     $this->status = new TableColumn('enum', '0', true, '', '', array('read', 'unread'));
     $this->user_id_for = new TableColumn('int', '11', true, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'reminders';
         }
     }
     parent::__construct($id);
 }
Exemple #17
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->person_id = new TableColumn('int', '11', true, '', '');
     $this->amount = new TableColumn('int', '11', true, '', '');
     $this->expected_return_date = new TableColumn('date', '0', true, '', '');
     $this->to_from = new TableColumn('enum', '0', true, '', '', array('to', 'from'));
     $this->comments = new TableColumn('text', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'loan_records';
         }
     }
     parent::__construct($id);
 }
Exemple #18
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->title = new TableColumn('varchar', '60', true, '', '');
     $this->url = new TableColumn('text', '0', true, '', '');
     $this->parent_id = new TableColumn('int', '11', false, '', '');
     $this->position = new TableColumn('int', '11', false, '', '');
     $this->show_in_nav = new TableColumn('enum', '0', true, '', '', array('Yes', 'No'));
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'pages';
         }
     }
     parent::__construct($id);
 }
Exemple #19
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->person_id = new TableColumn('int', '11', true, '', '');
     $this->profession = new TableColumn('varchar', '30', true, '', '');
     $this->monthly_income = new TableColumn('int', '11', true, '', '');
     $this->num_of_family_members = new TableColumn('int', '11', false, '', '');
     $this->num_of_children = new TableColumn('int', '11', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'guardians';
         }
     }
     parent::__construct($id);
 }
Exemple #20
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->person_id = new TableColumn('int', '11', true, '', '');
     $this->department_id = new TableColumn('int', '11', true, '', '');
     $this->designation_id = new TableColumn('int', '11', true, '', '');
     $this->pay = new TableColumn('int', '11', true, '', '');
     $this->joining_date = new TableColumn('date', '0', true, '', '');
     $this->leaving_date = new TableColumn('date', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'employees';
         }
     }
     parent::__construct($id);
 }
Exemple #21
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->class = new TableColumn('varchar', '30', true, '', '');
     $this->degree_id = new TableColumn('int', '11', true, '', '');
     $this->annual_dues = new TableColumn('int', '11', true, '', '');
     $this->total_lectures_per_day = new TableColumn('int', '11', true, '', '');
     $this->starting_month = new TableColumn('int', '2', true, '', '');
     $this->ending_month = new TableColumn('int', '2', true, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'config_classes';
         }
     }
     parent::__construct($id);
 }
Exemple #22
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->employee_id = new TableColumn('int', '11', true, '', '');
     $this->month = new TableColumn('int', '2', true, '', '');
     $this->year = new TableColumn('int', '4', true, '', '');
     $this->amount = new TableColumn('int', '11', true, '', '');
     $this->date = new TableColumn('date', '0', true, '', '');
     $this->comments = new TableColumn('text', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'pays_records';
         }
     }
     parent::__construct($id);
 }
Exemple #23
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->category_id = new TableColumn('int', '11', true, '', '');
     $this->description = new TableColumn('text', '0', true, '', '');
     $this->purchase_date = new TableColumn('date', '0', true, '', '');
     $this->amount = new TableColumn('int', '11', true, '', '');
     $this->bill_id = new TableColumn('int', '11', false, '', '');
     $this->comments = new TableColumn('text', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'assets';
         }
     }
     parent::__construct($id);
 }
Exemple #24
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->student_id = new TableColumn('int', '11', true, '', '');
     $this->month = new TableColumn('int', '2', true, '', '');
     $this->year = new TableColumn('year', '4', true, '', '');
     $this->received_amount = new TableColumn('int', '11', false, '', '');
     $this->issue_date = new TableColumn('date', '0', true, '', '');
     $this->last_date = new TableColumn('date', '0', true, '', '');
     $this->submission_date = new TableColumn('date', '0', false, '', '');
     $this->comments = new TableColumn('text', '0', false, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'fee_vouchers';
         }
     }
     parent::__construct($id);
 }
Exemple #25
0
 function __construct($id = null)
 {
     $this->id = new TableColumn('int', '11', true, '', 'PRI');
     $this->class_id = new TableColumn('int', '11', true, '', '');
     $this->section = new TableColumn('int', '11', false, '', '');
     $this->subject_id = new TableColumn('int', '11', true, '', '');
     $this->syllabus = new TableColumn('varchar', '50', true, '', '');
     $this->date = new TableColumn('date', '0', true, '', '');
     $this->max_marks = new TableColumn('int', '11', true, '', '');
     $this->min_marks = new TableColumn('int', '11', true, '', '');
     $this->exam_id = new TableColumn('int', '11', true, '', '');
     // get default value
     foreach ($this as $field => $info) {
         if ($info instanceof TableColumn) {
             if ($def = getDefVal($field)) {
                 $this->{$field}->defValue = $def;
             }
             $this->{$field}->name = $field;
             $this->{$field}->table = 'tests';
         }
     }
     parent::__construct($id);
 }