/ var / www / html / cai / application / models / [ HOME SHELL ]

Name	Size	Permission	Action
070623-Evnt_model.php	3.67 KB	-rwxr-x--x
15122022-Prod_model.php	4.71 KB	-rwxr-x--x
250123-Home_model.php	1.93 KB	-rwxr-x--x
Blog_model.php	2.88 KB	-rwxr-x--x
Content_model.php	21.72 KB	-rwxr-x--x
Crose_model.php	10.52 KB	-rwxr-x--x
Crosej_model.php	10.52 KB	-rwxr-x--x
Evnt_model.php	3.67 KB	-rwxrwxrwx
Fun_model.php	11.14 KB	-rwxr-x--x
Gblsetup_model.php	61.64 KB	-rwxr-x--x
Home_model.php	5.04 KB	-rwxr-x--x
Itmsetup_model.php	6.27 KB	-rwxr-x--x
Jobc_model.php	10.52 KB	-rwxr-x--x
Login_model.php	4.03 KB	-rwxr-x--x
Mdc_model.php	10.21 KB	-rwxr-x--x
Mems_model.php	3.09 KB	-rwxr-x--x
Pages_model.php	6.04 KB	-rwxr-x--x
Prod_model.php	4.99 KB	-rwxr-x--x
Proj_model.php	10.59 KB	-rwxr-x--x
Publ_model.php	6.72 KB	-rwxr-x--x
Stat_model.php	7.25 KB	-rwxr-x--x
User_model.php	11.63 KB	-rwxr-x--x
Wrks_model.php	10.52 KB	-rwxr-x--x
index.html	131 B	-rwxr-x--x

Code Editor : User_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class User_model extends CI_Model {

public function __construct()
	{
		parent::__construct();
		//$this->load->database();
	}
	
	// modulelist
	public function mdlList($Cond=null,$Id=null)
	{
		$this->db->select('i.*');
		$this->db->from(''.$this->data['TBL']['MDL'].' AS i');
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('i.SRTDR','ASC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id']     = $row->MDLID;
				$data[$i]['pId']   =  $row->PID;
				$data[$i]['NAME'] = dbOut($row->NAME);
				$data[$i]['AcsChk'] = $this->DtlsUsrAcs("UID='".$Id."' AND MDLID='".$row->MDLID."'");
				$data[$i]['chldList'] = $this->mdlList("i.PID='".$row->MDLID."' AND i.STATUS='".STATUS_A."'",$Id);
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function DtlsUsrAcs($Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['ACS']);
		if($Cond!='')$this->db->where($Cond);
		$query = $this->db->get();
		//echo $this->db->last_query();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id'] = $query->row()->ID;
			$data['UID'] = $query->row()->UID;
			$data['PMLID'] = $query->row()->PMLID;
			$data['MDLID'] = $query->row()->MDLID;
			$data['AD'] = $query->row()->AD;
			$data['ED'] = $query->row()->ED;
			$data['VW'] = $query->row()->VW;
			$data['DL'] = $query->row()->DL;
			return $data;
		}
		return $data;
	}
	/*public function aDtls($Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['PBA']);
		if($Cond!='')$this->db->where($Cond);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id']        = $query->row()->ID;
			$data['NAME']      = dbOut($query->row()->NAME);
			$data['STATUS']    = dbOut($query->row()->STATUS);
			return $data;
		}
		return $data;
	}*/
	/*public function aList($params = array(),$Cond=null,$ShrtName=null,$ShrtBy=null)
	{
		$this->db->select('i.ID AS ID,i.NAME AS NAME,i.STATUS AS STATUS');
		$this->db->from(''.$this->data['TBL']['PBA'].' AS i');
		if($Cond!='')$this->db->where($Cond);
		if($ShrtName!='' && $ShrtBy!='')
		{
		$this->db->order_by($ShrtName,$ShrtBy);
		}else{
		$this->db->order_by('ID','DESC');
		}
		$Sr = 1;
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit'],$params['start']);
		  $Sr = $params['start']+1;
		  if($params['start']<=0)$Sr = 1;
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		//echo $this->db->last_query();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr']     = $Sr;
				$data[$i]['Id']     = $row->ID;
				$data[$i]['NAME']   = dbOut($row->NAME);
				$data[$i]['STATUS'] = dbOut($row->STATUS);
				$data[$i]['InUsed'] = $this->fm->cntCon($this->data['TBL']['PBL'],"PBAID='".$row->ID."'");
				$i++;$Sr++;
			}
		return $data;
		}
		return $data;
	}
	public function vDtls($Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['PBV']);
		if($Cond!='')$this->db->where($Cond);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id']        = $query->row()->ID;
			$data['NAME']      = dbOut($query->row()->NAME);
			$data['STATUS']    = dbOut($query->row()->STATUS);
			return $data;
		}
		return $data;
	}
	public function vList($params = array(),$Cond=null,$ShrtName=null,$ShrtBy=null)
	{
		$this->db->select('i.ID AS ID,i.NAME AS NAME,i.STATUS AS STATUS');
		$this->db->from(''.$this->data['TBL']['PBV'].' AS i');
		if($Cond!='')$this->db->where($Cond);
		if($ShrtName!='' && $ShrtBy!='')
		{
		$this->db->order_by($ShrtName,$ShrtBy);
		}else{
		$this->db->order_by('ID','DESC');
		}
		$Sr = 1;
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit'],$params['start']);
		  $Sr = $params['start']+1;
		  if($params['start']<=0)$Sr = 1;
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		//echo $this->db->last_query();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr']     = $Sr;
				$data[$i]['Id']     = $row->ID;
				$data[$i]['NAME']   = dbOut($row->NAME);
				$data[$i]['STATUS'] = dbOut($row->STATUS);
				$data[$i]['InUsed'] = $this->fm->cntCon($this->data['TBL']['PBL'],"PBVID='".$row->ID."'");
				$i++;$Sr++;
			}
		return $data;
		}
		return $data;
	}*/
	public function tDtls($Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['UDG']);
		if($Cond!='')$this->db->where($Cond);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id']        = $query->row()->ID;
			$data['NAME']      = dbOut($query->row()->NAME);
			$data['STATUS']    = dbOut($query->row()->STATUS);
			return $data;
		}
		return $data;
	}
	public function tList($params = array(),$Cond=null,$ShrtName=null,$ShrtBy=null)
	{
		$this->db->select('i.ID AS ID,i.NAME AS NAME,i.STATUS AS STATUS');
		$this->db->from('user_designation AS i');
		if($Cond!='')$this->db->where($Cond);
		if($ShrtName!='' && $ShrtBy!='')
		{
		$this->db->order_by($ShrtName,$ShrtBy);
		}else{
		$this->db->order_by('ID','DESC');
		}
		$Sr = 1;
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit'],$params['start']);
		  $Sr = $params['start']+1;
		  if($params['start']<=0)$Sr = 1;
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		//echo $this->db->last_query();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr']     = $Sr;
				$data[$i]['Id']     = $row->ID;
				$data[$i]['NAME']   = dbOut($row->NAME);
				$data[$i]['STATUS'] = dbOut($row->STATUS);
				$data[$i]['InUsed'] = $this->fm->cntCon($this->data['TBL']['USR'],"DIGID='".$row->ID."'");
				$i++;$Sr++;
			}
		return $data;
		}
		return $data;
	}
	// item section
	public function rDtls($Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['USR']);
		if($Cond!='')$this->db->where($Cond);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id']           = $query->row()->UID;
			$data['TYPID']        = $query->row()->TYPID;
			$data['DIGID']        = $query->row()->DIGID;
			$data['FNAME']        = dbOut($query->row()->FNAME);
			$data['LNAME']        = dbOut($query->row()->LNAME);
			$data['EMAIL']        = dbOut($query->row()->EMAIL);
			$data['MOBILE']       = dbOut($query->row()->MOBILE);
			$data['WRKAR']        = dbOut($query->row()->WRKAR);
			$data['USERNAME']     = dbOut($query->row()->USERNAME);
			$data['USERPASS']     = dbOut($query->row()->USERPASS);
			$data['PRPIC']        = dbOut($query->row()->PRPIC);
			$data['SURL']         = dbOut($query->row()->SURL);
			$data['SBIO']         = dbOut($query->row()->SBIO);
			$data['STATUS']       = dbOut($query->row()->STATUS);
			$data['ADATE']        = showDate($query->row()->ADATE);
			if($query->row()->JOIND!=DB_D_FRMT)$data['JOIND']  = showDate($query->row()->JOIND);
			if($query->row()->JOIND==DB_D_FRMT)$data['JOIND']  ='';
			return $data;
		}
		return $data;
	}
	public function rList($params = array(),$Cond=null,$ShrtName=null,$ShrtBy=null)
	{
		$this->db->select('i.UID AS ID,i.TYPID,i.FNAME AS FNAME,i.LNAME AS LNAME,i.EMAIL AS EMAIL,i.MOBILE AS MOBILE,i.STATUS AS STATUS,c.NAME AS GNAME');
		$this->db->from(''.$this->data['TBL']['USR'].' AS i');
		$this->db->join('user_designation AS c','i.DIGID=c.ID','INNER');
		if($Cond!='')$this->db->where($Cond);
		if($ShrtName!='' && $ShrtBy!='')
		{
		$this->db->order_by($ShrtName,$ShrtBy);
		}else{
		$this->db->order_by('ID','DESC');
		}
		$Sr = 1;
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit'],$params['start']);
		  $Sr = $params['start']+1;
		  if($params['start']<=0)$Sr = 1;
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		//echo $this->db->last_query();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr']     = $Sr;
				$data[$i]['Id']     = $row->ID;
				$data[$i]['TYPID']   = dbOut($row->TYPID);
				$data[$i]['FNAME']   = dbOut($row->FNAME);
				$data[$i]['LNAME']  = dbOut($row->LNAME);
				$data[$i]['EMAIL'] = dbOut($row->EMAIL);
				$data[$i]['MOBILE'] = dbOut($row->MOBILE);
				$data[$i]['STATUS'] = dbOut($row->STATUS);
				$data[$i]['GNAME'] = dbOut($row->GNAME);
				$i++;$Sr++;
			}
		return $data;
		}
		return $data;
	}
	public function CatList($Cond=null)
	{
		$this->db->select('ID,NAME');
		$this->db->from($this->data['TBL']['TYP']);
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('ID','DESC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id']     = $row->ID;
				$data[$i]['NAME']   = dbOut($row->NAME);
				$i++;
			}
		return $data;
		}
		return $data;
	}
	//FRONT SECTION
	public function fList($Cond=null)
	{
		$this->db->select('i.FNAME,i.LNAME,i.WRKAR,i.PRPIC,i.SURL,i.SBIO,c.NAME AS TYPE');
		$this->db->from(''.$this->data['TBL']['USR'].' AS i');
		$this->db->join('user_designation AS c','i.DIGID=c.ID','INNER');
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('i.FNAME','ASC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['NAME']   = dbOut($row->FNAME).'  '.dbOut($row->LNAME);
				$data[$i]['WRKAR']   = dbOut($row->WRKAR);
				$data[$i]['PRPIC']  = dbOut($row->PRPIC);
				$data[$i]['SURL']  = dbOut($row->SURL);
				$data[$i]['SBIO']  = dbOut($row->SBIO);
				$data[$i]['TYPE']  = dbOut($row->TYPE);
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function ffList($params = array(),$Cond=null)
	{
		$this->db->select('i.ID AS ID,i.NAME AS NAME,i.ALIAS,i.SDESC AS SDESC,i.PRPIC AS PRPIC,c.NAME AS TYPE');
		$this->db->from(''.$this->data['TBL']['PRJ'].' AS i');
		$this->db->join(''.$this->data['TBL']['TYP'].' AS c','i.TYPID=c.ID','INNER');
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('PDATE','DESC');
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit'],$params['start']);
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id']     = $row->ID.rand(111,999);
				$data[$i]['NAME']   = dbOut($row->NAME);
				$data[$i]['TYPE']   = dbOut($row->TYPE);
				$data[$i]['SDESC']  = dbOut($row->SDESC);
				$data[$i]['ALIAS']  = dbOut($row->ALIAS);
				$data[$i]['PRPIC']  = dbOut($row->PRPIC);
				$i++;
			}
		return $data;
		}
		return $data;
	}
}
?>

Urban Research Lab

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.