<?php
define ('ISAJAX', 1);
$comConfig = include('/home/wwwroot/YPB2C/mvc/common.config.php');
include('/home/wwwroot/YPB2C/mvc/lib/LibDb.php');
include('/home/wwwroot/YPB2C/mvc/lib/LibFc.php');

$dbConf = [
	'db_type'	=>'mysql',
	'db_host'	=>'rm-wz9pv1nh76k0i25b7.mysql.rds.aliyuncs.com',
	'db_port'	=>'3306',
    'db_name'	=>'temp_showpart',      //数据库名称
    'db_user'	=>'yiparts',
	'db_pass'	=>'A=iY+n-Pa!s@A#to',
	'db_charset'=>'utf8'
];
$DbBase = new DbBase(new LibDb ($dbConf));

$arr = [];
switch($_GET['fun'])
{
	case 'search':
		$nowPage = isset($_GET['page']) && $_GET['page'] > 0? (int) $_GET['page']: 1;
		$perpage = 20;
		$where = '';
		$word = false;
		foreach($_GET as $field=>$val)
		{
			$val = urldecode($val);
			if($val == 'N' || $val == 'NH') $val == 'N.0';
			if(!empty($val) && in_array($field, ['word', 'lnk_area', 'lnk_code', 'lnk_name', 'lnk_addr_1', 'lnk_addr_2']))
			{
				if($field == 'word')
				{
					$word = true;
                    $word = LibFc::Escape($val);
                    $fword = LibFc::FormatNum($word,'北厅');
                    if($fword!=''){
                        $fword_where = sprintf("lnk_keyword like '%%%s%%' or",$fword);
                    }
					$where .= sprintf(" and (%s lnk_name like '%%%s%%' or lnk_product like '%%%s%%')", 
                                        $fword_where, $word, $word);
				}
				else if($field == 'lnk_code')
				{
					$where .= sprintf(" and %s like '%s%%'", $field, LibFc::Escape($val));
				}
				else
				{
					$where .= sprintf(" and %s like '%%%s%%'", $field, LibFc::Escape($val));
				}
			}
		}
		$where .= $word ? sprintf(' order by lnk_seq, lnk_area, lnk_code, lnk_name limit %s,%s', ($nowPage-1)*$perpage, $perpage) : sprintf(' order by lnk_area, lnk_code, lnk_name limit %s,%s', ($nowPage-1)*$perpage, $perpage);
		$res = $DbBase->get('links',['lnk_id, lnk_area, lnk_code, lnk_name, lnk_alias, lnk_text, lnk_logo, lnk_concat, lnk_concat,lnk_duty,lnk_addr_1, lnk_addr_2,lnk_qq, lnk_tel'] ,$where);
		$arr = $res['data'];
		foreach($arr as $k=>$v)
		{
			//$arr[$k]['lnk_remark'] = strtr($arr[$k]['lnk_remark'], ["\r\n"=>'<br>', "\r"=>'<br>', "\n"=>'<br>']);
			$arr[$k]['lnk_logo'] = empty($v['lnk_logo'])? $comConfig['HOST']['b2c'].'static/images/indexlogo.png': $comConfig['HOST']['b2c'].'show/logo/'.$v['lnk_logo'];
		}
	break;
	case 'info':
		$res = $DbBase->get('links', ['*'], sprintf(" and lnk_id=%d", $_GET['lnk_id']), true);
		$arr = $res['data'];
		if(!empty($arr))
		{
			$arr['lnk_remark'] = strip_tags($arr['lnk_remark']);
			unset($arr['lnk_logo_url']);
			$arr['lnk_logo'] = empty($arr['lnk_logo'])? $comConfig['HOST']['b2c'].'static/images/indexlogo.png': $comConfig['HOST']['b2c'].'show/logo/'.$arr['lnk_logo'];
		}
	break;
	case 'zhanwei': 
		$arr = ['1.1H','2.1H','2.2H','3H','4.1H','5.1H','5.2H','6.1H','6.2H','7.1H','7.2H','8.1H','8.2H','NH'/*,'WH'*/];
	break;
	case 'isshow_pjl':
		$arr = [
			'logo'=>'https://www.paojd.cn/static/images/paojieling.png',
			'url'=>'http://www.yiparts.com/pjls?from=xcxzw',
			'time'=>time(),
			'version'=>'1.0.0',
			'show'=>'0'
		];
	break;
}
echo LibFc::ajaxJsonEncode(['status'=>true, 'data'=>$arr]);
exit;
/**
  * @method 跑街令表基本操作
  * @author soul
  * @copyright 2016/3/31
  */
class DbBase
{
	protected $Db = null;
	public function __construct($Db)
	{
		$this->Db = $Db;
	}
	
	/**
	  * @method 查询表信息
	  * @param  $Table 表明 如：yp_product 或者 yp_product as a join yp_number as b on a.pid=b.pid
	  * @param  $FieldArr 需要查询的字段名称数组
	  * @param  $Where 查询条件
	  * @param  $OneRow true|false
	  * @author soul
	  * @copyright 2016/3/30
	  * @return array(3) { ["status"]=> bool(true) ["data"]=> $OneRow=false 二维数组 ; $OneRow=true 一维数组["code"]=> int(0) } 
	  */
	public function get($Table, $FieldArr, $Where = '', $OneRow = false)
	{
		if(!empty($FieldArr) && is_array($FieldArr))
		{
			$Sql = sprintf("select %s from %s where 1=1 %s", implode(',', $FieldArr), LibFc::Escape($Table), $Where);
			$ResFlag = $this->Db->Query($Sql);
			if($ResFlag)
			{
				$Arr = array();
				while($Row = $this->Db->Fetch())
				{
					if($OneRow)
					{
						$Arr = $Row;
						break;
					}
					else
					{
						$Arr[] = $Row;
					}
				}
				return LibFc::ReturnData(true, $Arr);
			}
			return LibFc::ReturnData(false, $Table.'查询SQL语句执行失败。');
		}
		return LibFc::ReturnData(false, $Table.'查询提供的参数不正确。');
	}
}