Source for file model_students.php

 

class Model_Students extends ORM

 

 

    public $table_fields = array();

 

    function __construct()

    {

        $this->database = 'rigregversiontwo';

 

        /**

         * Tables name and table alias

         */

        $this->table['students'] = 'st';

        $this->table['retreatReg'] = 'reg';

        $this->table['retreat'] = 'rt';

        $this->table['stud_grp_join']= 'sgj';

        $this->table['sanghas']= 's';

        /**

         * Mapping of table "students"

         */

        $this->map['id']            = array('students', 'id');

        $this->map['local_key']     = array('students', 'local_key');

        $this->map['first_name']    = array('students', 'first');

        $this->map['last_name']     = array('students', 'last');

        $this->map['address_1']     = array('students', 'addr1');

        $this->map['address_2']     = array('students', 'addr2');

        $this->map['town']          = array('students', 'city');

        $this->map['postcode']      = array('students', 'zip');

        $this->map['state']         = array('students', 'province');

        $this->map['country']       = array('students', 'country');

        $this->map['phone']         = array('students', 'dayphone');

        $this->map['email_address'] = array('students', 'email');

        $this->map['gender']        = array('students', 'sex');

        $this->map['password']      = array('students', 'password');

        //$this->map['sangha']      = array('students', 'sangha');

        $this->map['sangha_name']     = array(

            'sanghas','name','',

            'LEFT JOIN sanghas AS s  ON st.sangha = s.ID'

        );

       /** 

        ID, retreatUID, studentID, regDate, regModifDate, headset, checkIn, checkOut,

 checkedInOut, chairInTemple, disability, translationTo, norota, rotaUID, firstChoice,

 secondChoice, thirdChoice, rotaText, statusQuo, statusQuoText, activity, retreatTotal,

 rigpaDonation, donationPurposeUID, retFundAmount, transactionTrace, paymentStatus,

 cancel, cancelDate, PaymentMode, LogIn, LogOut, amountStillDue, paymentComment,

 comment_payment, comment_accomodation, comment_overview, DayRateFee, IDinOTHER

        **/

        

       /** 

         ID, retName, retOptionName, retStart, retEnd, rankDisplay, headSetFee, retFee1, retFee1closeDate, retFee2, retFee2closeDate, retFee3, retFee3closeDate, status, special, family, child, useRotaFrom, fullPeriodDiscount, displayRetreatOnline, retreatPhoto, displayName, retreatWarning, chooseMeals, maxLunch, bookFullPeriod, minDays, bookPersonalTent, maxPersonalTents, sponsorsBookOnline, rotaChoices, childrenPossible, transportPossible

       **/

        

        $this->map['retId']            = array('retreat', 'ID');

        $this->map['retName']          = array('retreat', 'retName');

        $this->map['retOptionName']    = array('retreat', 'retOptionName');

        $this->map['rtStatus']         = array('retreat', 'status');

        

        

        

        $this->map['regId']            = array('retreatReg', 'ID');

        $this->map['retreatUID']     = array('retreatReg', 'retreatUID');

         $this->map['student_first']     = array(

            'students','first','',

            'LEFT JOIN students AS st  ON reg.studentID = st.local_key'

        );

        $this->map['student_last']     = array(

            'students','last','',

            'LEFT JOIN students AS st  ON reg.studentID = st.local_key'

        );

        

        

        $this->map['retreat_status']     = array(

            'retreat','status','',

            'LEFT JOIN retreat AS rt  ON reg.retreatUID = rt.ID'

        );

        

        $this->map['retreat_name']     = array(

            'retreat','retName','concat(retName," ", retOptionName)',

            'LEFT JOIN retreat AS rt  ON reg.retreatUID = rt.ID'

        );

       

        

        

       

        

        

 

    }

 

    function getActiveRetreats()

    {

    

    /*

    $this->select('regId', 'retreat_name', 'student_first', 'student_last', 'retreat_status');

          $this->order_by     ('retreat_status','DESC');

        $this->order_by     ('retreat_name');

        $this->order_by     ('student_last');

    

    return $this->rows_array();

    }

    

 

    function selectLogon($Email, $PassWord = '')

    {

        $this->select('local_key', 'first_name', 'last_name');

        $this->where('email_address', "=", $Email);

        if (!empty($PassWord))

        {

            $this->where('password', "=", md5($PassWord));

 

        }

 

        return $this->row_array();

 

    }

    

    function getRoles($id)

    {

        $this->query = "select sj.group_uid, u.cat_name

    }

    

    function getUIElements($controller)

    {

        $this->query = "select ui_element_id, parent, user_group, access_type

    }

 

 

    function getStudents()

    {

 

        $this->select(

                       'local_key', 

               'first_name', 

               'last_name', 

                'email_address', 

               'country'

                

               );

        $this->order_by('last_name');

        //$this->limit(200);

        return $this->rows_array();

        

    }

    

    function getUserRoles()

    {

    $this->query = ("select sj.ID, sj.student_uid, s.first, s.last, u.cat_name

   // $this->limit(1);

    return $this->rows_array();

    }

    

    function getCountries(){

        $this->query = ("select code, stdName, iso3 from country ");

        return $this->rows_array();

    }

    

    function resetLinkedTables()

    {

        $this->query('delete from students');

        $sql = 'ALTER TABLE students AUTO_INCREMENT = 0';

        $x = $this->query($sql);

        

        $this->query('delete from stud_grp_join');

        $sql = 'ALTER TABLE stud_grp_join AUTO_INCREMENT = 0';

        $x = $this->query($sql);

        

            $this->query('delete from user_group');

        $sql = 'ALTER TABLE user_group AUTO_INCREMENT = 0';

        $x = $this->query($sql);

          

        $this->query('delete from country');

        $sql = 'ALTER TABLE country AUTO_INCREMENT = 0';

        $x = $this->query($sql);

        

           $this->query('delete from sanghas');

        $sql = 'ALTER TABLE country AUTO_INCREMENT = 0';

        $x = $this->query($sql);

        

        return 'done';

    }