public static function addOrganization($obj_Organization) { $db = config::dbconfig(); $obj_retresult = new returnResult(); $obj_Organization->OrganizationId = DAL_manageOrganization::getLastOrganizationId() + 1; $sql = "INSERT INTO tbl_organization (OrganizationId,Name,Description,Address,telephone,fax,website,email,OrganizationTypeId,OrganizationSubTypeId) \n\t\tVALUES (" . common::noSqlInject($obj_Organization->OrganizationId) . "," . "'" . common::noSqlInject($obj_Organization->Name) . "'" . "," . "'" . common::noSqlInject($obj_Organization->Description) . "'" . "," . "'" . common::noSqlInject($obj_Organization->Address) . "'" . "," . "'" . common::noSqlInject($obj_Organization->telephone) . "'" . "," . "'" . common::noSqlInject($obj_Organization->fax) . "'" . "," . "'" . common::noSqlInject($obj_Organization->website) . "'" . "," . "'" . common::noSqlInject($obj_Organization->email) . "'" . "," . common::noSqlInject($obj_Organization->OrganizationTypeId) . "," . common::noSqlInject($obj_Organization->OrganizationSubTypeId) . ");"; $rs = mysql_query($sql); if (mysql_affected_rows() > 0) { $obj_retresult->type = 1; $obj_retresult->msg = "success"; $obj_retresult->data = $obj_Organization; } else { $obj_retresult->type = 0; $obj_retresult->msg = "failed"; } return $obj_retresult; }
public static function isChildOrganization($OrganizationId, $ChildOrganizationId) { $ischild = false; $obj_retResult = DAL_manageOrganization::getOrganizationListByOrganizationId($ChildOrganizationId); //get child node if ($obj_retResult->type == 1) { $arr_OrganizationList = $obj_retResult->data; $obj_Organization = $arr_OrganizationList[0]; $arrParentIds = explode(",", $obj_Organization->Url); foreach ($arrParentIds as $OrganizationParentId) { if ($OrganizationParentId == $OrganizationId) { $ischild = true; } } } return $ischild; }
function updateOrganization($sessionkey, $appcode, $Organizationdata) { $main_result = "<VPROFILERESULT>"; $main_result .= "<AUTHSTATUS>0</AUTHSTATUS>"; $userId = ValidateSession($sessionkey, $appcode); if ($userId > -1) { $main_result = "<AUTHSTATUS>1</AUTHSTATUS>"; $obj_Organization = new Organization(); foreach ($Userdata["[UPPERTEMPLATENAME"] as $key => $child) { switch ($key) { case "ORGANIZATIONID": $obj_Organization->OrganizationId = $child; break; case "NAME": $obj_Organization->Name = $child; break; case "DESCRIPTION": $obj_Organization->Description = $child; break; case "ADDRESS": $obj_Organization->Address = $child; break; case "TELEPHONE": $obj_Organization->telephone = $child; break; case "FAX": $obj_Organization->fax = $child; break; case "WEBSITE": $obj_Organization->website = $child; break; case "EMAIL": $obj_Organization->email = $child; break; case "ORGANIZATIONTYPEID": $obj_Organization->OrganizationTypeId = $child; break; case "ORGANIZATIONSUBTYPEID": $obj_Organization->OrganizationSubTypeId = $child; break; } } $obj_retResult_Organization = DAL_manageOrganization::updateOrganization($obj_Organization); if ($obj_retResult_Organization->type == 1) { $main_result .= "<RESULTSTATUS>1</RESULTSTATUS>"; $main_result .= getOrganizationXml($obj_retResult_Organization->data); } else { $main_result .= "<RESULTSTATUS>0</RESULTSTATUS>"; } } $main_result .= "</VPROFILERESULT>"; return $main_result; }