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

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

public function __construct()
	{
		parent::__construct();
	}
	public function statistics()
	{
		$data = array();
		$data['PRJ']=$this->fm->cntCon($this->data['TBL']['PRJ'],"STATUS='".STATUS_A."'");
		$data['PBL']=$this->fm->cntCon($this->data['TBL']['PBL'],"STATUS='".STATUS_A."'");
		$data['EVT']=$this->fm->cntCon($this->data['TBL']['EVT'],"STATUS='".STATUS_A."'");
		$data['WRK']=$this->fm->cntCon($this->data['TBL']['WRK'],"STATUS='".STATUS_A."'");
		$data['USR']=$this->fm->cntCon($this->data['TBL']['USR'],"TYPID=1 AND STATUS='".STATUS_A."'");
		return $data;
	}
	public function UPrList($Cond=null)
	{
		$this->db->select('i.ID AS ID,i.NAME AS NAME,i.PNAME AS PNAME,i.ALIAS AS ALIAS,i.SDATE AS SDATE,i.SDESC AS SDESC');
		$this->db->from(''.$this->data['TBL']['EVT'].' AS i');
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('i.SDATE','ASC');
		$this->db->limit(9);
		$query = $this->db->get();
		//echo $this->db->last_query();exit;
		$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]['PNAME']   = dbOut($row->PNAME);
				$data[$i]['ALIAS'] = dbOut($row->ALIAS);
				$data[$i]['SDESC'] = dbOut($row->SDESC);
				$data[$i]['SDAY'] = date('d', strtotime($row->SDATE));
				$data[$i]['SMNTH'] = date('F', strtotime($row->SDATE));
				$data[$i]['SYR'] = date('Y', strtotime($row->SDATE));
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function TnDrList($Cond=null)
	{
		$this->db->select('i.TID,i.TYPE');
		$this->db->from(''.$this->data['TBL']['TND'].' AS i');
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('RAND()');
		$this->db->limit(5);
		$query = $this->db->get();
		//echo $this->db->last_query();exit;
		$data = array(); $i=0; $Sr=1;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr']     = $Sr;
				$data[$i]['TID']     = $row->TID;
				$data[$i]['TYPE']     = $row->TYPE;
				$Id=$row->TID.rand(111,999);
				if($row->TYPE==STATUS_PR)
				{
				  $data[$i]['PDAY'] = date('d', strtotime($this->fm->fldVal($this->data['TBL']['PRJ'],'PDATE',"ID='".$row->TID."'")));
				  $data[$i]['PMNTH'] = date('M', strtotime($this->fm->fldVal($this->data['TBL']['PRJ'],'PDATE',"ID='".$row->TID."'")));
				  $data[$i]['PYR'] = date('Y', strtotime($this->fm->fldVal($this->data['TBL']['PRJ'],'PDATE',"ID='".$row->TID."'")));
				  $data[$i]['NAME']   = dbOut($this->fm->fldVal($this->data['TBL']['PRJ'],'NAME',"ID='".$row->TID."'"));
				  $data[$i]['URL']    = _PRJ_.'/'.$Id.'/'.dbOut($this->fm->fldVal($this->data['TBL']['PRJ'],'ALIAS',"ID='".$row->TID."'"));
				}elseif($row->TYPE==STATUS_PB)
				{
				  $data[$i]['PDAY'] = date('d', strtotime($this->fm->fldVal($this->data['TBL']['PBL'],'PDATE',"ID='".$row->TID."'")));
				  $data[$i]['PMNTH'] = date('M', strtotime($this->fm->fldVal($this->data['TBL']['PBL'],'PDATE',"ID='".$row->TID."'")));
				  $data[$i]['PYR'] = date('Y', strtotime($this->fm->fldVal($this->data['TBL']['PBL'],'PDATE',"ID='".$row->TID."'")));
				  $data[$i]['NAME']   = dbOut($this->fm->fldVal($this->data['TBL']['PBL'],'NAME',"ID='".$row->TID."'"));
				  $data[$i]['URL']    = _PUB_.'/'.$Id.'/'.dbOut($this->fm->fldVal($this->data['TBL']['PBL'],'ALIAS',"ID='".$row->TID."'"));
				}elseif($row->TYPE==STATUS_EV)
				{
				  $data[$i]['PDAY'] = date('d', strtotime($this->fm->fldVal($this->data['TBL']['EVT'],'SDATE',"ID='".$row->TID."'")));
				  $data[$i]['PMNTH'] = date('M', strtotime($this->fm->fldVal($this->data['TBL']['EVT'],'SDATE',"ID='".$row->TID."'")));
				  $data[$i]['PYR'] = date('Y', strtotime($this->fm->fldVal($this->data['TBL']['EVT'],'SDATE',"ID='".$row->TID."'")));
				  $data[$i]['NAME']   = dbOut($this->fm->fldVal($this->data['TBL']['EVT'],'NAME',"ID='".$row->TID."'"));
				  $data[$i]['URL']    = _EVNT_.'/'.$Id.'/'.dbOut($this->fm->fldVal($this->data['TBL']['EVT'],'ALIAS',"ID='".$row->TID."'"));
				}elseif($row->TYPE==STATUS_MD)
				{
				  $data[$i]['PDAY'] = date('d', strtotime($this->fm->fldVal($this->data['TBL']['MDC'],'PDATE',"ID='".$row->TID."'")));
				  $data[$i]['PMNTH'] = date('M', strtotime($this->fm->fldVal($this->data['TBL']['MDC'],'PDATE',"ID='".$row->TID."'")));
				  $data[$i]['PYR'] = date('Y', strtotime($this->fm->fldVal($this->data['TBL']['MDC'],'PDATE',"ID='".$row->TID."'")));
				  $data[$i]['NAME']   = dbOut($this->fm->fldVal($this->data['TBL']['MDC'],'NAME',"ID='".$row->TID."'"));
				  $data[$i]['URL']    = dbOut($this->fm->fldVal($this->data['TBL']['MDC'],'NURL',"ID='".$row->TID."'"));
				}
				else
				{
				  $data[$i]['NAME']   = dbOut($this->fm->fldVal($this->data['TBL']['PRJ'],'NAME',"ID='".$row->TID."'"));
				  $data[$i]['URL']    = _PRJ_.'/'.$Id.'/'.dbOut($this->fm->fldVal($this->data['TBL']['PRJ'],'ALIAS',"ID='".$row->TID."'"));
				}
				$i++;$Sr++;
			}
		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.