function users_list_alm_users_user_photo_BeforeShow(&$sender)
{
$users_list_alm_users_user_photo_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $users_list;
//Compatibility
//End users_list_alm_users_user_photo_BeforeShow
//Custom Code @31-2A29BDB7
// -------------------------
// Write your own code here.
$db = new clsDBdbConnection();
$user_guid = $users_list->alm_users->guid->GetValue();
$photo = trim(CCDLookup("photo", "alm_users", "guid = '{$user_guid}'", $db));
//Default photo
if (strlen($photo) <= 0) {
$photo = "user128.png";
}
$options = Options::getConsoleOptions();
$url = $options["console_internal_url"] . $options["console_users_url"] . $photo;
$users_list->alm_users->user_photo->SetValue($url);
$db->close();
// -------------------------
//End Custom Code
//Close users_list_alm_users_user_photo_BeforeShow @30-EE399A43
return $users_list_alm_users_user_photo_BeforeShow;
}
function products_maintcontent_alm_products_suite_code_BeforeShow(&$sender)
{
$products_maintcontent_alm_products_suite_code_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $products_maintcontent;
//Compatibility
//End products_maintcontent_alm_products_suite_code_BeforeShow
//Custom Code @39-2A29BDB7
// -------------------------
// Write your own code here.
$suite_id = $sender->GetValue();
$db = new clsDBdbConnection();
$suite_description = CCDLookup("suite_description", "alm_product_suites", "id = {$suite_id}", $db);
$products_maintcontent->alm_products->description->SetValue($suite_description);
$db->close();
// -------------------------
//End Custom Code
//Close products_maintcontent_alm_products_suite_code_BeforeShow @7-CEF8E22D
return $products_maintcontent_alm_products_suite_code_BeforeShow;
}
function licensing_customerscontent_licensing_BeforeInsert(&$sender)
{
$licensing_customerscontent_licensing_BeforeInsert = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $licensing_customerscontent;
//Compatibility
//End licensing_customerscontent_licensing_BeforeInsert
//Custom Code @188-2A29BDB7
// -------------------------
// Write your own code here.
$suiteId = $licensing_customerscontent->licensing->suite_code->GetValue();
$params = array();
$params["suite_id"] = $suiteId;
$products = new Alm\Products();
$suiteStatus = $products->getSuiteStatusById($params);
//Check if suite status is active or legacy before adding any new licenses to a customer
if ($suiteStatus["suiteStatus"] == "1" || $suiteStatus["suiteStatus"] == "2") {
$guid = uuid_create();
global $lastguid;
$lastguid = $guid;
$licensing_customerscontent->licensing->created_iduser->SetValue(CCGetUserID());
$licensing_customerscontent->licensing->hidguid->SetValue($guid);
//Customer ID for the license
$customer_guid = trim($licensing_customerscontent->licensing->hidcustomer_guid->GetValue());
$db = new clsDBdbConnection();
$customer_id = CCDLookup("id", "alm_customers", "guid = '{$customer_guid}'", $db);
$db->close();
$licensing_customerscontent->licensing->hidcustomer_id->SetValue($customer_id);
//Changing license status to active when inactive and grant,expdate,expirdate are present
$grantNo = trim($licensing_customerscontent->licensing->grant_number->GetValue());
$expDate = $licensing_customerscontent->licensing->expedition_date->GetValue();
$expirDate = $licensing_customerscontent->licensing->expiration_date->GetValue();
$licenseStatus = (int) $licensing_customerscontent->licensing->hidlicensestatus->GetValue();
$licenseType = (int) $licensing_customerscontent->licensing->id_license_type->GetValue();
$o = trim($licensing_customerscontent->licensing->hido->GetValue());
$dguid = trim($licensing_customerscontent->licensing->hiddguid->GetValue());
$params = array();
$params["guid"] = $dguid;
if ($o == "renew") {
//Keeps the expired license guid reference on the new renewed license
$licensing_customerscontent->licensing->hidexpired_license_guid->SetValue($dguid);
}
//Making sure that perpetual licenses dont get expiration date values
//And change status to active if grantnumber, expiration date have values
//This changed, perpetuals will be autoactivated and user redirected to add the support license automatically
if ($licenseStatus == 1 && strlen($grantNo) > 0 && count($expDate) > 1 && count($expirDate) > 1) {
if ($licenseType == 7 || $licenseType == 12) {
$licensing_customerscontent->licensing->expiration_date->SetValue("");
}
$licensing_customerscontent->licensing->hidlicensestatus->SetValue("2");
//If renewing and new license is activated, sets expired license as archived
if ($o == "renew") {
$products = new Alm\Products();
$products->setLicenseArchivedByGuid($params);
}
} else {
//Its a perpetual license
if ($licenseStatus == 1 && ($licenseType == 7 || $licenseType == 12)) {
$licensing_customerscontent->licensing->expiration_date->SetValue("");
$licensing_customerscontent->licensing->hidlicensestatus->SetValue("2");
}
}
//Checking if its an addsupport operation to set the support parent perpetual license
$parentLicenseGuid = trim($licensing_customerscontent->licensing->hiddguid->GetValue());
$o = trim($licensing_customerscontent->licensing->hido->GetValue());
if ($o == "addsupport" && strlen($parentLicenseGuid) > 0) {
$licensing_customerscontent->licensing->hidparent_license_guid->SetValue($parentLicenseGuid);
}
//Upgrade licensing
$o = $licensing_customerscontent->licensing->hido->GetValue();
if (strlen($dguid) > 0 && $o == "upgrade_license") {
//Keeps the expired license guid reference on the new renewed license
$licensing_customerscontent->licensing->hidexpired_license_guid->SetValue($dguid);
$params = array();
$params["guid"] = $dguid;
$products = new Alm\Products();
$products->setLicenseArchivedByGuid($params);
}
} else {
global $CCSLocales;
$licensing_customerscontent->licensing->InsertAllowed = false;
$licensing_customerscontent->licensing->Errors->clear();
$licensing_customerscontent->licensing->Errors->addError($CCSLocales->GetText("suite_status_notactivelegacy"));
}
// -------------------------
//End Custom Code
//Close licensing_customerscontent_licensing_BeforeInsert @154-8C89F39C
return $licensing_customerscontent_licensing_BeforeInsert;
}
public function saveContactSubHobbies($params = array())
{
$result = array("status" => false, "message" => "", "result" => array());
$subhobbie = $params["subhobbie"];
$contact_guid = $params["contact_guid"];
$parent_id = $params["parent_id"];
if (strlen($contact_guid) > 0) {
$db2 = new clsDBdbConnection();
$subhobbies_list = "";
foreach ($subhobbie as $hobbie) {
$subhobbies_list .= $hobbie . ",";
}
//Check if subhobbies for the parent_id has been added for the contact
$contact_id = CCDLookup("id", "alm_customers_contacts", "guid = '{$contact_guid}'", $db2);
$parent_hobbie = (int) CCDLookup("1 as exist", "alm_customers_contacts_subhobbies_details", "contact_id = {$contact_id} and hobbie_id = {$parent_id}", $db2);
$contact_hobbies = CCDLookup("hobbies", "alm_customers_contacts", "id = {$contact_id}", $db2);
$contact_hobbies = trim($contact_hobbies, ",");
$contact_hobbies = explode(",", $contact_hobbies);
if (!in_array($parent_id, $contact_hobbies)) {
$contact_hobbies[] = $parent_id;
}
$contact_hobbies = implode(",", $contact_hobbies);
$sql2 = "update alm_customers_contacts set hobbies = '{$contact_hobbies}' where id = {$contact_id} ";
$db2->query($sql2);
if ($parent_hobbie == 1) {
$sql2 = "update alm_customers_contacts_subhobbies_details set subhobbies = '{$subhobbies_list}' where contact_id = {$contact_id} and hobbie_id = {$parent_id}";
$db2->query($sql2);
} else {
$guidDetail = uuid_create();
$sql2 = "insert into alm_customers_contacts_subhobbies_details(guid,contact_id, hobbie_id, subhobbies) values('{$guidDetail}',{$contact_id}, {$parent_id}, '{$subhobbies_list}')";
$db2->query($sql2);
}
$db2->close();
$result["status"] = true;
$result["message"] = "Command executed successfully";
return $result;
}
return $result;
}
function contacts_holidays_maintcontent_alm_contacts_holidays_pnday_position_BeforeShow(&$sender)
{
$contacts_holidays_maintcontent_alm_contacts_holidays_pnday_position_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $contacts_holidays_maintcontent;
//Compatibility
//End contacts_holidays_maintcontent_alm_contacts_holidays_pnday_position_BeforeShow
//Custom Code @25-2A29BDB7
// -------------------------
// Write your own code here.
$guid = CCGetFromGet("guid", "");
if (strlen($guid) > 0) {
$db = new clsDbdbConnection();
$holiday_id = (int) CCDLookup("id", "alm_customers_contacts_holidays", "guid = '{$guid}'", $db);
if ($holiday_id == 2 || $holiday_id == 3) {
$contacts_holidays_maintcontent->alm_contacts_holidays->pnday_position->Visible = true;
} else {
$contacts_holidays_maintcontent->alm_contacts_holidays->pnday_position->Visible = false;
}
$db->close();
} else {
$contacts_holidays_maintcontent->alm_contacts_holidays->pnday_position->Visible = false;
}
// -------------------------
//End Custom Code
//Close contacts_holidays_maintcontent_alm_contacts_holidays_pnday_position_BeforeShow @24-21C15399
return $contacts_holidays_maintcontent_alm_contacts_holidays_pnday_position_BeforeShow;
}
function contacts_maintcontent_alm_customers_contacts_BeforeShow(&$sender)
{
$contacts_maintcontent_alm_customers_contacts_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $contacts_maintcontent;
//Compatibility
//End contacts_maintcontent_alm_customers_contacts_BeforeShow
//Custom Code @37-2A29BDB7
// -------------------------
// Write your own code here.
global $Tpl;
$guid = CCGetFromGet("guid", "");
$db = new clsDBdbConnection();
$db2 = new clsDBdbConnection();
$db3 = new clsDBdbConnection();
$contact_hobbies = explode(",", trim($contacts_maintcontent->alm_customers_contacts->hidhobbies->GetValue(), ","));
$sql = "select id,hobbies from alm_customers_contacts_hobbies";
$db->query($sql);
while ($db->next_record()) {
$hobbie_id = $db->f("id");
$Tpl->setvar("hobbie_value", $hobbie_id);
$Tpl->setvar("hobbie_title", $db->f("hobbies"));
if (in_array($db->f("id"), $contact_hobbies)) {
$Tpl->setvar("hobbie_checked", "checked");
} else {
$Tpl->setvar("hobbie_checked", "");
}
$parentPath = $Tpl->block_path;
$Tpl->block_path = $Tpl->block_path . "/hobbies_list";
$Tpl->SetBlockVar("subhobbies_list", "");
$sql2 = "select id,subhobbi from alm_customers_contacts_subhobbies where hobbie_id = {$hobbie_id}";
$db2->query($sql2);
$contact_guid = $contacts_maintcontent->alm_customers_contacts->hidguid->GetValue();
$contact_id = CCDLookup("id", "alm_customers_contacts", "guid = '{$contact_guid}'", $db3);
$subhobbie = CCDLookup("subhobbies", "alm_customers_contacts_subhobbies_details", "contact_id = {$contact_id} and hobbie_id = {$hobbie_id}", $db3);
$subhobbie = explode(",", $subhobbie);
while ($db2->next_record()) {
$subhubbie_id = $db2->f("id");
if (in_array($subhubbie_id, $subhobbie)) {
$Tpl->setvar("subhobbie_checked", "checked");
} else {
$Tpl->setvar("subhobbie_checked", "");
}
$Tpl->setvar("parent_hobbie", $hobbie_id);
$Tpl->setvar("subhobbie_value", $subhubbie_id);
$Tpl->setvar("subhobbie_title", $db2->f("subhobbi"));
$Tpl->Parse("subhobbies_list", true);
}
$table_detail = $Tpl->GetVar("subhobbies_list");
$Tpl->block_path = $parentPath;
$Tpl->SetBlockVar("subhobbies_list", $table_detail);
$Tpl->Parse("hobbies_list", true);
}
$db3->close();
$db2->close();
$db->close();
// -------------------------
//End Custom Code
//Close contacts_maintcontent_alm_customers_contacts_BeforeShow @2-DACA5085
return $contacts_maintcontent_alm_customers_contacts_BeforeShow;
}
function customers_maintcontent_alm_customers_BeforeShow(&$sender)
{
$customers_maintcontent_alm_customers_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $customers_maintcontent;
//Compatibility
//End customers_maintcontent_alm_customers_BeforeShow
//Custom Code @140-2A29BDB7
// -------------------------
// Write your own code here.
$guid = CCGetFromGet("guid", "");
$contact_guid = CCGetFromGet("contact_guid", "");
$tab = CCGetFromGet("tab", "");
$o = CCGetFromGet("o", "");
$params = array();
$params["customer_guid"] = $guid;
$params["contact_guid"] = $contact_guid;
if (strlen($guid) > 0) {
global $Tpl;
global $FileName;
$customers = new Customers();
$contacts = $customers->getCustomerContacts($params);
$contacts = $contacts["contacts"];
$querystring = CCGetQueryString("QueryString", array("contact_guid"));
$db = new clsDBdbConnection();
foreach ($contacts as $contact) {
$editurl = $FileName . "?{$querystring}&contact_guid=" . $contact["guid"] . "&tab=addcontact";
$Tpl->setvar("lbedit", $editurl);
if ($contact["maincontact"] == "1") {
$Tpl->setvar("lbmaincontact", "");
} else {
$Tpl->setvar("lbmaincontact", "hide");
}
$Tpl->setvar("lbcontact", $contact["contact"]);
$jobposition = $contact["jobposition"];
$jobposition = CCDLookup("jobposition", "alm_jobpositions", "id = {$jobposition}", $db);
$Tpl->setvar("lbcontact_jobposition", $jobposition);
$Tpl->setvar("lbcontact_phone", $contact["phone"]);
$Tpl->setvar("lbcontact_extension", $contact["extension"]);
$Tpl->setvar("lbcontact_mobile", $contact["mobile"]);
$Tpl->setvar("lbcontact_workemail", $contact["workemail"]);
$Tpl->setvar("lbcontact_personalemail", $contact["personalemail"]);
$dateupdated = $contact["dateupdated"];
if (strlen($dateupdated) > 0) {
$dateupdated_array = CCParseDate($dateupdated, array("yyyy", "-", "mm", "-", "dd", " ", "H", ":", "n", ":", "s"));
$format = array("mm", "/", "dd", "/", "yyyy", " ", "hh", ":", "nn", " ", "AM/PM");
$dateupdated = CCFormatDate($dateupdated_array, $format);
$Tpl->setvar("lbcontact_dateupdated", $dateupdated);
}
$Tpl->parse("contact_list", true);
}
$db->close();
}
//Filling up contact info for updates
if (strlen($contact_guid) > 0 && $o != "delcontact") {
$customers = new Customers();
$contacts = $customers->getCustomerContactByGuid($params);
$contacts = $contacts["contacts"];
if (is_array($contacts[0])) {
$customers_maintcontent->alm_customers->contact->SetValue($contacts[0]["contact"]);
$customers_maintcontent->alm_customers->contact_jobposition->SetValue($contacts[0]["jobposition"]);
$customers_maintcontent->alm_customers->contact_phone->SetValue($contacts[0]["phone"]);
$customers_maintcontent->alm_customers->contact_extension->SetValue($contacts[0]["extension"]);
$customers_maintcontent->alm_customers->contact_mobile->SetValue($contacts[0]["mobile"]);
$customers_maintcontent->alm_customers->contact_workemail->SetValue($contacts[0]["workemail"]);
$customers_maintcontent->alm_customers->contact_personalemail->SetValue($contacts[0]["personalemail"]);
$customers_maintcontent->alm_customers->contact_maincontact->SetValue($contacts[0]["maincontact"]);
$contact_dob = $contacts[0]["contact_dob"];
$contact_dob_array = CCParseDate($contact_dob, array("yyyy", "-", "mm", "-", "dd"));
if ($contact_dob_array[1] == "0000") {
$contact_dob_array = null;
}
$customers_maintcontent->alm_customers->contact_dob->SetValue($contact_dob_array);
$contact_preferred_color = explode(",", $contacts[0]["preferred_color"]);
$customers_maintcontent->alm_customers->contact_preferred_color->Multiple = true;
$customers_maintcontent->alm_customers->contact_preferred_color->SetValue($contact_preferred_color);
$contact_hobbies = explode(",", $contacts[0]["hobbies"]);
$customers_maintcontent->alm_customers->contact_hobbies->Multiple = true;
$customers_maintcontent->alm_customers->contact_hobbies->SetValue($contact_hobbies);
$contact_holidays = explode(",", $contacts[0]["notify_holidays"]);
$customers_maintcontent->alm_customers->contact_notify_holidays->Multiple = true;
$customers_maintcontent->alm_customers->contact_notify_holidays->SetValue($contact_holidays);
}
}
// -------------------------
//End Custom Code
//Close customers_maintcontent_alm_customers_BeforeShow @8-32D525B2
return $customers_maintcontent_alm_customers_BeforeShow;
}
function customers_viewcontent_alm_customers_BeforeShow(&$sender)
{
$customers_viewcontent_alm_customers_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $customers_viewcontent;
//Compatibility
//End customers_viewcontent_alm_customers_BeforeShow
//Custom Code @157-2A29BDB7
// -------------------------
// Write your own code here.
$guid = CCGetFromGet("guid", "");
$contact_guid = CCGetFromGet("contact_guid", "");
$tab = CCGetFromGet("tab", "");
$o = CCGetFromGet("o", "");
$params = array();
$params["customer_guid"] = $guid;
$params["contact_guid"] = $contact_guid;
if (strlen($guid) > 0) {
global $Tpl;
global $FileName;
$customers = new Customers();
$contacts = $customers->getCustomerContacts($params);
$contacts = $contacts["contacts"];
$querystring = CCGetQueryString("QueryString", array());
$db = new clsDBdbConnection();
foreach ($contacts as $contact) {
//$editurl = $FileName."?$querystring&contact_guid=".$contact["guid"]."&tab=addcontact";
//$deleteurl = $FileName."?$querystring&contact_guid=".$contact["guid"]."&tab=addcontact&o=delcontact";
//$Tpl->setvar("lbedit","");
//$Tpl->setvar("lbdelete","");
$Tpl->setvar("lbcontact", $contact["contact"]);
if ($contact["maincontact"] == "1") {
$Tpl->setvar("lbmaincontact", "");
} else {
$Tpl->setvar("lbmaincontact", "hide");
}
$jobposition = $contact["jobposition"];
$jobposition = CCDLookup("jobposition", "alm_jobpositions", "id = {$jobposition}", $db);
$Tpl->setvar("lbcontact_jobposition", $jobposition);
$Tpl->setvar("lbcontact_phone", $contact["phone"]);
$Tpl->setvar("lbcontact_extension", $contact["extension"]);
$Tpl->setvar("lbcontact_mobile", $contact["mobile"]);
$Tpl->setvar("lbcontact_workemail", $contact["workemail"]);
$Tpl->setvar("lbcontact_personalemail", $contact["personalemail"]);
$dateupdated = $contact["dateupdated"];
if (strlen($dateupdated) > 0) {
$dateupdated_array = CCParseDate($dateupdated, array("yyyy", "-", "mm", "-", "dd", " ", "H", ":", "n", ":", "s"));
$format = array("mm", "/", "dd", "/", "yyyy", " ", "hh", ":", "nn", " ", "AM/PM");
$dateupdated = CCFormatDate($dateupdated_array, $format);
$Tpl->setvar("lbcontact_dateupdated", $dateupdated);
}
$Tpl->parse("contact_list", true);
}
$db->close();
}
// -------------------------
//End Custom Code
//Close customers_viewcontent_alm_customers_BeforeShow @2-99C5ED0C
return $customers_viewcontent_alm_customers_BeforeShow;
}
