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); }
function __construct() { $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->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 ($def = getDefVal($field)) { $this->{$field}->defValue = $def; } $this->{$field}->name = $field; $this->{$field}->table = 'Student'; } }
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); }
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); }
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); }
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->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); }
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->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->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->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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
/** * @return bool */ function showMarkup() { global $app_info, $html, $vOptions; // records $voucher = $this; $std = new Student($this->student_id->val); $vdtls = $this->getChildRecs('Fee_voucher_datail'); // voucher copies $copies = explode("--", getDefVal("voucher_copies")); // comments $vchComments = !empty($voucher->comments->val) ? "Note: " : ""; $vchComments = $voucher->comments->getEditableValue(); // prev. arrears $preArrears = $vOptions->applyPrevArrears ? $voucher->prev_arrears() : 0; // fine //get fineRec $fineRec = Fine_record::findOneByCondition("fee_voucher_id=" . $voucher->id->val); // if there isn't any, make a new one: if (!$fineRec) { $fineRec = new Fine_record(); $fineRec->student_id->val = $std->id->val; $fineRec->fee_voucher_id->val = $voucher->id->val; $fineRec->amount->val = 0; } // calculate fine if (isset($_POST['updateOptions'])) { // calculate fine $absences = $std->getAbsencesForMonth($voucher->month->val, $voucher->year->val); $fineRec->amount->val = $absences * $vOptions->finePerAbsence; } // add fine record if (!$fineRec->dbSave()) { $html->echoError("Could not save fine record. Please try later."); } // previous class arrears if ($vOptions->applyLastClassArrears) { // 1. get amount // 2. save amount $preClassArrears = $std->last_class_arrears(); if (!($lca = Last_class_arrear::findOneByCondition("fee_voucher_id=" . $voucher->id->val))) { $lca = new Last_class_arrear(); $lca->student_id->val = $std->id->val; $lca->fee_voucher_id->val = $voucher->id->val; $lca->amount->val = $preClassArrears; if (!$lca->dbSave()) { $html->echoError("Could not save Last Class Arrear record. Please try later."); } } } // total $total = $voucher->current_amount() + $preArrears + $fineRec->amount->val; $total += isset($lca) ? $lca->amount->val : 0; // $voucher->pr(); // $std->pr(); if (!$copies || empty($copies) || is_array($copies) && empty($copies[0])) { global $html; $err = "The Configuration for voucher copies is invalid."; $href = "records.php?page_id=58"; // link to the default values page $err .= " Please go to the " . $html->link_blank("Default Values", $href) . " page"; $err .= " and make sure there is a default value for 'voucher_copies.'"; $err .= " There may be typos"; $html->echoError($err); return false; } foreach ($copies as $copyType) { // echo "<div class='voucherContainer'>"; require __DIR__ . "/../html_components/VoucherHorizontal.php"; // echo "</div>"; echo "<br>"; echo "<br>"; } return true; }
<td colspan=2 class=xl693737><?php echo getDefVal("bank_name"); ?> </td> <td class=xl673737></td> </tr> <tr height=20 style='mso-height-source:userset;height:15.0pt'> <td colspan=2 height=20 class=xl683737 style='height:15.0pt'><b>Last Date:</b></td> <td colspan=2 class=xl723737><b><?php echo $voucher->last_date->getEditableValue(); ?> </b></td> <td class=xl663737></td> <td class=xl663737>Account Title / No:</td> <td colspan=2 class=xl693737><?php echo getDefVal("bank_account"); ?> </td> <td class=xl673737></td> </tr> <tr height=19 style='height:14.25pt'> <td colspan=4 height=19 class=xl713737 style='height:14.25pt'>Fee Description</td> <td class=xl663737><?php echo $std->photoMarkup(); ?> </td> <td colspan=3 rowspan=2 height=38 class=xl663737 width=383 style='mso-ignore: colspan-rowspan;height:28.5pt;width:287pt'> <![if !vml]><span style='mso-ignore:vglayout'> <table cellpadding=0 cellspacing=0> <tr>
<?php require_once 'initialize.php'; // ************************************************************ //create connection $ses_db = new MySQLDatabase('ses'); // find data // find students $ses_students = $ses_db->findAll('tblstudents'); // close connection $ses_db->closeConnection(); // *********************************************************** $db = new MySQLDatabase(); // insert students //pr($ses_students[0],'total stds: ('.count($ses_students).')'); foreach ($ses_students as $ses_std) { // if($db->create($ses_std, 'pages') ){ // echo "<p>Created</p>"; // } } pr(getDefVal('city'));
?> </td> <td class=xl6513401>Class:</td> <td class=xl1513401><?php echo preg_replace("/ \\d{4}\$/", "", $std->class_id->displayVal()); ?> </td> </tr> <tr height=17 style='height:12.75pt'> <td colspan=4 height=17 class=xl8313401 style='height:12.75pt'><?php echo getDefVal("bank_name"); ?> </td> <td class=xl1513401></td> <td colspan=4 class=xl8313401><?php echo getDefVal("bank_name"); ?> </td> </tr> <tr height=17 style='height:12.75pt'> <td colspan=2 height=17 class=xl6913401 style='height:12.75pt'>Admission / Fee Challan </td> <td colspan=2 class=xl8313401>Student copy</td> <td class=xl1513401></td> <td colspan=2 class=xl7013401>Admission / Fee Challan</td> <td colspan=2 class=xl7113401>Bank copy</td> </tr> <tr height=17 style='height:12.75pt'> <td colspan=3 height=17 class=xl6413401 style='height:12.75pt'>Description</td> <td class=xl6413401 style='border-left:none'>Amount</td>