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;
}
