function getTemplateData($id) { global $_LABELS; global $_CONF; $client = new CLIENT($id); $data = $client->data; $data['society_code'] = sprintf("%s.%s.%s", str_pad($data['zone_id'], 3, '0', STR_PAD_LEFT), $data['category'], str_pad($data['society_id'], 5, '0', STR_PAD_LEFT)); $data['society_code'] = WEBPAGE::hotlink('BS.SCR.viewSociety', 'id', $data['society_id'], $data['society_code']); $zone = CLIENT::zones(); $data['zone'] = $zone[$data['zone_id']]; $data['advisor'] = current(SQL::getAssoc('tblUsers', 'id,CONCAT(first," ",last)', sprintf("id = '%s'", $data['advisor_id']))); $data['advisor'] = WEBPAGE::hotlink('BS.SCR.viewUser', 'id', $data['advisor_id'], $data['advisor']); $cstatus = CLIENT::cstatus(); $data['cstatus'] = $cstatus[$data['cstatus']]; $education = CLIENT::education(); $data['education'] = $education[$data['education']]; /** $data['img_path'] = sprintf(WEBPAGE::_IMG_CLIENT,$data['code']); if (($_CONF[auto_photo])&&(!(file_exists($data['img_path'])))) { $img_remote_path = sprintf("http://web.jce.do/consultas/FOTOS/%s/%s/%s/%s.jpg",substr($data['code'],0,3),substr($data['code'],4,2),substr($data['code'],6,2),$data['code']); if (!($fp_remote=@fopen($img_remote_path, "r"))) { $data['img_path'] = './img/unknown.png'; } else { $data['img_path'] = $img_remote_path; } } */ $c = 0; if ($data['advisor_id']) { $data['buttondata'][$c]['id'] = "BS.SCR.addClient"; $data['buttondata'][$c]['href'] = "index.php?scr_name=BS.SCR.addClient&id=" . $id; $data['buttondata'][$c]['alt'] = $_LABELS['edit']; $data['buttondata'][$c]['onClick'] = ""; $data['buttondata'][$c]['ico'] = "edit"; $c++; $data['buttondata'][$c]['id'] = "LN.SCR.browseLoans"; $data['buttondata'][$c]['href'] = "index.php?scr_name=LN.SCR.browseLoans&loan_code=." . str_pad($id, 6, 0, STR_PAD_LEFT); $data['buttondata'][$c]['alt'] = $_LABELS['LN.SCR.browseLoans']; $data['buttondata'][$c]['onClick'] = ""; $data['buttondata'][$c]['ico'] = "money_history"; $c++; $data['buttondata'][$c]['id'] = "BS.SCR.moveClient"; $data['buttondata'][$c]['href'] = "index.php?scr_name=BS.SCR.moveClient&ref=BS.SCR.editClient&id=" . $id; $data['buttondata'][$c]['alt'] = $_LABELS['moveClient']; $data['buttondata'][$c]['onClick'] = ""; $data['buttondata'][$c]['ico'] = "client_move"; $c++; $data['buttondata'][$c]['id'] = "BS.SCR.deactivateClient"; $data['buttondata'][$c]['href'] = "index.php?scr_name=BS.SCR.deactivateClient&ref=BS.SCR.editClient&id=" . $id; $data['buttondata'][$c]['alt'] = $_LABELS['deactivate']; $data['buttondata'][$c]['onClick'] = ""; $data['buttondata'][$c]['ico'] = "client_rem"; $c++; $data['buttondata'][$c]['id'] = "BS.SCR.addBusiness"; $data['buttondata'][$c]['href'] = "index.php?scr_name=BS.SCR.addBusiness&owner_id=" . $id; $data['buttondata'][$c]['alt'] = $_LABELS['addBusiness']; $data['buttondata'][$c]['onClick'] = ""; $data['buttondata'][$c]['ico'] = "business_add"; $c++; $data['buttondata'][$c]['id'] = "SV.SCR.applySurveyStepB"; $data['buttondata'][$c]['href'] = "index.php?scr_name=SV.SCR.browseSurveys&ref=SV.SCR.applySurveyStepA&client_id=" . $id; $data['buttondata'][$c]['alt'] = $_LABELS['applySurvey']; $data['buttondata'][$c]['onClick'] = ""; $data['buttondata'][$c]['ico'] = "survey_apply"; $c++; $data['buttondata'][$c]['id'] = "SV.SCR.viewGraph"; $data['buttondata'][$c]['href'] = "index.php?scr_name=SV.SCR.browseSurveys&stats_client_id=" . $id; $data['buttondata'][$c]['alt'] = $_LABELS['SV.SCR.viewGraph']; $data['buttondata'][$c]['onClick'] = ""; $data['buttondata'][$c]['ico'] = "survey_results"; $c++; } else { $data['buttondata'][$c]['id'] = "BS.SCR.addClient"; $data['buttondata'][$c]['href'] = "index.php?scr_name=BS.SCR.addClient&ref=BS.SCR.editClient&activate=1&id=" . $id; $data['buttondata'][$c]['alt'] = $_LABELS['activate']; $data['buttondata'][$c]['onClick'] = ""; $data['buttondata'][$c]['ico'] = "client_add"; $c++; } $data['buttondata'][$c]['id'] = "BS.SCR.viewClientIOM"; $data['buttondata'][$c]['href'] = 'javascript:openWin("index.popup.php?scr_name=BS.SCR.viewClientIOM&ref=BS.SCR.viewClient&id=' . $id . '","ClientIOM","menubar=no,scrollbars=no,resizable=no,width=700,height=320")'; $data['buttondata'][$c]['alt'] = $_LABELS['movements']; $data['buttondata'][$c]['onClick'] = ""; $data['buttondata'][$c]['ico'] = "client_history"; $c++; return $data; }
function getMembers() { global $_LABELS; // Get all groups involved - type G societies $mrow = SQL::select('tblLinkSocieties as ls, tblSocieties as s', 'ls.*, s.name', sprintf("ls.parent_id = '%s' AND ls.parent_id != ls.child_id AND s.id = ls.child_id", $this->data['id'])); for ($i = 0; $i < count($mrow); $i++) { $this->data['members'][$mrow[$i]['child_id']]['name'] = $mrow[$i]['name']; $this->data['members'][$mrow[$i]['child_id']]['member'] = array(); $this->data['members'][$mrow[$i]['child_id']]['deactivatebutton']['id'] = "rem" . $mrow[$i]['child_id']; $this->data['members'][$mrow[$i]['child_id']]['deactivatebutton']['alt'] = $_LABELS['deactivate']; $this->data['members'][$mrow[$i]['child_id']]['deactivatebutton']['ico'] = "deactivate"; $this->data['members'][$mrow[$i]['child_id']]['deactivatebutton']['href'] = sprintf('javascript:openWin("index.popup.php?scr_name=BS.SCR.deactivateBGMember&parent_id=%s&child_id=%s&rem=1","Remove","menubar=no,scrollbars=no,resizable=no,width=360,height=240")', $this->data['id'], $mrow[$i]['child_id']); $this->data['members'][$mrow[$i]['child_id']]['deactivatebutton']['onClick'] = "return true"; $this->data['members'][$mrow[$i]['child_id']]['movebutton']['id'] = "move" . $mrow[$i]['child_id']; $this->data['members'][$mrow[$i]['child_id']]['movebutton']['alt'] = $_LABELS['BS.SCR.moveSociety']; $this->data['members'][$mrow[$i]['child_id']]['movebutton']['ico'] = "move"; $this->data['members'][$mrow[$i]['child_id']]['movebutton']['href'] = sprintf('index.php?scr_name=BS.SCR.moveSociety&id=%s', $mrow[$i]['child_id']); $this->data['members'][$mrow[$i]['child_id']]['movebutton']['onClick'] = "return true"; } // Get all clients $client = new CLIENT(); $fields = "c.id, CONCAT(c.first,' ',c.last) AS client, c.society_id, s.name, c.advisor_id"; $tables = "tblClients AS c, tblLinkSocieties AS ls, tblSocieties as s"; $param = sprintf("ls.parent_id = '%s' AND ls.child_id = c.society_id AND s.id = c.society_id", $this->data['id']); $order = 'c.society_id'; $mrow = SQL::select_order($tables, $fields, $param, $order); $num = count($mrow); for ($i = 0; $i < $num; $i++) { $row = $mrow[$i]; // $client = new CLIENT($row['id']); $client->data['id'] = $row['id']; $client->data['advisor_id'] = $row['advisor_id']; $client->data['society_id'] = $row['society_id']; $client->data['name'] = $row['client']; $client->checkConfidentiality(); $this->data['confidential'] = $this->data['confidential'] || $client->data['confidential']; if ($this->data['president_id'] == $row['id']) { $row['president'] = "P"; } if ($this->data['treasurer_id'] == $row['id']) { $row['treasurer'] = "T"; } if ($this->data['secretary_id'] == $row['id']) { $row['secretary'] = "S"; } $this->data['members'][$client->data['society_id']]['member'][$row['id']]['name'] = $client->data['name']; $this->data['members'][$client->data['society_id']]['member'][$row['id']]['president'] = $row['president']; $this->data['members'][$client->data['society_id']]['member'][$row['id']]['treasurer'] = $row['treasurer']; $this->data['members'][$client->data['society_id']]['member'][$row['id']]['secretary'] = $row['secretary']; $members[$row['id']] = $client->data['name']; $member_lst[] = $row['id']; } return $members; }