public function logLinkGroupMember($req, $lk, $arg) { $db = new POD(); $p = $db->connect(); if ($p == false) { throw new Exception('Database connect failed'); } $map = array('researchGroupMemberItem' => 'res_member', 'researchGroupLogItem' => 'res_group_log'); $table = array('res_member', 'res_group_log'); $sql = $db->genLinkSql($req, $lk, $arg, $table, $map); $res = $db->query($sql); return $res; }
public function stuLinkClass($req, $lk, $arg) { $db = new POD(); $p = $db->connect(); if ($p == false) { throw new Exception('Database connect failed'); } $map = array('studentIdentityItem' => 'stu_identification_info', 'studentInfoItem' => 'stu_basic_info'); $table = array('stu_identification_info', 'stu_basic_info'); $sql = $db->genLinkSql($req, $lk, $arg, $table, $map); $res = $db->query($sql); return $res; }
public function leaderLinkStudent($req, $lk, $arg) { $db = new POD(); $p = $db->connect(); if ($p == false) { throw new Exception('Database connect failed'); } $map = array('classLeaderItem' => 'class_leader', 'studentInfoItem' => 'stu_basic_info'); $table = array('class_leader', 'stu_basic_info'); $sql = $db->genLinkSql($req, $lk, $arg, $table, $map); $res = $db->query($sql); return $res; }
public function messageLinkContent($req, $lk, $arg) { $db = new POD(); $p = $db->connect(); if ($p == false) { throw new Exception('Database connect failed'); } $map = array('messageContentItem' => 'message', 'messageContraceItem' => 'message_interconnect'); $table = array('message', 'message_interconnect'); $sql = $db->genLinkSql($req, $lk, $arg, $table, $map); $res = $db->query($sql); return $res; }
public function awardLinkTeacher($req, $lk, $arg) { $db = new POD(); $p = $db->connect(); if ($p == false) { throw new Exception('Database connect failed'); } $map = array('teacherInfoItem' => 'teacher_basic_info', 'teacherAwardItem' => 'teacher_award'); $table = array('teacher_award', 'teacher_basic_info'); $sql = $db->genLinkSql($req, $lk, $arg, $table, $map); $res = $db->query($sql); return $res; }
public function projectLinkGroup($req, $lk, $arg) { $db = new POD(); $p = $db->connect(); if ($p == false) { throw new Exception('Database connect failed'); } $map = array('researchGroupProjectItem' => 'res_group_achievement', 'researchGroupItem' => 'res_group'); $table = array('res_group_achievement', 'res_group'); $sql = $db->genLinkSql($req, $lk, $arg, $table, $map); $res = $db->query($sql); return $res; }
public function test2Action() { require $_SERVER['DOCUMENT_ROOT'] . '/school' . '/model/pod.php'; $db = new POD(); $p = $db->connect(); if ($p == false) { throw new Exception('Database connect failed'); } $req = array(); $lk = array('account'); $req[0] = array('key' => 'account', 'account' => '111', 'table' => 'p'); $arg = array('name', 'password'); $table = array('Person', 'Account'); $map = array('p' => 'Person', 'a' => 'Account'); $sql = $db->genLinkSql($req, $lk, $arg, $table, $map); //echo $sql; //exit; $res = $db->query($sql); return $res; }