private function get_condition()
{
$condition = '';
if (($gid = (int) $this->input['groupid']) > 0 || ($gradeid = (int) $this->input['gradeid']) > 0) {
$this->memberCredits->setJoin(' LEFT JOIN ' . DB_PREFIX . 'member as m ON m.member_id = mc.u_id');
$gid && ($condition = ' AND m.gid = \'' . $gid . '\'');
$gradeid && ($condition = ' AND m.gradeid = \'' . $gradeid . '\'');
$this->memberCredits->setWhere($condition);
} else {
if (isset($this->input['startcredit1']) || isset($this->input['endcredit1'])) {
if (($startcredit1 = (int) $this->input['startcredit1']) || isset($this->input['startcredit1'])) {
$condition = ' AND credit1>=' . $startcredit1;
$this->memberCredits->setWhere($condition);
}
if ((($endcredit1 = (int) $this->input['endcredit1']) || isset($this->input['endcredit1'])) && $endcredit1 >= $startcredit1) {
$condition = ' AND ' . 'credit1<=' . $endcredit1;
$this->memberCredits->setWhere($condition);
}
} else {
if (isset($this->input['startcredit2']) || isset($this->input['endcredit2'])) {
if (($startcredit2 = (int) $this->input['startcredit2']) || isset($this->input['startcredit2'])) {
$condition = ' AND credit2>=' . $startcredit2;
$this->memberCredits->setWhere($condition);
}
if ((($endcredit2 = (int) $this->input['endcredit2']) || isset($this->input['endcredit2'])) && $endcredit2 >= $startcredit2) {
$condition = ' AND ' . 'credit2<=' . $endcredit2;
$this->memberCredits->setWhere($condition);
}
} else {
if (($fbid = (int) $this->input['fbid']) > 0) {
$feedback = new feedback();
$membersId = $feedback->get_feed_members($fbid, '0,1');
if (!$membersId) {
throw new Exception(FEEDBACK_ID_NO_MEMBER, 200);
}
$this->memberCredits->setWhere(array('u_id' => $membersId['member_id']));
} else {
if ($spreadCode = trim($this->input['spreadcode'])) {
$this->memberCredits->setJoin(' LEFT JOIN ' . DB_PREFIX . 'spread_record as sr ON mc.u_id=sr.fuid');
$condition = " AND sr.spreadcode = '" . $spreadCode . "'";
$this->memberCredits->setWhere($condition);
} else {
if (($invite_userid = (int) $this->input['invite_userid']) > 0) {
$_invite = new invite();
$fuidArr = $_invite->select_uid_to_fuid($invite_userid, 'mi.fuid', 'fuid', 3, false);
if (!$fuidArr) {
throw new Exception(MEMBER_NO_INVITE_MEMBERS, 200);
}
$this->memberCredits->setWhere(array('u_id' => $fuidArr));
} else {
if (($medalid = (int) $this->input['medalid']) > 0) {
$this->memberCredits->setJoin(' LEFT JOIN ' . DB_PREFIX . 'member_medal as mm ON mm.member_id=mc.u_id');
$condition = " AND mm.medalid = " . $medalid . " AND (mm.expiration=0 OR mm.expiration>" . TIMENOW . ")";
$this->memberCredits->setWhere($condition);
} else {
if ($member_type = trim($this->input['member_type'])) {
$this->memberCredits->setJoin(' LEFT JOIN ' . DB_PREFIX . 'member_bind as mb ON mb.member_id=mc.u_id');
$condition = ' AND mb.type = \'' . $member_type . '\'';
$this->memberCredits->setWhere($condition);
} else {
if ($this->input['start_time'] || $this->input['end_time']) {
$this->memberCredits->setJoin(' LEFT JOIN ' . DB_PREFIX . 'member as m ON m.member_id = mc.u_id');
if ($start_time = trim(urldecode($this->input['start_time']))) {
$start_time = strtotime($start_time);
$condition = " AND m.create_time >= " . (int) $start_time;
$this->memberCredits->setWhere($condition);
}
if ($end_time = trim(urldecode($this->input['end_time']))) {
$end_time = strtotime($end_time);
if ($end_time >= $start_time) {
$condition = " AND m.create_time <= " . (int) $end_time;
$this->memberCredits->setWhere($condition);
}
}
}
}
}
}
}
}
}
}
}
if (($appid = (int) $this->input['mappid']) > 0) {
$this->memberCredits->setJoin(' LEFT JOIN ' . DB_PREFIX . 'member as m ON m.member_id = mc.u_id');
$condition = " AND m.appid = " . $appid;
$this->memberCredits->setWhere($condition);
}
if (isset($this->input['identifier'])) {
$identifierUserSystem = new identifierUserSystem();
$identifier = $identifierUserSystem->setIdentifier((int) $this->input['identifier'])->checkIdentifier();
//多用户系统
$this->memberCredits->setJoin(' LEFT JOIN ' . DB_PREFIX . 'member as m ON m.member_id = mc.u_id');
$condition = " AND m.identifier = " . $identifier;
$this->memberCredits->setWhere($condition);
}
$this->memberCredits->setAs('mc');
return $condition;
}