Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('memory_limit', '256M');
- set_time_limit(1000000);
- require_once("../include/server.php");
- require_once("../include/function.php");
- require_once("rights_function.php");
- $vUserName = stripslashes(trim($_REQUEST["txtUser"]));
- $vPassword = stripslashes(trim($_REQUEST["txtPass"]));
- $returnFinalString = "";
- $member_id = 0;
- if($vUserName!="" and $vPassword!="")
- {
- //================= Member Details =====================//
- $member_query = "select * from member_mast
- where username = '".addslashes($vUserName)."' and password = '".addslashes($vPassword)."'
- and is_deleted_flg=0 and is_profile=0";
- $member_res = mysql_query($member_query);
- if(mysql_num_rows($member_res)>0)
- {
- $mem_row = mysql_fetch_array($member_res);
- $member_role = $mem_row['member_role'];
- $member_id = $mem_row['user_id'];
- $childUserString = recursion_user($member_id);
- $childUserArray = explode(",",$childUserString);
- //======================================================//
- #==================== Get Company ID =============================
- //======= Find Company =========//
- $CompanyIdArray = array();
- $CompanyNameArray = array();
- $sqlCompany = " SELECT CM.company_id, CM.company_name
- FROM company_mast CM ";
- if($member_role=="Administrator")
- {
- $sqlCompany .= " LEFT JOIN admin_company AC ON (AC.company_id=CM.company_id)
- LEFT JOIN member_mast MM ON (MM.company_id=CM.company_id) ";
- }
- if($member_role=="Client" || $member_role=="Administrator")
- {
- $sqlCompany .= " LEFT JOIN project_mast PM ON (PM.company_id=CM.company_id)
- LEFT JOIN mem_pro_comp_right MPCR ON (MPCR.project_id=PM.project_id)";
- }
- $sqlCompany .= " WHERE (CM.user_id IN (".$childUserString.")";
- if($member_role=="Client" || $member_role=="Administrator")
- {
- $sqlCompany .= " OR MPCR.company_id='".$member_id."'";
- }
- if($member_role=="Administrator")
- {
- $sqlCompany .= " OR MM.user_id='".$member_id."' OR AC.member_id = '".$member_id."' ";
- }
- $sqlCompany .= " ) AND CM.is_deleted_flg=0
- GROUP BY CM.company_id
- ORDER BY CM.company_name ASC";
- $queryCompany = mysql_query($sqlCompany);
- if(mysql_num_rows($queryCompany)>0)
- {
- while($rowCompany=mysql_fetch_array($queryCompany))
- {
- $CompanyIdArray[] = $rowCompany["company_id"];
- $CompanyNameArray[] = htmlentities(stripslashes($rowCompany["company_name"]));
- }
- }
- //echo $sqlCompany."<br>";
- //echo $member_role."<br>";
- //======= Find Project =========//
- $ProjectIdArray = array();
- $ProjectNameArray = array();
- $sqlProject = " SELECT PM.company_id, PM.project_id, PM.project_title
- FROM project_mast PM
- LEFT JOIN company_mast CM ON (PM.company_id=CM.company_id)";
- if($member_role=="Administrator")
- {
- $sqlProject .= " LEFT JOIN admin_company AC ON (AC.company_id=CM.company_id)
- LEFT JOIN member_mast MM ON (MM.company_id=CM.company_id)";
- }
- if($member_role=="Client" || $member_role=="Administrator")
- {
- $sqlProject .= " LEFT JOIN mem_pro_comp_right MPCR ON (MPCR.project_id=PM.project_id)";
- }
- $sqlProject .= " WHERE (CM.user_id IN (".$childUserString.") ";
- if($member_role=="Administrator")
- {
- $sqlProject .= " OR AC.member_id = '".$member_id."' OR MM.user_id='".$member_id."' ";
- }
- if($member_role=="Client" || $member_role=="Administrator")
- {
- $sqlProject .= " OR MPCR.company_id='".$member_id."' ";
- }
- $sqlProject .= " ) AND PM.is_deleted_flg=0
- GROUP BY PM.project_id
- ORDER BY CM.company_name, CM.company_id, PM.project_title, PM.project_id ";
- $queryProject = mysql_query($sqlProject);
- if(mysql_num_rows($queryProject)>0)
- {
- while($rowProject=mysql_fetch_array($queryProject))
- {
- $company_id = $rowProject["company_id"];
- $ProjectIdArray[$company_id][] = $rowProject["project_id"];
- $ProjectNameArray[$company_id][]= htmlentities(stripslashes($rowProject["project_title"]));
- }
- }
- //echo $sqlProject;
- //======= Find Component =========//
- $ComponentIdArray = array();
- $ComponentNameArray = array();
- $ComponentPrimaryFieldArray = array();
- $PrimaryFieldIdArray = array();
- $PrimaryFieldNameArray = array();
- $FileUploadFieldIdArray = array();
- $FileUploadFieldNameArray = array();
- $sqlComponent = " SELECT CMP.company_id, CMP.project_id, CMP.component_id, CMP.component_name, CMP.table_name, CMP.user_id
- FROM component_mast CMP
- LEFT JOIN company_mast CM ON (CMP.company_id=CM.company_id)";
- if($member_role=="Administrator")
- {
- $sqlComponent .= " LEFT JOIN admin_company AC ON (AC.company_id=CM.company_id) ";
- }
- if($member_role=="Client" || $member_role=="Administrator")
- {
- $sqlComponent .= " LEFT JOIN mem_pro_comp_right MPCR ON (MPCR.component_id=CMP.component_id)";
- }
- $sqlComponent .= " WHERE (CM.user_id IN (".$childUserString.")";
- if($member_role=="Administrator")
- {
- $sqlComponent .= " OR AC.member_id = '".$member_id."'";
- }
- if($member_role=="Client" || $member_role=="Administrator")
- {
- $sqlComponent .= " OR MPCR.company_id='".$member_id."'";
- }
- $sqlComponent .= " ) AND CMP.is_deleted_flg=0 AND CMP.field_create_from <> 'information'
- GROUP BY CMP.component_id
- ORDER BY CM.company_name, CM.company_id, CMP.component_name, CMP.component_id
- ";
- $queryComponent = mysql_query($sqlComponent);
- if(mysql_num_rows($queryComponent)>0)
- {
- while($rowComponent=mysql_fetch_array($queryComponent))
- {
- $project_id = $rowComponent["project_id"];
- $tmpComponentId = $rowComponent["component_id"]; // Component Id
- $tmpComponentUserId = $rowComponent["user_id"]; // Component Creator
- $tmpComponentName = htmlentities(stripslashes($rowComponent["component_name"]));
- $tmpComponentTable = htmlentities(stripslashes($rowComponent["table_name"]));
- if(getComponentTableExist($tmpComponentTable)==1)
- {
- // Get Primary Key of Component
- $primaryKeyArray = getPrimaryAndSortOrderKeyOfComponent($tmpComponentId);
- $primaryColumnUniqueId = $primaryKeyArray["column_unique_id"];
- $primaryDisplayName = $primaryKeyArray["display_name"];
- $sortOrderColumnUniqueId= $primaryKeyArray["sortorder_unique_id"];
- // Check user's Rights
- if(in_array($tmpComponentUserId,$childUserArray)){
- $mainAccessFlg = "Administrative";
- }else{
- $mainAccessFlg = "Normal";
- }
- $getRowDataArray = getRowDataOfComponent($tmpComponentId, $member_id, $tmpComponentTable, $mainAccessFlg, $primaryColumnUniqueId, $sortOrderColumnUniqueId);
- $getColumnDataArray = getColumnDataOfComponent($tmpComponentId, $member_id, $mainAccessFlg);
- if(count($getRowDataArray)>0)
- {
- // Store component Id, Name, PrimaryField Name
- $ComponentIdArray[$project_id][] = $tmpComponentId;
- $ComponentNameArray[$project_id][] = $tmpComponentName;
- $ComponentPrimaryFieldArray[$project_id][] = $primaryDisplayName;
- for($z=0;$z<count($getRowDataArray);$z++)
- {
- $primaryFieldId = $getRowDataArray[$z]["id"];
- $PrimaryFieldIdArray[$tmpComponentId][] = $getRowDataArray[$z]["id"];
- $PrimaryFieldNameArray[$tmpComponentId][] = $getRowDataArray[$z]["column_data"];
- }
- for($y=0;$y<count($getColumnDataArray);$y++)
- {
- $FileUploadFieldIdArray[$tmpComponentId][] = $getColumnDataArray[$y]["id"];
- $FileUploadFieldNameArray[$tmpComponentId][] = $getColumnDataArray[$y]["column_data"];
- }
- }
- //echo $tmpComponentId."==>".$primaryColumnUniqueId."==>".$primaryDisplayName."<br>";
- //print_r($FileUploadFieldIdArray);
- //echo "<br>";
- }
- }
- }
- //echo $sqlComponent;
- $total_company = count($CompanyIdArray);
- // ReGenerate Array of company, Project And Component
- $newCompanyIdArray = array();
- $newCompanyNameArray = array();
- $newProjectIdArray = array();
- $newProjectNameArray = array();
- $newComponentIdArray = array();
- $newComponentNameArray = array();
- $newComponentPrimaryFieldArray = array();
- $newPrimaryFieldIdArray = array();
- $newPrimaryFieldNameArray = array();
- $newFileUploadFieldIdArray = array();
- $newFileUploadFieldNameArray = array();
- if($member_role=="Client")
- {
- if($total_company>0)
- {
- for($i=0;$i<$total_company;$i++)
- {
- $company_id = $CompanyIdArray[$i];
- $total_project = count($ProjectIdArray[$company_id]);
- if($total_project>0)
- {
- $cntCom=0;
- for($j=0;$j<$total_project;$j++)
- {
- $project_id = $ProjectIdArray[$company_id][$j];
- $total_component = count($ComponentIdArray[$project_id]);
- if($total_component>0)
- {
- if($cntCom==0)
- {
- $newCompanyIdArray[] = $company_id;
- $newCompanyNameArray[] = $CompanyNameArray[$i];
- $cntCom=1;
- }
- $newProjectIdArray[$company_id][] = $project_id;
- $newProjectNameArray[$company_id][] = $ProjectNameArray[$company_id][$j];
- for($k=0;$k<$total_component;$k++)
- {
- $component_id = $ComponentIdArray[$project_id][$k];
- $total_primaryField = count($PrimaryFieldIdArray[$component_id]);
- if($total_primaryField>0)
- {
- $newComponentIdArray[$project_id][] = $ComponentIdArray[$project_id][$k];
- $newComponentNameArray[$project_id][] = $ComponentNameArray[$project_id][$k];
- $ComponentPrimaryFieldArray[$project_id][] = $ComponentPrimaryFieldArray[$project_id][$k];
- for($l=0;$l<$total_primaryField;$l++)
- {
- $primaryKeyFieldId = $PrimaryFieldIdArray[$component_id][$l];
- $newPrimaryFieldIdArray[$component_id][] = $primaryKeyFieldId;
- $newPrimaryFieldNameArray[$component_id][] = $PrimaryFieldNameArray[$component_id][$l];
- }
- $total_FileUploadFields = count($FileUploadFieldIdArray[$component_id]);
- for($m=0;$m<$total_FileUploadFields;$m++)
- {
- $newFileUploadFieldIdArray[$component_id][] = $FileUploadFieldIdArray[$component_id][$m];
- $newFileUploadFieldNameArray[$component_id][] = $FileUploadFieldNameArray[$component_id][$m];
- }
- }
- }
- }
- }
- }
- }
- }
- }
- else
- {
- $newCompanyIdArray = $CompanyIdArray;
- $newCompanyNameArray = $CompanyNameArray;
- $newProjectIdArray = $ProjectIdArray;
- $newProjectNameArray = $ProjectNameArray;
- $newComponentIdArray = $ComponentIdArray;
- $newComponentNameArray = $ComponentNameArray;
- $newComponentPrimaryFieldArray = $ComponentPrimaryFieldArray;
- $newPrimaryFieldIdArray = $PrimaryFieldIdArray;
- $newPrimaryFieldNameArray = $PrimaryFieldNameArray;
- $newFileUploadFieldIdArray = $FileUploadFieldIdArray;
- $newFileUploadFieldNameArray = $FileUploadFieldNameArray;
- }
- $newTotalCompany = count($newCompanyIdArray);
- // ========= Main Content Part ========= //
- if($newTotalCompany>0)
- {
- for($i=0;$i<$newTotalCompany;$i++)
- {
- $CompanyId = $newCompanyIdArray[$i];
- $CompanyName = $newCompanyNameArray[$i];
- $newTotalProject = count($newProjectIdArray[$CompanyId]);
- if($newTotalProject>0)
- {
- $returnFinalString .= "<dict>";
- $returnFinalString .= "<key>iId</key>";
- $returnFinalString .= "<string>".$CompanyId."</string>";
- $returnFinalString .= "<key>itemTitle</key>";
- $returnFinalString .= "<string>".$CompanyName."</string>";
- $returnFinalString .= "<key>itemChildren</key>";
- $returnFinalString .= "<array>";
- for($j=0;$j<$newTotalProject;$j++)
- {
- $ProjectId = $newProjectIdArray[$CompanyId][$j];
- $ProjectName = $newProjectNameArray[$CompanyId][$j];
- $newTotalComponent = count($newComponentIdArray[$ProjectId]);
- if($newTotalComponent>0)
- {
- $returnFinalString .= "<dict>";
- $returnFinalString .= "<key>iId</key>";
- $returnFinalString .= "<string>".$ProjectId."</string>";
- $returnFinalString .= "<key>itemTitle</key>";
- $returnFinalString .= "<string>".$ProjectName."</string>";
- $returnFinalString .= "<key>itemChildren</key>";
- $returnFinalString .= "<array>";
- for($k=0;$k<$newTotalComponent;$k++)
- {
- $ComponentId = $newComponentIdArray[$ProjectId][$k];
- $ComponentName = $newComponentNameArray[$ProjectId][$k];
- $ComponentPrimaryName = $newComponentPrimaryFieldArray[$ProjectId][$k];
- $newTotalPrimaryField = count($newPrimaryFieldIdArray[$ComponentId]);
- if($newTotalPrimaryField>0)
- {
- $returnFinalString .= "<dict>";
- $returnFinalString .= "<key>iId</key>";
- $returnFinalString .= "<string>".$ComponentId."</string>";
- $returnFinalString .= "<key>itemTitle</key>";
- $returnFinalString .= "<string>".$ComponentName."</string>";
- $returnFinalString .= "<key>iSubTitle</key>";
- $returnFinalString .= "<string>".$ComponentPrimaryName."</string>";
- $returnFinalString .= "<key>itemChildren</key>";
- $returnFinalString .= "<array>";
- for($l=0;$l<$newTotalPrimaryField;$l++)
- {
- $PrimaryFieldId = $newPrimaryFieldIdArray[$ComponentId][$l];
- $PrimaryFieldName = $newPrimaryFieldNameArray[$ComponentId][$l];
- $returnFinalString .= "<dict>";
- $returnFinalString .= "<key>iId</key>";
- $returnFinalString .= "<string>".$PrimaryFieldId."</string>";
- $returnFinalString .= "<key>itemTitle</key>";
- $returnFinalString .= "<string>".$PrimaryFieldName."</string>";
- $returnFinalString .= "</dict>";
- }
- $returnFinalString .= "</array>";
- $returnFinalString .= "<key>itemChildren1</key>";
- $returnFinalString .= "<array>";
- $newTotalFileUploadField = count($newFileUploadFieldIdArray[$ComponentId]);
- for($m=0;$m<$newTotalFileUploadField;$m++)
- {
- $FileUploadFieldId = $newFileUploadFieldIdArray[$ComponentId][$m];
- $FileUploadFieldName = $newFileUploadFieldNameArray[$ComponentId][$m];
- $returnFinalString .= "<dict>";
- $returnFinalString .= "<key>iId</key>";
- $returnFinalString .= "<string>".$FileUploadFieldId."</string>";
- $returnFinalString .= "<key>itemTitle</key>";
- $returnFinalString .= "<string>".$FileUploadFieldName."</string>";
- $returnFinalString .= "</dict>";
- }
- $returnFinalString .= "</array>";
- $returnFinalString .= "</dict>";
- }
- }
- $returnFinalString .= "</array>";
- $returnFinalString .= "</dict>";
- } // if($newTotalComponent>0)
- } // for($j=0;$j<$newTotalProject;$j++)
- $returnFinalString .= "</array>";
- $returnFinalString .= "</dict>";
- } // if($newTotalProject>0)
- }// for($i=0;$i<$newTotalCompany;$i++)
- } // if($newTotalCompany>0)
- // ========= Main Content Part End ========= //
- }// if(mysql_num_rows($member_res)>0)
- } // if($vUserName!="" and $vPassword!="")
- $ret_str = "<?xml version='1.0' encoding='UTF-8'?>";
- $ret_str .= "<!DOCTYPE plist PUBLIC '-//Apple//DTD PLIST 1.0//EN' 'http://www.apple.com/DTDs/PropertyList-1.0.dtd'>";
- $ret_str .= "<plist version='1.0'>";
- $ret_str .= "<dict>";
- $ret_str .= "<key>iId</key>";
- $ret_str .= "<string>".$member_id."</string>";
- $ret_str .= "<key>itemChildren</key>";
- $ret_str .= "<array>";
- $ret_str .= $returnFinalString;
- $ret_str .= "</array>";
- $ret_str .= "</dict>";
- $ret_str .= "</plist>";
- echo $ret_str;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement