public function getList($search) { $mysql = new Mysql(); $PageSize = intval($search->PageSize); $FirstRow = intval($search->PageIndex - 1) * $PageSize; $sqlList = "select Subject,Url from project where (Status=6 or Status=7) and Type=" . intval($this->Type) . " order by Pv desc LIMIT {$FirstRow}, {$PageSize};"; $sqlCount = "select count(Id) from project where (Status=6 or Status=7) and Type=" . intval($this->Type); $res = array(); if ($search->NeedCount) { // 查找 count 和 数据 $totalCount = $mysql->getVar($sqlCount); if (empty($totalCount)) { $res["Success"] = true; $res["Data"] = null; $res["Count"] = 0; } else { $res["Success"] = true; $res["Data"] = $mysql->getData($sqlList); $res["Count"] = $totalCount; } } else { // 只查找数据 $res["Success"] = true; $res["Data"] = $mysql->getData($sqlList); } $mysql->closeDb(); return $res; }
public function getUserByProjectId($projectId) { $mysql = new Mysql(); $sql = "SELECT GROUP_CONCAT(DISTINCT result.UserId) as Ids ,GROUP_CONCAT(DISTINCT result.name) as Names FROM (SELECT d.UserId,u.Name FROM " . $mysql->dbpre . "developer" . $mysql->debug . " as d ," . $mysql->dbpre . "user" . $mysql->debug . " as u WHERE d.UserId=u.UserId and ProjectId=" . intval($projectId) . " ) as result"; //echo $sql; $result = $mysql->getLine($sql); $mysql->closeDb(); return $result; }
public function getList($projectId) { $mysql = new Mysql(); $sql = "SELECT m.*,u.Name FROM " . $mysql->dbpre . "memo" . $mysql->debug . " as m," . $mysql->dbpre . "user" . $mysql->debug . " as u WHERE m.UserId=u.UserId AND ProjectId=" . intval($projectId); // var_dump( $sql ); // exit; $result = $mysql->getData($sql); $mysql->closeDb(); return $result; }
public function add() { $reValue = 0; $mysql = new Mysql(); $sql = "insert into boguan_tubu_invit (Name,Phone,Address,CreateTime) values(\n \t\t'" . $mysql->escape($this->Name) . "',\n '" . $mysql->escape($this->Phone) . "',\n \t\t'" . $mysql->escape($this->CreateTime) . "'\n \t\t)"; //echo $sql; $mysql->runSql($sql); $reValue = $mysql->lastId(); if ($mysql->errno() == 1062) { $reValue = -1; } $mysql->closeDb(); return $reValue; }
public function getListByParentId($parentId) { $mysql = new Mysql(); $sql = "select * from " . $mysql->dbpre . "department" . $mysql->debug . " where parentId=" . intval($this->ParentId); $data = $mysql->getData($sql); $mysql->closeDb(); $res = array(); if (!empty($data)) { $res["Success"] = true; $res["Data"] = $data; } else { $res["Success"] = false; } return $res; }
public function getList($search) { $mysql = new Mysql(); $PageSize = intval($search->PageSize); $FirstRow = intval($search->PageIndex - 1) * $PageSize; $sqlList = "SELECT h.*,(SELECT Subject FROM " . $mysql->dbpre . "project" . $mysql->debug . " WHERE Id=h.ProjectId) AS Subject,u.Name,u.Ratio as UserRotio FROM " . $mysql->dbpre . "hours" . $mysql->debug . " as h," . $mysql->dbpre . "user" . $mysql->debug . " as u WHERE h.UserId=u.UserId"; $sqlCount = "SELECT COUNT(Id) from " . $mysql->dbpre . "hours" . $mysql->debug . " where 1=1"; if ($search->ProjectId > -1) { $sqlList .= " AND ProjectId= " . intval($search->ProjectId); $sqlCount .= " AND ProjectId= " . intval($search->ProjectId); } if ($search->Status > -1) { $sqlList .= " AND Status= " . intval($search->Status); $sqlCount .= " AND Status= " . intval($search->Status); } // var_dump( $sql ); // exit; $sqlList .= " Order by id desc LIMIT {$FirstRow}, {$PageSize};"; //var_dump( $sqlList ); //var_dump( $sqlCount ); // exit; $res = array(); if ($search->NeedCount) { // 查找 count 和 数据 $totalCount = $mysql->getVar($sqlCount); if (empty($totalCount)) { $res["Success"] = true; $res["Data"] = null; $res["Count"] = 0; } else { $res["Success"] = true; $res["Data"] = $mysql->getData($sqlList); //print_r($sqlList); $res["Count"] = $totalCount; } //$Res["Set"] = true; } else { // 只查找数据 $res["Success"] = true; $res["Data"] = $mysql->getData($sqlList); //$res["Set"] = false; } $mysql->closeDb(); // $Res["Sql"] = $Sql; // $Res["SqlCount"] = $SqlCount; return $res; }
function delCategories($ids, $root) { $mysql = new Mysql(); $sqlformat = "delete from %scategory%s where belong=%d and id in (%s)"; $sql = sprintf($sqlformat, $mysql->dbpre, $mysql->debug, $this->Belong, $ids); //echo $sql;return; $result = $mysql->runSql($sql); if ($result) { $newParentId = $root + 1000; //转移子分类到默认分类里 $sqlformat = "Update %scategory%s set ParentId=%d where belong=%d and parentId in (" . $ids . ")"; $sql = sprintf($sqlformat, $mysql->dbpre, $mysql->debug, intval($newParentId), $this->Belong, $ids); //echo $sql; $result = $mysql->runSql($sql); } $mysql->closeDb(); return $result; }
function delPosts($ids) { $mysql = new Mysql(); $sql = "delete from " . $mysql->dbpre . "post" . $mysql->debug . " where belong=" . intval($this->Belong) . " and id in (" . $ids . ")"; $mysql->runSql($sql); $mysql->closeDb(); return true; }
function getList($search) { $mysql = new Mysql(); $PageSize = intval($search->PageSize); $FirstRow = intval($search->PageIndex - 1) * $PageSize; $sqlList = "SELECT *,(SELECT name FROM user WHERE UserId=p.UserId) as Name from " . $mysql->dbpre . "project" . $mysql->debug . " as p where 1=1"; $sqlCount = "SELECT COUNT(Id) from " . $mysql->dbpre . "project" . $mysql->debug . " where 1=1"; if ($search->Type > -1) { $sqlList .= " AND Type= " . intval($search->Type); $sqlCount .= " AND Type= " . intval($search->Type); } if ($search->Department > -1) { $sqlList .= " AND Department= " . intval($search->Department); $sqlCount .= " AND Department= " . intval($search->Department); } if ($search->Team > -1) { $sqlList .= " AND Team= " . intval($search->Team); $sqlCount .= " AND Team= " . intval($search->Team); } if ($search->Status > 0) { if ($search->Status == 100) { $sqlList .= " AND Status<6"; $sqlCount .= " AND Status<6"; } else { if ($search->Status == 200) { $sqlList .= " AND Status>5 AND Status<10"; $sqlCount .= " AND Status>5 AND Status<10"; } else { $sqlList .= " AND Status=" . intval($search->Status); $sqlCount .= " AND Status=" . intval($search->Status); } } } if ($search->UserId > 0) { $sqlList .= " AND UserId= " . intval($search->UserId); $sqlCount .= " AND UserId =" . intval($search->UserId); } if ($search->Developer > 0) { $sqlList .= " AND ( Id in ( SELECT ProjectId FROM " . $mysql->dbpre . "hours" . $mysql->debug . " where UserId =" . intval($search->Developer) . ")"; $sqlCount .= " AND ( Id in ( SELECT ProjectId FROM " . $mysql->dbpre . "hours" . $mysql->debug . " where UserId =" . intval($search->Developer) . ")"; $sqlList .= " OR Id in ( SELECT ProjectId FROM " . $mysql->dbpre . "developer" . $mysql->debug . " where UserId =" . intval($search->Developer) . "))"; $sqlCount .= " OR Id in ( SELECT ProjectId FROM " . $mysql->dbpre . "developer" . $mysql->debug . " where UserId =" . intval($search->Developer) . "))"; } // 1按提交顺序(从先到后)2按上线时间(从近到远)3按总PV值(从高到低)4按推荐指数(从高到低)5按工时(从少到多) switch ($search->Order) { case 1: $sqlList .= " ORDER BY ID ASC"; break; case 2: $sqlList .= " ORDER BY PublishTime DESC"; break; case 3: $sqlList .= " ORDER BY PV DESC"; break; case 4: $sqlList .= " ORDER BY LAUD DESC,PublishTime DESC"; break; case 5: $sqlList .= " ORDER BY Hours ASC"; break; default: if ($search->Status == 200) { $sqlList .= " ORDER BY PublishTime DESC"; } else { if ($search->Status == 100) { $sqlList .= " ORDER BY PublishTime ASC, CreateTime ASC"; } else { $sqlList .= " ORDER BY Status ASC"; } } break; } $sqlList .= " LIMIT {$FirstRow}, {$PageSize};"; //var_dump( $sqlList ); //var_dump( $sqlCount ); // exit; $res = array(); if ($search->NeedCount) { // 查找 count 和 数据 $totalCount = $mysql->getVar($sqlCount); if (empty($totalCount)) { $res["Success"] = true; $res["Data"] = null; $res["Count"] = 0; } else { $res["Success"] = true; $res["Data"] = $mysql->getData($sqlList); //print_r($sqlList); $res["Count"] = $totalCount; } //$Res["Set"] = true; } else { // 只查找数据 $res["Success"] = true; $res["Data"] = $mysql->getData($sqlList); //$res["Set"] = false; } $mysql->closeDb(); // $Res["Sql"] = $Sql; // $Res["SqlCount"] = $SqlCount; return $res; }
public function getUserListByDept($deptId) { $mysql = new Mysql(); $sql = "SELECT UserId,Name FROM " . $mysql->dbpre . "user" . $mysql->debug . " WHERE Department=" . intval($deptId); // var_dump( $sql ); // exit; $result = $mysql->getData($sql); $mysql->closeDb(); return $result; }