/ 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 : Stat_model.php

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

public function __construct()
	{
		parent::__construct();
	}
	
	
	public function sumStat()
	{
		$data = array();
		$data['CmsTot'] = $this->fm->cntCon(''.$this->data['TBL']['CMS'].' AS s');
		$data['aCmsTot'] = $this->fm->cntCon(''.$this->data['TBL']['CMS'].' AS s'," STATUS='".STATUS_A."'");
		$data['iCmsTot'] = $this->fm->cntCon(''.$this->data['TBL']['CMS'].' AS s'," STATUS='".STATUS_I."'");
		$data['PrjtTot'] = $this->fm->cntCon(''.$this->data['TBL']['TYP'].' AS s');
		$data['aPrjtTot'] = $this->fm->cntCon(''.$this->data['TBL']['TYP'].' AS s'," STATUS='".STATUS_A."'");
		$data['iPrjtTot'] = $this->fm->cntCon(''.$this->data['TBL']['TYP'].' AS s'," STATUS='".STATUS_I."'");
		$data['PrjTot'] = $this->fm->cntCon(''.$this->data['TBL']['PRJ'].' AS s');
		$data['aPrjTot'] = $this->fm->cntCon(''.$this->data['TBL']['PRJ'].' AS s'," STATUS='".STATUS_A."'");
		$data['iPrjTot'] = $this->fm->cntCon(''.$this->data['TBL']['PRJ'].' AS s'," STATUS='".STATUS_I."'");
		$data['CrsTot'] = $this->fm->cntCon(''.$this->data['TBL']['CRS'].' AS s');
		$data['aCrsTot'] = $this->fm->cntCon(''.$this->data['TBL']['CRS'].' AS s'," STATUS='".STATUS_A."'");
		$data['iCrsTot'] = $this->fm->cntCon(''.$this->data['TBL']['CRS'].' AS s'," STATUS='".STATUS_I."'");
		$data['WrkTot'] = $this->fm->cntCon(''.$this->data['TBL']['WRK'].' AS s');
		$data['aWrkTot'] = $this->fm->cntCon(''.$this->data['TBL']['WRK'].' AS s'," STATUS='".STATUS_A."'");
		$data['iWrkTot'] = $this->fm->cntCon(''.$this->data['TBL']['WRK'].' AS s'," STATUS='".STATUS_I."'");
		$data['PbaTot'] = $this->fm->cntCon(''.$this->data['TBL']['PBA'].' AS s');
		$data['aPbaTot'] = $this->fm->cntCon(''.$this->data['TBL']['PBA'].' AS s'," STATUS='".STATUS_A."'");
		$data['iPbaTot'] = $this->fm->cntCon(''.$this->data['TBL']['PBA'].' AS s'," STATUS='".STATUS_I."'");
		$data['PbvTot'] = $this->fm->cntCon(''.$this->data['TBL']['PBV'].' AS s');
		$data['aPbvTot'] = $this->fm->cntCon(''.$this->data['TBL']['PBV'].' AS s'," STATUS='".STATUS_A."'");
		$data['iPbvTot'] = $this->fm->cntCon(''.$this->data['TBL']['PBV'].' AS s'," STATUS='".STATUS_I."'");
		$data['PblTot'] = $this->fm->cntCon(''.$this->data['TBL']['PBL'].' AS s');
		$data['aPblTot'] = $this->fm->cntCon(''.$this->data['TBL']['PBL'].' AS s'," STATUS='".STATUS_A."'");
		$data['iPblTot'] = $this->fm->cntCon(''.$this->data['TBL']['PBL'].' AS s'," STATUS='".STATUS_I."'");
		$data['DigTot'] = $this->fm->cntCon(''.$this->data['TBL']['UDG'].' AS s');
		$data['aDigTot'] = $this->fm->cntCon(''.$this->data['TBL']['UDG'].' AS s'," STATUS='".STATUS_A."'");
		$data['iDigTot'] = $this->fm->cntCon(''.$this->data['TBL']['UDG'].' AS s'," STATUS='".STATUS_I."'");
		$data['UsrTot'] = $this->fm->cntCon(''.$this->data['TBL']['USR'].' AS s');
		$data['aUsrTot'] = $this->fm->cntCon(''.$this->data['TBL']['USR'].' AS s'," STATUS='".STATUS_A."'");
		$data['iUsrTot'] = $this->fm->cntCon(''.$this->data['TBL']['USR'].' AS s'," STATUS='".STATUS_I."'");
		$data['EvtTot'] = $this->fm->cntCon(''.$this->data['TBL']['EVT'].' AS s');
		$data['aEvtTot'] = $this->fm->cntCon(''.$this->data['TBL']['EVT'].' AS s'," STATUS='".STATUS_A."'");
		$data['iEvtTot'] = $this->fm->cntCon(''.$this->data['TBL']['EVT'].' AS s'," STATUS='".STATUS_I."'");
		$data['JobTot'] = $this->fm->cntCon(''.$this->data['TBL']['JBC'].' AS s');
		$data['aJobTot'] = $this->fm->cntCon(''.$this->data['TBL']['JBC'].' AS s'," STATUS='".STATUS_A."'");
		$data['iJobTot'] = $this->fm->cntCon(''.$this->data['TBL']['JBC'].' AS s'," STATUS='".STATUS_I."'");
		$data['MdcTot'] = $this->fm->cntCon(''.$this->data['TBL']['MDC'].' AS s');
		$data['aMdcTot'] = $this->fm->cntCon(''.$this->data['TBL']['MDC'].' AS s'," STATUS='".STATUS_A."'");
		$data['iMdcTot'] = $this->fm->cntCon(''.$this->data['TBL']['MDC'].' AS s'," STATUS='".STATUS_I."'");
		$data['MemTot'] = $this->fm->cntCon(''.$this->data['TBL']['MEM'].' AS s');
		$data['aMemTot'] = $this->fm->cntCon(''.$this->data['TBL']['MEM'].' AS s'," STATUS='".STATUS_A."'");
		$data['iMemTot'] = $this->fm->cntCon(''.$this->data['TBL']['MEM'].' AS s'," STATUS='".STATUS_I."'");
		return $data;
	}
	public function uInfo($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['DGNME']        = dbOut($this->fm->fldVal($this->data['TBL']['UDG'],'NAME',"ID='".$query->row()->DIGID."'"));
			$data['UACES']        = $this->fm->cntCon($this->data['TBL']['ACS'],"UID='".$query->row()->UID."' AND MDLID=13 AND VW=1");
			$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 LoginLogList($Condition=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['LOG']['LGN']);
		if($Condition !='') $this->db->where($Condition);
		$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]['LOGIN'] = showDateTime($row->LOGIN);
				if($row->LOGOUT!=DB_DT_FRMT)$data[$i]['LOGOUT'] = showDateTime($row->LOGOUT);
				if($row->LOGOUT==DB_DT_FRMT)$data[$i]['LOGOUT'] = '';
				$data[$i]['OS'] = CaseU(dbOut($row->OS));
				$data[$i]['BROWSER'] = CaseU(dbOut($row->BROWSER));
				$data[$i]['SYSNAME'] = CaseU(dbOut($row->SYSNAME));
				$i++;
			}
			return $data;
		}
		return $data;
	}
	public function DtlsUser($Condition)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['USR']);
		if($Condition!='')$this->db->where($Condition);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id'] = $query->row()->UID;
			$data['FNAME'] = dbSameShow($query->row()->FNAME);
			$data['LNAME'] = dbSameShow($query->row()->LNAME);
			$data['EMAIL'] = CaseL(dbOut($query->row()->EMAIL));
			$data['MOB'] = dbSameShow($query->row()->MOBILE);
			$data['UNAME'] = dbSameShow($query->row()->USERNAME);
			$data['PASS'] = dbSameShow($query->row()->USERPASS);
			$data['PRPIC'] = dbOut($query->row()->PRPIC);
			$data['STATUS'] = dbSameShow($query->row()->STATUS);
			$data['UTYPE'] = dbSameShow($query->row()->UTYPE);
			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.