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; }
/** * * 通过邀请人获取被邀请人 ... ... * @param unknown_type $uid */ private function get_Invitees_user($uid, $field = 'm.member_name,mi.member_id', $id = 'fuid', $process = '2', $isExtend = true, $extend_sql = '') { $_invite = new invite(); return $_invite->select_uid_to_fuid($uid, $field, $id, $process, $isExtend, $extend_sql); }