<?php
namespace model\doctor;
/**
 * Class blood
 * @package model
 */
class ddata extends \model\element
{
	public function __construct($elecfg='dt_data')
    {
		parent::__construct($elecfg);
	}

	public function getCageId($str)
    {
		return $this->db->get('dt_cate','cid',['csmall'=>$str]);
	}

	public function getTargetList($uid)
    {
        $rows = [];
        if(!empty($uid)){
            $sql = "SELECT * FROM `dt_cate`
            LEFT OUTER JOIN `dt_user_target`  ON utcid = cid AND utuid = '{:uid}'
            ORDER BY cbig,csmall";
            $sql = qgprintf($sql,['uid'=>$uid]);
            $st = $this->db->query($sql);
            $rows = $st->fetchAll(\PDO::FETCH_ASSOC);
        }
		$data = [
			'page'=> 0,
			'total'=> 1,
			'records' => 1000,
			'rows' => $rows
		];
		return $data;        
	}
	
	public function setTarget($uid,$cid,$filed,$value)
	{
	    $utid = $this->db->get('dt_user_target','utid',['utcid'=>$cid,'utuid'=>$uid]);
	    if($utid){
    	    $sql = "UPDATE dt_user_target SET ".$filed."='".$value."'
    	            WHERE  utid='".$utid."'";
	    }else{
    	    $sql = "INSERT INTO dt_user_target SET ".$filed."='".$value."'
    	            ,utuid='".$uid."',utcid='".$cid."'";
	    }
	    $this->db->query($sql);
	}
}