jro_apps/pbase Files · trunk/components/com_data/models/applicationTestModel.php

modificada la instancia de la clase SessionModel

arturo - - Load All Authors

File last commit:

r0:1


                r13:14

Download file

             applicationTestModel.php
        
                    62 lines
            
             | 2.0 KiB
            
                | text/x-php
            
             |
                PhpLexer
            
             / trunk / components / com_data / models / applicationTestModel.php
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        arturo
    
creando directorios base para el desarrollo

              r0
            
      <?php

      class applicationTestModel extends ModelBase{

          public $tableName = 'sis_appl_test';

          public $id = array('key'=>'idappl_test','value'=>'');

          public function addItem($datos){

              $this->setFieldArray($datos);

              list($resultado,$id,$mensaje) = $this->insert();

              return array ($resultado,$id,$mensaje);

          }

          public function DeleteItem(){

              list($resultado,$mensaje) = $this->delete();

              return array ($resultado,$mensaje);

          }

          public function UpdateItem($datos){

              $this->setFieldArray($datos);

              list($resultado,$mensaje) = $this->update();

              return array ($resultado,$mensaje);

          }

          public function getApplicationTest($number){

              $query = "SELECT spt.* FROM ".$this->tableName." AS spt"

                      ." INNER JOIN sis_tests AS st ON spt.idtest = st.idtest"

                      ." WHERE st.ordering = ".$number;

              $result = $this->db->prepare($query);

              $result->execute();

              return $result;

          }

          public function getApplicationTestbyID($id){

              $query = "SELECT * FROM ".$this->tableName

                      ." WHERE idappl_test = ".$id;

              $result = $this->db->prepare($query);

              $result->execute();

              return $result;

          }

          public function getApplicationTestChecked($id, $idapplication){

              $query = "SELECT * FROM ".$this->tableName

                      ." WHERE idtest = ".$id." AND idapplication = ".$idapplication;

              $result = $this->db->prepare($query);

              $result->execute();

              return $result;

          }

          public function info($id){

              $this->setQuery("Select *

                              From sis_appl_test

                              Where idappl_test =".$id);

              $consulta = $this->loadObjectList();

              return $consulta;

          }

          public function Getappl_test($id, $form){

              $this->setQuery("Select *

                              From sis_appl_test

                              Where idappl_test =".$id." and idtest=".$form);

              $consulta = $this->loadObjectList();

              return $consulta;

          }

      }

      ?>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

arturo creando directorios base para el desarrollo	r0	<?php
		class applicationTestModel extends ModelBase{
		public $tableName = 'sis_appl_test';
		public $id = array('key'=>'idappl_test','value'=>'');

		public function addItem($datos){
		$this->setFieldArray($datos);
		list($resultado,$id,$mensaje) = $this->insert();
		return array ($resultado,$id,$mensaje);
		}

		public function DeleteItem(){
		list($resultado,$mensaje) = $this->delete();
		return array ($resultado,$mensaje);
		}

		public function UpdateItem($datos){
		$this->setFieldArray($datos);
		list($resultado,$mensaje) = $this->update();
		return array ($resultado,$mensaje);
		}

		public function getApplicationTest($number){
		$query = "SELECT spt.* FROM ".$this->tableName." AS spt"
		." INNER JOIN sis_tests AS st ON spt.idtest = st.idtest"
		." WHERE st.ordering = ".$number;
		$result = $this->db->prepare($query);
		$result->execute();
		return $result;
		}

		public function getApplicationTestbyID($id){
		$query = "SELECT * FROM ".$this->tableName
		." WHERE idappl_test = ".$id;
		$result = $this->db->prepare($query);
		$result->execute();
		return $result;
		}

		public function getApplicationTestChecked($id, $idapplication){
		$query = "SELECT * FROM ".$this->tableName
		." WHERE idtest = ".$id." AND idapplication = ".$idapplication;
		$result = $this->db->prepare($query);
		$result->execute();
		return $result;
		}
		public function info($id){
		$this->setQuery("Select *
		From sis_appl_test
		Where idappl_test =".$id);
		$consulta = $this->loadObjectList();
		return $consulta;
		}
		public function Getappl_test($id, $form){
		$this->setQuery("Select *
		From sis_appl_test
		Where idappl_test =".$id." and idtest=".$form);
		$consulta = $this->loadObjectList();
		return $consulta;
		}
		}
		?>