function getTemplateData($id)
{
global $_LABELS;
global $_CONF;
$fields = sprintf("\t\r\n \t\t\t\tu.*,\r\n\t\t\t\tCONCAT(uc.first,' ',uc.last) AS creator, \r\n\t\t\t\tDATE_FORMAT(u.creator_date,'%s') AS f_creator_date, \r\n\t\t\t\tCONCAT(ue.first,' ',ue.last) AS editor, \r\n\t\t\t\tDATE_FORMAT(u.editor_date,'%s') AS f_editor_date, \r\n\t\t\t\tCONCAT(us.first,' ',us.last) AS super, \r\n\t\t\t\tDATE_FORMAT(u.birthdate,'%s') AS f_birthdate, \r\n\t\t\t\tz.zone", $_CONF['date_format_mysql'], $_CONF['date_format_mysql'], $_CONF['date_format_mysql']);
$tables = "tblUsers AS u, tblUsers AS us, tblUsers AS uc, tblUsers AS ue";
$left = "tblZones AS z";
$on = "u.zone_id = z.id";
$param = sprintf("u.id = '%s' AND u.super_id = us.id AND u.creator_id = uc.id AND u.editor_id = ue.id", $id);
$data = current(SQL::select_leftjoin($tables, $fields, $left, $on, $param));
$data['super'] = WEBPAGE::hotlink('BS.SCR.viewUser', 'id', $data['super_id'], $data['super']);
$data['name'] = sprintf("%s %s %s", $data['first'], $data['middle'], $data['last']);
$data['status'] = $_LABELS[sprintf('tblUsers.active.%s', $data['active'])];
$data['zone'] = WEBPAGE::hotlink('BS.SCR.viewZone', 'id', $data['zone_id'], $data['zone']);
$data['membership'] = self::getMembership($data['access_code']);
$data['img_path'] = sprintf(WEBPAGE::_IMG_USER, $data['username']);
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;
}
/*
if ($fp_remote=fopen($img_remote_path, "r")) {
$fp_local = fopen($img_path,"w");
$image = fread($fp_remote,102400);
fwrite($fp_local,$image,102400);
fclose($fp_remote);
fclose($fp_local);
}
*/
}
$c = 0;
$data['buttondata'][$c][id] = "BS.SCR.addUser";
$data['buttondata'][$c][href] = "index.php?scr_name=BS.SCR.addUser&id=" . $id;
$data['buttondata'][$c][alt] = $_LABELS['edit'];
$data['buttondata'][$c][onClick] = "";
$data['buttondata'][$c][ico] = "edit";
if ($data['active']) {
$c++;
$data['buttondata'][$c][id] = "BS.SCR.suspendUser";
$data['buttondata'][$c][href] = "index.php?scr_name=BS.SCR.suspendUser&id=" . $id;
$data['buttondata'][$c][alt] = $_LABELS['deactivate'];
$data['buttondata'][$c][onClick] = "";
$data['buttondata'][$c][ico] = "user_rem";
}
return $data;
}
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;
}
