smartcost/protected/logic/BaseLogic.php

<?php

abstract class BaseLogic {
	
	public function db() {
		return Doo::db ();
	}
	
	/**
	 * 获得分页数据
	 * @param unknown_type $table
	 * @param unknown_type $condition
	 * @param unknown_type $on_page
	 * @param unknown_type $page_size
	 */
	function get_page($table = "", $condition = "", $on_page = 1, $page_size = 20, $action = "", $get = "", $other = "page") {
		$page_c = "";
		
		$page ['previous'] = get_previous ( $on_page );
		
		$page ['on_page'] = $on_page;
		
		$total_count = $this->get_table_count ( $table, $condition );
		
		$total = intval ( $total_count / $page_size );
		
		$page ['total_page'] = ($total_count % $page_size) == 0 ? $total : $total + 1;
		
		$page ['total_data'] = $total_count;
		
		$page ['next'] = $on_page == $page ['total_page'] ? $page ['total_page'] : $on_page + 1;
		
		$i = 1;
		
		$page_max = 1;
		
		if ($on_page > 10) {
			$page_max = intval ( $on_page / 10 ) + 1;
			$i = intval ( $on_page / 10 ) * 10 - 1;
		}
		
		for(; $i <= $page ['total_page']; $i ++) {
			
			if ($i == $on_page) {
				if ($other == "page")
					$page_c .= '<a href="javascript:void(0);" class="current">' . $i . '</a>';
				else
					$page_c .= '&nbsp;<span class="current">' . $i . '</span>&nbsp;';
			} else if ($other == "page")
				$page_c .= '<a href="' . $action . $i . $get . '" class="paginate">' . $i . '</a>';
			else
				$page_c .= '&nbsp;<a href="' . $action . $i . $get . '" class="paginate">' . $i . '</a>&nbsp;';
			if ($i == (10 * $page_max))
				break;
		}
		
		$page ['page'] = $page_c;
		
		$page ['lower'] = (-- $on_page) * $page_size;
		
		return $page;
	}
	
	/**
	 * 获取总页数
	 * @param unknown_type $table
	 * @param unknown_type $condition
	 */
	public function get_table_count($table = "", $condition = "") {
		$sql = "select count(*) as count from " . $table . " where 1 " . $condition;
		
		$query = $this->db()->query ( $sql );
		
		$result = $query->fetch ();
		
		return $result ['count'];
	}
	
	/**
	 * 获取数据
	 * @param unknown_type $data 一般选择条件
	 * @param unknown_type $limit 
	 * @param unknown_type $condition
	 * @param unknown_type $table
	 */
	function get_list($data = array(), $condition = "", $limit = "", $table = "") {
		
		foreach ( $data as $key => $value ) {
			if (is_numeric ( $value ))
				$condition .= " and " . $key . " = " . $value;
			else
				$condition .= " and " . $key . " like '%" . $value . "%' ";
		}
		
		$condition = ' where 1 ' . $condition . $limit;
		
		$sql = "select * from " . $table . $condition;
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
	}
	
	/**
	 * 批量更新数据
	 * @param unknown_type $params 一个字段为一个数组
	 * @param unknown_type $table
	 * @param unknown_type $id
	 */
	function update_list($params = array(), $table = "", $id = "") {
		$pa = array ();
		
		$co = array ();
		
		$wh = array ();
		
		$count = count ( $params [$id] );
		
		foreach ( $params as $key => $value ) {
			array_push ( $pa, $key );
			
			if ($key != $id) {
				array_push ( $wh, $key . "=VALUES(" . $key . ")" );
			}
		}
		//获取更新内容
		for($i = 0; $i < $count; $i ++) {
			
			$tm = array ();
			
			foreach ( $pa as $k ) {
				
				array_push ( $tm, "'" . $params [$k] [$i] . "'" );
			}
			
			$tm = implode ( ",", $tm );
			
			array_push ( $co, "(" . $tm . ")" );
		}
		
		$pa = implode ( ",", $pa );
		
		$wh = implode ( ",", $wh );
		
		$co = implode ( ",", $co );
		
		$sql = "INSERT INTO " . $table . " (" . $pa . ") VALUES " . $co . " ON DUPLICATE KEY UPDATE " . $wh;
		
		$query = Doo::db ()->query ( $sql );
	
	}
	
	
	/**
	 * 获取通行证用户信息
	 * @param unknown_type $username
	 */
	function get_sso_user_info_by_name($username = "") {
		
		require_once (SITE_PATH . '/protected/plugin/client.php');
		
		$client = new client ( ZHSSO );
		
		$userinfo = $client->zhsso_getUserbyName ( $username );
		
		$userinfo = explode ( "\r", $userinfo );
		
		$ts = json_decode ( $userinfo ['1'], true );
		
		return $ts;
	}
	
}

?>