exec_query('homecells', ['*'], '', '', '', '', "s_id = '{$_SESSION['structure_id']}'");
} elseif (($leader_id == 1)) {
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "hc_l_id = '$member_id'");
} elseif (($leader_id == 3)) {
// co ordinator
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "co_1 = '$member_id' AND record_id = '{$_SESSION['structure_id']}'");
if ($get_Co_Res->num_rows < 1) {
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "co_2 = '$member_id' AND record_id = '{$_SESSION['structure_id']}'");
if ($get_Co_Res->num_rows < 1) {
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "co_3 = '$member_id' AND record_id = '{$_SESSION['structure_id']}'");
if ($get_Co_Res->num_rows < 1) {
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "co_4 = '$member_id' AND record_id = '{$_SESSION['structure_id']}'");
if ($get_Co_Res->num_rows < 1) {
} else {
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "co_or = 4 and s_id = '{$_SESSION['structure_id']}'");
}
} else {
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "co_or = 3 and s_id = '{$_SESSION['structure_id']}'");
}
} else {
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "co_or = 2 and s_id = '{$_SESSION['structure_id']}'");
}
} else {
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "co_or = 1 and s_id = '{$_SESSION['structure_id']}'");
}
} elseif (($leader_id == 4)) {
// co ordinator
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "sv_1 = '$member_id' AND record_id = '{$_SESSION['structure_id']}'");
if ($get_Co_Res->num_rows < 1) {
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "sv_2 = '$member_id' AND record_id = '{$_SESSION['structure_id']}'");
if ($get_Co_Res->num_rows < 1) {
} else {
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "sv = 2 and s_id = '{$_SESSION['structure_id']}'");
}
} else {
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "sv = 1 and s_id = '{$_SESSION['structure_id']}'");
}
} elseif (($leader_id == 5)) {
// 2IC
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "2ic_a_id = '$member_id' OR 2ic_b_id = '$member_id' ");
}
return $result;
}
function get_homecell_info($homecell_id)
{
$db = self::db();
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "record_id = '$homecell_id' AND church_id = '{$_SESSION['church_id']}'");
return $result;
}
function get_hcl_list()
{
$db = self::db();
$result = $db->exec_query('members', ['*'], '', '', '', '', "leader_id = 1 AND church_id = '{$_SESSION['church_id']}'");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
function get_users_list()
{
$db = self::db();
$result = $db->exec_query('users', ['*'], 'LEFT', 'members', 'mem_id', 'record_id', "1");
while ($list = $result->fetch_assoc()) {
//$recordids = $result['record_id'];
$array[] = "";
}
return implode($array);
}
function get_structure_list()
{
$db = self::db();
$result = $db->exec_query('structures', ['*']);
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
function get_overseer($structure_id = 0, $type = 'name/id')
{
if ($structure_id == 0) {
} else {
$db = self::db();
if ($type == 'id') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$ov_id = $results_for_overseer['ov_id'];
$result_over_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$ov_id'");
$current_ov = $result_over_as_member->fetch_assoc();
return $ov_name = $current_ov['name'];
}
if ($type == 'id') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
return $ov_id = $results_for_overseer['ov_id'];
} else {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$ov_id = $results_for_overseer['ov_id'];
$result_over_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$ov_id'");
$current_ov = $result_over_as_member->fetch_assoc();
$ov_name = $current_ov['name'];
$ov_surname = $current_ov['surname'];
$array[] = "";
$result = $db->exec_query('members', ['*'], '', '', '', '', "record_id != '$ov_id' AND leader_id = 6 ");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
}
}
function get_supervisor_a($structure_id = 0, $type = 'name/id')
{
$db = self::db();
if ($structure_id == 0) {
} else {
if ($type == 'name') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$sv_1 = $results_for_overseer['sv_1'];
$result_sv_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$sv_1'");
$current_sv = $result_sv_as_member->fetch_assoc();
return $sv_name = $current_sv['name'];
}
if ($type == 'id') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
return $sv_1 = $results_for_overseer['sv_1'];
} else {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$sv_1 = $results_for_overseer['sv_1'];
if ($sv_1 == '' || $sv_1 == Null) {
$array[] = "";
} else {
$result_sv_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$sv_1'");
$current_sv = $result_sv_as_member->fetch_assoc();
$sv_name = $current_sv['name'];
$sv_surname = $current_sv['surname'];
$array[] = "";
$result = $db->exec_query('members', ['*'], '', '', '', '', "record_id != '$sv_1' AND leader_id = 6");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
}
return implode($array);
}
}
}
function get_supervisor_b($structure_id = 0, $type = 'name/id')
{
if ($structure_id == 0) {
} else {
$db = self::db();
if ($type == 'name') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$sv_1 = $results_for_overseer['sv_2'];
$result_sv_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$sv_1'");
$current_sv = $result_sv_as_member->fetch_assoc();
return $sv_name = $current_sv['name'];
}
if ($type == 'id') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
return $sv_1 = $results_for_overseer['sv_2'];
} else {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$sv_1 = $results_for_overseer['sv_2'];
$result_sv_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$sv_1'");
$current_sv = $result_sv_as_member->fetch_assoc();
$sv_name = $current_sv['name'];
$sv_surname = $current_sv['surname'];
$array[] = "";
$result = $db->exec_query('members', ['*'], '', '', '', '', "record_id != '$sv_1' AND leader_id = 6");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
}
}
function get_co_or_a($structure_id = 0, $type = 'name/id')
{
if ($structure_id == 0) {
} else {
$db = self::db();
if ($type == 'name') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$co_1 = $results_for_overseer['co_1'];
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_1'");
$current_co = $result_co_as_member->fetch_assoc();
return $co_name = $current_co['name'];
}
if ($type == 'id') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
return $co_1 = $results_for_overseer['co_1'];
} else {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$co_1 = $results_for_overseer['co_1'];
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_1'");
$current_co = $result_co_as_member->fetch_assoc();
$co_name = $current_co['name'];
$co_surname = $current_co['surname'];
$array[] = "";
$result = $db->exec_query('members', ['*'], '', '', '', '', "record_id != '$co_1' AND leader_id = 6");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
}
}
function get_co_ordinators($structure_id = 0)
{
if ($structure_id == 0) {
} else {
$db = self::db();
$array[] = "";
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$co_1 = $results_for_overseer['co_1'];
if (strlen($co_1) < 2) {
} else {
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_1'");
$current_co = $result_co_as_member->fetch_assoc();
$co_name = $current_co['name'];
$array[] = "";
}
$co_2 = $results_for_overseer['co_2'];
if (strlen($co_2) < 2) {
} else {
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_2'");
$current_co = $result_co_as_member->fetch_assoc();
$co_name = $current_co['name'];
$array[] = "";
}
$co_3 = $results_for_overseer['co_3'];
if (strlen($co_3) < 2) {
} else {
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_3'");
$current_co = $result_co_as_member->fetch_assoc();
$co_name = $current_co['name'];
$array[] = "";
}
$co_4 = $results_for_overseer['co_4'];
if (strlen($co_4) < 2) {
} else {
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_4'");
$current_co = $result_co_as_member->fetch_assoc();
$co_name = $current_co['name'];
$array[] = "";
}
return implode($array);
}
}
function get_co_or_b($structure_id = 0, $type = 'name/id')
{
if ($structure_id == 0) {
} else {
$db = self::db();
if ($type == 'name') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$co_1 = $results_for_overseer['co_2'];
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_1'");
$current_co = $result_co_as_member->fetch_assoc();
return $co_name = $current_co['name'];
}
if ($type == 'id') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
return $co_1 = $results_for_overseer['co_2'];
} else {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$co_1 = $results_for_overseer['co_2'];
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_1'");
$current_co = $result_co_as_member->fetch_assoc();
$co_name = $current_co['name'];
$co_surname = $current_co['surname'];
$array[] = "";
$result = $db->exec_query('members', ['*'], '', '', '', '', "record_id != '$co_1' AND leader_id = 6");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
}
}
function get_co_or_c($structure_id = 0, $type = 'name/id')
{
if ($structure_id == 0) {
} else {
$db = self::db();
if ($type == 'name') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$co_1 = $results_for_overseer['co_3'];
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_1'");
$current_co = $result_co_as_member->fetch_assoc();
return $co_name = $current_co['name'];
}
if ($type == 'id') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
return $co_1 = $results_for_overseer['co_3'];
} else {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$co_1 = $results_for_overseer['co_3'];
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_1'");
$current_co = $result_co_as_member->fetch_assoc();
$co_name = $current_co['name'];
$co_surname = $current_co['surname'];
$array[] = "";
$result = $db->exec_query('members', ['*'], '', '', '', '', "record_id != '$co_1' AND leader_id = 6");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
}
}
function get_co_or_d($structure_id = 0, $type = 'name/id')
{
if ($structure_id == 0) {
} else {
$db = self::db();
if ($type == 'name') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$co_1 = $results_for_overseer['co_4'];
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_1'");
$current_co = $result_co_as_member->fetch_assoc();
return $co_name = $current_co['name'];
}
if ($type == 'id') {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
return $co_1 = $results_for_overseer['co_4'];
} else {
$result_ov_res = $db->exec_query('structures', ['*'], '', '', '', '', "record_id = '$structure_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$co_1 = $results_for_overseer['co_4'];
$result_co_as_member = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$co_1'");
$current_co = $result_co_as_member->fetch_assoc();
$co_name = $current_co['name'];
$co_surname = $current_co['surname'];
$array[] = "";
$result = $db->exec_query('members', ['*'], '', '', '', '', "record_id != '$co_1' AND leader_id = 6");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
}
}
function get_hc_leader($homecell_id, $type = 'name/id')
{
$db = self::db();
if ($type == 'name') {
$result_ov_res = $db->exec_query('homecells', ['*'], '', '', '', '', "record_id = '$homecell_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$hc_id = $results_for_overseer['hc_l_id'];
$result_ov_res = $db->exec_query('members', ['*'], '', '', '', '', "record_id = $hc_id");
$results_for_overseer = $result_ov_res->fetch_assoc();
return $results_for_overseer['name'];
}
if ($type == 'id') {
$result_ov_res = $db->exec_query('homecells', ['*'], '', '', '', '', "record_id = '$homecell_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
return $results_for_overseer['hc_l_id'];
} else {
$result_ov_res = $db->exec_query('homecells', ['*'], '', '', '', '', "record_id = '$homecell_id'");
$results_for_overseer = $result_ov_res->fetch_assoc();
$hc_id = $results_for_overseer['hc_l_id'];
$result_ov_res = $db->exec_query('members', ['*'], '', '', '', '', "record_id = $hc_id");
$results_for_overseer = $result_ov_res->fetch_assoc();
$hc_l_name = $results_for_overseer['name'];
$array[] = "";
$result = $db->exec_query('members', ['*'], '', '', '', '', "record_id != '$hc_id' AND leader_id = 6");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
}
function get_structure_homecells($structure_id, $supervisor_id, $co_ordinator_id, $dev = False)
{
$db = self::db();
if ($dev == False) {
return $result_ov_res = $db->exec_query('homecells', ['*'], '', '', '', '', "s_id = '$structure_id' AND sv = '$supervisor_id' AND co_or = '$co_ordinator_id'");
} else {
return $result_ov_res = $db->exec_query('homecells', ['*'], '', '', '', '', "s_id = '$structure_id' AND sv = '$supervisor_id' AND co_or = '$co_ordinator_id'", '', True);
}
}
function match_paster($member_id){
$db = self::db();
$res = $db->exec_query('pasters',['*'],'','','','',"mem_id = $member_id");
return $res->num_rows;
}
function get_supervisor_homecells($structure_id, $supervisor_id)
{
$db = self::db();
return $result_ov_res = $db->exec_query('homecells', ['*'], '', '', '', '', "s_id = '$structure_id' AND sv_id = '$supervisor_id'");
}
function get_co_or_homecells($structure_id, $co_ordinator_id)
{
$db = self::db();
return $result_ov_res = $db->exec_query('homecells', ['*'], '', '', '', '', "s_id = '$structure_id' AND co_or_id = '$co_ordinator_id'");
}
function get_member_list()
{
$db = self::db();
$result = $db->exec_query('members', ['*'], '', '', '', '', "leader_id <= 6 ","ORDER BY `name` ASC");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
function get_member_list_head()
{
$db = self::db();
$result = $db->exec_query('members', ['*'], '', '', '', '', "leader_id <= 6 ","ORDER BY `name` ASC");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
function get_all_list()
{
$db = self::db();
$result = $db->exec_query('members', ['*']);
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
function get_savable_member_list()
{
$db = self::db();
$result = $db->exec_query('members', ['*'], '', '', '', '', "leader_id = 6 OR leader_id = 7 OR leader_id = 8");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
function get_nmo_able_member_list()
{
$db = self::db();
$result = $db->exec_query('members', ['*'], '', '', '', '', "leader_id = 8");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
function get_hc_list()
{
$db = self::db();
$result = $db->exec_query('homecells', ['*'], '', '', '', '', "church_id = '{$_SESSION['church_id']}'");
while ($list = $result->fetch_assoc()) {
$hl_res = $db->exec_query('members', ['*'], '', '', '', '', "homecell_ids = '{$list['record_id']}' AND leader_id = '1'");
$hl_info = $hl_res->fetch_assoc();
if (isset($hl_info['name'])) {
$array[] = "";
}
}
return implode($array);
}
function get_ministry_list()
{
$db = self::db();
$result = $db->exec_query('ministries', ['*']);
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
function get_homecell_member_list($homecell_id)
{
$db = self::db();
$array = [];
$result = $db->exec_query('members', ['*'], '', '', '', '', "homecell_ids = '$homecell_id' AND (leader_id = 6 OR leader_id = 1 OR leader_id = 5) ");
$i = 0;
while ($list = $result->fetch_assoc()) {
$array[] = "
";
$i++;
}
return implode($array);
}
function get_ministry_member_list($ministry_id)
{
$db = self::db();
$array = [];
$result = $db->exec_query('members', ['*'], '', '', '', '', "group_ids LIKE '%,$ministry_id,%'");
$i = 0;
while ($list = $result->fetch_assoc()) {
$array[] = "
";
$i++;
}
return implode($array);
}
function get_ministry_member_select($ministry_id)
{
$db = self::db();
$array = [];
$result = $db->exec_query('members', ['*'], '', '', '', '', "group_ids LIKE '%,$ministry_id,%'");
$i = 0;
while ($list = $result->fetch_assoc()) {
$array[] = "";
$i++;
}
return implode($array);
}
function get_follow_up_list($structure_id, $member_id)
{
$db = self::db();
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "co_1 = '$member_id' AND record_id = $structure_id");
if ($get_Co_Res->num_rows < 1) {
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "co_2 = '$member_id' AND record_id = $structure_id");
if ($get_Co_Res->num_rows < 1) {
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "co_3 = '$member_id' AND record_id = $structure_id");
if ($get_Co_Res->num_rows < 1) {
$get_Co_Res = $db->exec_query('structures', ['*'], '', '', '', '', "co_4 = '$member_id' AND record_id = $structure_id");
if ($get_Co_Res->num_rows < 1) {
} else {
$homecell = $db->exec_query('homecells', ['*'], '', '', '', '', "co_or = 4 and s_id = $structure_id");
}
} else {
$homecell = $db->exec_query('homecells', ['*'], '', '', '', '', "co_or = 3 and s_id = $structure_id");
}
} else {
$homecell = $db->exec_query('homecells', ['*'], '', '', '', '', "co_or = 2 and s_id = $structure_id");
}
} else {
$homecell = $db->exec_query('homecells', ['*'], '', '', '', '', "co_or = 1 and s_id = $structure_id");
}
$array = [];
while ($homecells = $homecell->fetch_assoc()) {
$result = $db->exec_query('members', ['*'], '', '', '', '', "structure_id = '$structure_id' AND leader_id = 8 AND homecell_ids = {$homecells['record_id']}");
$i = 0;
while ($list = $result->fetch_assoc()) {
$array[] = "
";
$i++;
}
}
return implode($array);
}
function get_homecell_member_list_submit($homecell_id)
{
$db = self::db();
$array = [];
$result = $db->exec_query('members', ['*'], '', '', '', '', "church_id = '{$_SESSION['church_id']}' AND homecell_ids = '$homecell_id' and leader_id != 7 and leader_id != 8");
$i = 0;
while ($list = $result->fetch_assoc()) {
$array[] = "
";
$i++;
}
$array[] = "";
return implode($array);
}
function get_ministry_member_list_submit($ministry_id)
{
$db = self::db();
$array = [];
$result = $db->exec_query('members', ['*'], '', '', '', '', "group_ids LIKE '%,$ministry_id,%'");
$i = 0;
while ($list = $result->fetch_assoc()) {
$array[] = "
";
$i++;
}
$array[] = "";
return implode($array);
}
function get_homecell_invite_list_submit($homecell_id)
{
$db = self::db();
$array = [];
$result = $db->exec_query('members', ['*'], '', '', '', '', "church_id = '{$_SESSION['church_id']}' AND homecell_ids = '$homecell_id' AND leader_id = 7");
$i = 0;
while ($list = $result->fetch_assoc()) {
$array[] = "
";
$i++;
}
$array[] = "";
return implode($array);
}
function get_homecell_member_list_select($homecell_id)
{
$db = self::db();
$array = [];
$result = $db->exec_query('members', ['*'], '', '', '', '', "church_id = '{$_SESSION['church_id']}' AND homecell_ids = '$homecell_id' AND (leader_id = '6' OR leader_id = '1')");
while ($list = $result->fetch_assoc()) {
$array[] = "";
}
return implode($array);
}
function get_invite_list($homecell_id, $actions = 0)
{
$db = self::db();
$array = [];
$result = $db->exec_query('members', ['*'], '', '', '', '', "homecell_ids = '$homecell_id' AND leader_id != '7' AND leader_id != '8'", "ORDER BY leader_id ASC");
$i = 0;
while ($list = $result->fetch_assoc()) {
$array[] = "
";
$i++;
$resultsA = $db->exec_query('members', ['*'], '', '', '', '', " invited_member_id = '{$list['record_id']}' AND (leader_id = '7' OR leader_id='8')");
while ($invites = $resultsA->fetch_assoc()) {
$array[] = "
";
$i++;
}
}
return implode($array);
}
function get_prayer_list($homecell_id, $actions = 0)
{
$db = self::db();
$array = [];
$result = $db->exec_query('prayer_list', ['*'], '', '', '', '', "church_id = '{$_SESSION['church_id']}' AND homecell_id = '$homecell_id' AND prayer_status = 'ACTIVE'", "ORDER BY record_id ASC");
while ($list = $result->fetch_assoc()) { ?>
' />
:
' />
exec_query('prayer_list', ['*'], '', '', '', '', "church_id = '{$_SESSION['church_id']}' AND record_id = '$prayer_id'");
$list = $result->fetch_assoc();
return $list;
}
function get_member_info($member_id)
{
$db = self::db();
$result = $db->exec_query('members', ['*'], '', '', '', '', "record_id = '$member_id'");
$list = $result->fetch_assoc();
return $list;
}
function ajax($function_name, $ajax_file_path, $html_ids_to_get_and_send = [], $page_to_send_after_done = '')
{
// $stringBuild = '';
// foreach ($html_ids_to_get_and_send as $html_id) {
// $stringBuild .= '&'. $html_id .'='
// }
//
?>
//