";
$average1='N/A';
$median1='N/A';
$sumA='';
$bobv='';
$bobv1='';
$total1='';
$display_sec1="";
$display_sec2="";
$display_sec3="";
$display_sec4="";
$display_sec5="";
$display_sec6="";
$display_sec7="";
$display_sec8="";
$display_sec9="";
$display_sec10="";
$display_sec11="";
$display_sec12="";
$display_sec13="";
$display_sec14="";
$display_sec15="";
$display_sec16="";
$display_sec17="";
$display_sec18="";
$display_sec19="";
$display_sec20="";
$display_sec21="";
$display_sec22="";
$display_AI="";
$display_marketing1='';
$display_MIT='';
$display_agg_report_Cand='';
$display_orders1='';
$class_product1='';
$agent_id='';
$prog='';
$tok=$_GET['token'];
$prog1='';
$display_block34PP='';
$display_listP='';
$display_listG='';
$display_listCom='';
$display_listReportCom='';
$display_listReport3='';
$metric_rep_man='';;
$num1a11ap='';
$Sstatement='';
$TSurveyNums='';
$display_survey='';
$group_rep_Mang_Cand='';
$compare_rep_manage='';
$survey_report='';
$i='';
$group_rep3_compare_report='';
$prog="group/group.php";
$prog6000="survey_agg/survey.php";
$prog26000="group_report2/showreport.php";
$prog260001="compare_report/showreport.php";
$progRep="group_report/group.php";
$progRep2="group_report2/group.php";
$progRep3="compare_report/group.php";
$progRep4="survey_report/showreport.php";
$progMetric="metric_report/group.php";
$progCompare="compare/group.php";
$prog2="survey/survey.php";
$prog4="report/test_po2.php";
$prog5005="../../survey/control.php";
$prog995="../../upload/php/fold.php";
$prog996="../../upload/php/writer.php";
$prog5006="../../survey/control_group_admin.php";
$prog5007="../../survey/controlA_admin.php";
$prog5008="../../survey/contactApp222A.php";
$prog5009="class1/index-class.php";
$prog5019="CAP_Control/list.php";
$prog9091="GoAI/group.php";
$prog9090="metric/group.php";
$printQ="power/pdf3/documents/GoPDFprintQs.php";
$PO='';
$boom3='';
$boom2='';
$warnP='';
$sec_title2='';
$sec_title3='';
$sec_title4="";
$sec_title5="Last 5 OPEN Purchase Order";
$sec_title6="Forms";
$sec_title7='';
$sec_title8='';
$sec_title9='';
$sec_title10='';
$num1aa='';
$display_notices1='';
$list_formPR2='';
$list_formPR='';
$list_formPO2='';
$bod3='';
$boom='';
$nonp='000';
$money='';
$display_block44='';
$display_close='';
$display_listReport='';
$display_listReportM='';
$display_listReport2='';
$display_Surveylist='';
$boom2='';
$total_pr='';
$list_formWH2='';
$prog5="report/test_pur.php";
$num1PR2="";
$status2='';
$minNum='';
$group_rep2_report_metrics='';
// include("../forms/notify_id.php");
$instock = 7;
$backorder =9;
$outofstock =5;
$orders_backordered=27;
$blink="";
$quote1=$instock;
// $sql33 ="SELECT SUM(quantity)AS instock2 FROM $table_name54 WHERE stock_status_id = '$quote1' ";
$quote1=$backorder;
//$quote1=$outofstock;
//$quote1=2;
// $sql33 ="SELECT SUM(quantity)AS instock2 FROM .$table_name54 WHERE stock_status_id = '$quote1' ";
//Number of Ministries
$sql33 ="SELECT * FROM $table_name85 WHERE status > 0 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$minNum = mysql_num_rows($result33);
$sql33 ="SELECT * FROM $table_name36 WHERE store_id = 9 AND status > 0 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$minUserNum = mysql_num_rows($result33);
$sql33 ="SELECT * FROM $table_name36 WHERE store_id = 9 AND status > 0 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$minUserNum = mysql_num_rows($result33);
$sql33 ="SELECT * FROM $table_name36 WHERE store_id = 8 AND status > 0";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$minApUserNum = mysql_num_rows($result33);
$minApUserNum=$minApUserNum-2; //super User & Gayle
$sql33 ="SELECT * FROM $table_name36 WHERE status > 0 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$TminUserNum = mysql_num_rows($result33);
$TminUserNum=$TminUserNum-2;
$sql33 ="SELECT * FROM $table_name81 WHERE status > 0 Order by survey_id ";
require($vqmod->modCheck('admin/GoTool/dashboard/file2/all_survey.php'));
require($vqmod->modCheck('admin/GoTool/dashboard/file2/all_survey_specific.php'));
$display_notices1 .="
Purchase Requests in System:
PR's needing processing:-$num1a11ap
Purchase Orders:
";
// include("GoTool/forms/user_id.php");
$display_notices ="
Number of Web Users: $TminUserNum
Number of Services: $SurveyNums
Number of Forms Completed: $TSurveyNums
";
//First get logged
$logged_id=$hi2;
require($vqmod->modCheck('admin/GoTool/dashboard/file2/lists.php'));
$sql33 ="SELECT * FROM $table_name49 WHERE user_id ='$logged_id' ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$row22 =mysql_fetch_array($result33,MYSQL_ASSOC);
$log_email= $row22['email'];
$hi="$hi3
User ID: $hi2 - Group:$hi1
";
$hi4="";
$add_stakeholder='';
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%sale/customer%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/stakeholder_add.php'));
}
$add_groupT='';
$edit_groupT ='';
$leader_direct='';
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%GoTool/group%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/group_add.php'));
}
$hi4 .="
$add_stakeholder|
$add_groupT
|
$edit_groupT
|
$leader_direct
|
";
if ($NumCustom >0){
$display_sec1=" $Stakeholders & Group Management
";
}
///////Section 2 Product
$product_add='';
$category_add='';
$sec444='';
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%catalog/product%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/product_add.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%catalog/category%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
//$NumCustom=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/category_add.php'));
}
$sec444 .="
|
$product_add
|
$category_add
|
";
if ($NumCustom >0){
$display_sec2=" Product Management
";
}
////////////Display Form////
$survey_rev='';
$survey_add='';
$sec444='';
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%GoTool/survey%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/survey_add.php'));
}
$sec444 .="
";
if ($NumCustom >0){
$display_sec3=" Form / Assessment / Survey Management
";
}
///////Section 4 marketing
$market_inf='';
$market_banner='';
$market_email='';
$sec444='';
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%catalog/information%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/market_inf.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%design/banner%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom1=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/market_banner.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%sale/contact%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom2=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/market_email.php'));
}
$sec444 .="
|
$market_inf
|
$market_banner
|
$market_email |
";
if ($NumCustom >0 or $NumCustom1 >0 or $NumCustom2 >0){
$display_sec4=" Marketing Management
";
}
///////Section 5 GO AI
$go_add='';
$go_word_con='';
// $market_email='';
$sec444='';
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/testcare_table%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/go_add.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%GoTool/GOAI%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom1=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/go_word_con.php'));
}
$NumTT=0;
//$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%sale/contact%'";
//$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
//$NumTT = mysql_num_rows($result33T);
$NumCustom2=$NumTT;
//if ($NumTT>0){
// require($vqmod->modCheck('admin/GoTool/dashboard/file2/market_email.php'));
//}
$sec444 .="
";
if ($NumCustom >0 or $NumCustom1 >0 or $NumCustom2 >0){
$display_sec5=" GOAI Management
";
}
///////Section 6 Care Table
$capcare2_table2='';
$capcare3_table2='';
$capcare4_table2='';
$capcare_table2='';
$surveycare_table2='';
$metriccare_table2='';
// $market_email='';
$sec444='';
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/capcare2_table%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/capcare2_table.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/capcare3_table%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom1=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/capcare3_table.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/capcare4_table%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom2=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/capcare4_table.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/capcare_table%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom3=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/capcare_table.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/metriccare_table%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom4=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/metriccare_table.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/surveycare_table%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom5=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/surveycare_table.php'));
}
$NumTT=0;
//$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%sale/contact%'";
//$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
//$NumTT = mysql_num_rows($result33T);
$NumCustom6=$NumTT;
if ($NumTT>0){
// require($vqmod->modCheck('admin/GoTool/dashboard/file2/market_email.php'));
}
$sec444 .="
$capcare2_table2
$capcare3_table2
$capcare4_table2
$capcare_table2 $surveycare_table2
$metriccare_table2
";
if ($NumCustom >0 or $NumCustom1 >0 or $NumCustom2 >0 or $NumCustom3 >0 or $NumCustom4 >0 or $NumCustom5 >0 or $NumCustom >6 ){
$display_sec6=" CareTables Management
";
}
///////Section 7 Folder Table
$folder_group='';
$folder_group2='';
$folder_group3='';
// $capcare_table2='';
// $surveycare_table2='';
// $metriccare_table2='';
// $market_email='';
$sec444='';
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%GoTool/folder_group%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/folder_group.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%GoTool/folder_group2%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom1=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/folder_group2.php'));
}
$NumTT=0;
$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%GoTool/folder%'";
$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
$NumTT = mysql_num_rows($result33T);
$NumCustom2=$NumTT;
if ($NumTT>0){
require($vqmod->modCheck('admin/GoTool/dashboard/file2/folder_group3.php'));
}
$NumTT=0;
//$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/capcare_table%'";
//$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
//$NumTT = mysql_num_rows($result33T);
$NumCustom3=$NumTT;
if ($NumTT>0){
//require($vqmod->modCheck('admin/GoTool/dashboard/file2/capcare_table.php'));
}
$NumTT=0;
//$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/metriccare_table%'";
//$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
//$NumTT = mysql_num_rows($result33T);
$NumCustom4=$NumTT;
if ($NumTT>0){
// require($vqmod->modCheck('admin/GoTool/dashboard/file2/metriccare_table.php'));
}
$NumTT=0;
//$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%tool/surveycare_table%'";
//$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
//$NumTT = mysql_num_rows($result33T);
$NumCustom5=$NumTT;
if ($NumTT>0){
// require($vqmod->modCheck('admin/GoTool/dashboard/file2/surveycare_table.php'));
}
$NumTT=0;
//$sql33T ="SELECT * FROM $table_name49a WHERE user_group_id = '$hi1' AND permission Like '%sale/contact%'";
//$result33T = @mysql_query($sql33T,$connection) or die(mysql_error());
//$NumTT = mysql_num_rows($result33T);
$NumCustom6=$NumTT;
if ($NumTT>0){
// require($vqmod->modCheck('admin/GoTool/dashboard/file2/market_email.php'));
}
$sec444 .="
$folder_group
$folder_group2
$folder_group3
";
if ($NumCustom >0 or $NumCustom1 >0 or $NumCustom2 >0 or $NumCustom3 >0 or $NumCustom4 >0 or $NumCustom5 >0 or $NumCustom >6 ){
$display_sec7=" Folder Management
";
}
//////Display////////////
$heading_title="$company_admin";
$display_block_call55 ="
$logo99
$sec_title1
$display_sec1
$display_sec2
$display_sec3
$display_sec4
$display_sec5
$display_sec6
$display_sec7
$display_sec8
$display_sec9
$display_sec10
$display_sec11
$display_sec12
$display_sec13
$display_sec14
$display_sec15
$display_sec16
$display_sec17
$display_sec18
$display_sec19
$display_sec20
$display_sec21
";
$tabby.="";
$tabby="";
$tabby.="";
$display_sales0.="
$text_latest_10_orders
| $column_order |
$column_customer |
$column_status |
$column_date_added |
$column_total |
$column_action |
;"
?>