function DB_select_gp($dataArray)
{
$_sch_id = $_SESSION['org_id'];
$_userkey = $_SESSION['userkey'];
$requreStr = '';
if (isset($dataArray) && isset($dataArray['subject']) && $dataArray['subject'] != '' && $dataArray['subject'] != '000') {
$requreStr = " WHERE subjectkey='" . $dataArray['subject'] . "' ";
}
$sql_userjoin = " (SELECT userkey as _userkey ,groupkey as _groupkey,1 as countA FROM p_group_list WHERE BINARY userkey='" . $_userkey . "' AND enable ='1') AS pgl";
$sql_schjoin = " (SELECT groupkey as __groupkey,1 as countB FROM p_group WHERE BINARY gp_orgkey Like '%" . $_sch_id . "%' AND enable ='1') AS pgs";
$sql_postjoin = " (SELECT COUNT(postkey) as postNum,to_key FROM p_post WHERE create_date >= DATE_SUB(NOW(),INTERVAL 7 DAY) AND enable ='1' GROUP BY to_key ) AS pp ";
$sql = "SELECT pg.groupkey,pg.subjectkey,pg.gp_topic,pg.gp_scratch,pg.gp_pic,pg.gp_edition,pg.gp_intro,pg.gp_member,pg.gp_orgkey,pg.edit_date,pp.postNum FROM p_group AS pg LEFT JOIN " . $sql_userjoin . " ON pg.groupkey = pgl._groupkey LEFT JOIN " . $sql_schjoin . " ON pgs.__groupkey = pg.groupkey LEFT JOIN " . $sql_postjoin . " ON pp.to_key = pg.groupkey " . $requreStr . " and pg.enable = '1' ORDER BY pg.gp_edition DESC,countA DESC,countB DESC limit 21";
echo $sql;
$sql_result = mysql_query($sql);
while ($row_data = mysql_fetch_assoc($sql_result)) {
toPrint_multiTagWithoutAttr_special('group', $row_data, '');
}
}
function DB_get_post_info($dataArray)
{
$area = 'p_';
$tableName = $area . 'post';
$tableName_comment = $area . 'post_comment';
$tableName_attach = $area . 'post_attach';
$comment_str = '';
$attach_str = '';
$action = $dataArray['subAction'];
toPrint_oneMsg('subAction', $dataArray['subAction']);
switch ($action) {
case "init":
$sql = "Select cp.post_id,cp.postkey,cp.from_userkey,cp.to_key,cp.update_date,cp.create_date,cp.remark,cp.post_topic,cp.post_text,cp.post_attach,cp.num_comment,cp.create_date,up.username,up.userpic FROM " . $tableName . " as cp LEFT JOIN user_profile as up ON cp.from_userkey = up.userkey WHERE cp.enable = '1' AND cp.to_key ='" . $dataArray['to_key'] . "' ORDER BY cp.update_date DESC limit 21";
break;
case "more":
$sql = "Select cp.post_id,cp.postkey,cp.from_userkey,cp.to_key,cp.update_date,cp.create_date,cp.post_topic,cp.post_text,cp.post_attach,cp.num_comment,cp.create_date,up.username,up.userpic FROM " . $tableName . " as cp LEFT JOIN user_profile as up ON cp.from_userkey = up.userkey WHERE cp.enable = '1' AND cp.to_key ='" . $dataArray['to_key'] . "' AND cp.update_date < '" . $dataArray['getPost_min_editdate'] . "' ORDER BY cp.update_date DESC limit 21";
break;
case "update":
$sql = "Select cp.post_id,cp.postkey,cp.from_userkey,cp.to_key,cp.update_date,cp.create_date,cp.remark,cp.post_topic,cp.post_text,cp.post_attach,cp.num_comment,cp.create_date,up.username,up.userpic FROM " . $tableName . " as cp LEFT JOIN user_profile as up ON cp.from_userkey = up.userkey WHERE cp.enable = '1' AND cp.to_key ='" . $dataArray['to_key'] . "' AND cp.update_date >= '" . $dataArray['getPost_max_editdate'] . "' ORDER BY cp.update_date DESC limit 21";
break;
}
//echo($sql);
$sql_result = mysql_query($sql);
while ($row_data = mysql_fetch_assoc($sql_result)) {
$postkey = $row_data['postkey'];
if ($row_data['num_comment'] != '0') {
$comment_str = '';
$sql2 = "Select cp.postkey,cp.from_userkey,cp.create_date,cp.post_text,up.username,up.userpic FROM " . $tableName_comment . " as cp LEFT JOIN user_profile as up ON cp.from_userkey = up.userkey WHERE cp.from_postkey= '" . $postkey . "' AND cp.enable = '1' ORDER BY cp.create_date ASC";
$sql2_result = mysql_query($sql2);
while ($row_data2 = mysql_fetch_assoc($sql2_result)) {
$comment_str = $comment_str . toString_multiTagWithoutAttr('comment', $row_data2);
}
}
if ($row_data['post_attach'] != '0') {
$attach_str = '';
$sql3 = "Select attach_type,attach_link FROM " . $tableName_attach . " WHERE from_postkey='" . $postkey . "' AND enable = '1' ORDER BY post_attach_id ASC";
$sql3_result = mysql_query($sql3);
while ($row_data3 = mysql_fetch_assoc($sql3_result)) {
$attach_str = $attach_str . toString_multiTagWithoutAttr('attach', $row_data3);
}
}
toPrint_multiTagWithoutAttr_special('post', $row_data, $comment_str . $attach_str);
}
$recordStr = 'Result:' . $sql_result . '|Userkey:' . $_SESSION['userkey'];
recordlog('GetPost', $dataArray['to_key'], $recordStr);
}
function DB_select_getGpInfo($dataArray)
{
$_userKey = '';
if (isset($_SESSION['userkey'])) {
$_userKey = $_SESSION['userkey'];
}
$sql = "SELECT groupkey,subjectkey,gp_topic,gp_intro,gp_pic,gp_scratch,gp_control,gp_join,gp_member,gp_orgkey FROM p_group WHERE BINARY groupkey='" . $dataArray['groupkey'] . "' AND enable='1'";
$result = mysql_query($sql);
while ($row_data = mysql_fetch_assoc($result)) {
toPrint_multiTagWithoutAttr_special('groupinfo', $row_data, '');
}
$recordStr = 'Result:' . $result . '|Group:' . $dataArray['groupkey'] . '|Userkey:' . $_userKey;
recordlog('getGpInfo', $dataArray['groupkey'], $recordStr);
}
