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;
}
