public function getall() { $Connection = new CreateConnection(); $mysqli = $Connection->connectToDatabase(); $SQL = "SELECT * FROM priority"; $result = $mysqli->query("{$SQL}"); $list = array(); while ($row = $result->fetch_object()) { $list[] = $row; } $Connection->closeConnection(); return $list; }
<?php header("Content-type: text/html; charset=utf-8"); require_once dirname(__FILE__) . '/Department.php'; require_once dirname(__FILE__) . '/CreateConnection.php'; require_once dirname(__FILE__) . '/User.php'; require_once dirname(__FILE__) . '/Tag.php'; require_once dirname(__FILE__) . '/Material.php'; require_once dirname(__FILE__) . '/SendMessage.php'; require_once dirname(__FILE__) . '/Agent.php'; require_once dirname(__FILE__) . '/Menu.php'; require_once dirname(__FILE__) . '/Chat.php'; $corpid = "your corpid"; $corpsecret = "your corpsecret"; $createConnection = new CreateConnection(); $token = $createConnection->getAccessToken($corpid, $corpsecret); if ($token) { echo "Token:" . $token . "<br/>"; echo "<pre>"; //$department = new Department($token); //var_dump($department->getDepartmentList()); //var_dump($department->createDepartment("合作伙伴")); //var_dump($department->updateDepartment(13, "测试部门3")); //var_dump($department->deleteDepartment(13)); //var_dump($department->getDepartmentByID(3)); //var_dump($department->getDepartmentsByName('生')); //$user = new User($token); //var_dump($user->getUserList(1, 1)); //var_dump($user->getUserListDetails(1, 1)); //var_dump($user->createUser('xxxx', 'xxx', 8, FALSE, '*****@*****.**', 'xxxx', FALSE, 1)); //var_dump($user->inviteConcern('ewewew'));
public function update() { $Connection = new CreateConnection(); $mysqli = $Connection->connectToDatabase(); $this->id = $mysqli->real_escape_string($this->id); $this->name = $mysqli->real_escape_string($this->name); $this->password = $mysqli->real_escape_string($this->password); $this->group_id = $mysqli->real_escape_string($this->group_id); $SQL = "update user set name ='" . $this->name . "',password= '******',group_id= " . $this->group_id . " where id=" . $this->id . ""; $result = $mysqli->query($SQL); if (!$result) { throw new Exception($mysqli->error); } }
public function getaging() { $Connection = new CreateConnection(); $mysqli = $Connection->connectToDatabase(); $SQL = "select i.title, IFNULL(u1.name,'Unassigned') as programer_name,IFNULL(u2.name,'Unassigned') as customer_name,i.created, DATEDIFF(Now(), date(i.created)) AS days,i.customer_id,i.programer_id from issue i left join user u1 on u1.id = i.programer_id left join user u2 on u2.id = i.customer_id where i.state = 1 or i.state = 2 order by days Desc"; $result = $mysqli->query("{$SQL}"); $list = array(); while ($row = $result->fetch_object()) { $list[] = $row; } $Connection->closeConnection(); return $list; }