0){
// $sq112a="SELECT * FROM $table_name86 Where file_match_id ='$survey_id'";
// $result222 = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
//while ($row122 = mysqli_fetch_array($result222)) {
//$foldtype= $row122['foldtype'];
//}
//}
$sq112a="SELECT * FROM $table_nameApp WHERE status >0 ";
$result222 = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
while ($row1 = mysqli_fetch_array($result222)) {
$type_id= $row1['survey_id'];
$Cname= stripslashes($row1['name']);
$Cfoldtype[$type_id]="$type_id - $Cname";
$foldtype_list .="";
$bob101="$survey_id - $Cname";
}
$display_status .="";
$display_statusPar .="";
$display_statusInt .="";
//$display_listCGL .="";
$sq112ab="SELECT * FROM $table_name362";
$result112ab = @mysqli_query($connection,$sq112ab) or die(mysqli_error($connection));
while ($row112ab = mysqli_fetch_array($result112ab)) {
$group_id1= $row112ab['customer_group_id'];
$group_name= $row112ab['name'];
$FCgroup[$group_id1]= $group_name;
$FCgroup[0]="All";
$FCgroup[-1]="None";
$display_listCGL .= "";
}
$sq112ab="SELECT * FROM $table_name36 ORDER BY lastname ASC ";
$result112ab = @mysqli_query($connection,$sq112ab) or die(mysqli_error($connection));
while ($row112ab = mysqli_fetch_array($result112ab)) {
$leader_id1= $row112ab['customer_id'];
$first_id= $row112ab['firstname'];
$last_id= $row112ab['lastname'];
$ad1=$row112ab['address_id'];
$sql361 ="SELECT * FROM $table_name40 WHERE address_id = '$Acompany_id' ";
$result2261 = @mysqli_query($connection,$sql361) or die(mysqli_error($connection));
$row161 =mysqli_fetch_array($result2261,MYSQLI_ASSOC);
if ($Acompany_id == $row161['address_id'])
{
$company= stripslashes( $row161['company']);
}
$display_listCL .= "";
$FCL[$leader_id1]= "$first_id $last_id - $company";
$FCL[0]="All";
$FCL[-1]="None";
}
$sq112ab="SELECT * FROM $table_name85 where status >0 ORDER BY name ASC ";
$result112ab = @mysqli_query($connection,$sq112ab) or die(mysqli_error($connection));
while ($row112ab = mysqli_fetch_array($result112ab)) {
$group_id1= $row112ab['survey_id'];
$group_name= $row112ab['name'];
$display_listGL .= "";
$FGL[$group_id1]= $group_name;
$FGL[0]="All";
$FGL[-1]="None";
}
$sq112ab="SELECT * FROM $table_name49 where status>0 AND user_group_id >1 AND user_id>4 ORDER BY lastname ASC";
$result112ab = @mysqli_query($connection,$sq112ab) or die(mysqli_error($connection));
while ($row112ab = mysqli_fetch_array($result112ab)) {
$user_id1= $row112ab['user_id'];
$first_id= $row112ab['firstname'];
$last_id= $row112ab['lastname'];
$display_listU .= "";
$FU[$user_id1]= "$first_id $last_id";
$FU[0]="All";
$FU[-1]="None";
}
$sq112ab="SELECT * FROM $table_name49a where user_group_id >1 ORDER BY name ASC";
$result112ab = @mysqli_query($connection,$sq112ab) or die(mysqli_error($connection));
while ($row112ab = mysqli_fetch_array($result112ab)) {
$user_group_id1= $row112ab['user_group_id'];
$user_group2= $row112ab['name'];
$display_listUG .= "";
$FUG[$user_group_id1]= $user_group2;
$FUG[0]="All";
$FUG[-1]="None";
}
if ($lookDF==0 or $lookDF==$blink) {
$sq112aaD ="SELECT MAX(file_match_id) FROM $table_name86 ";
$result333DF = @mysqli_query($connection,$sq112aaD) or die(mysqli_error($connection));
while ($row1DF = mysqli_fetch_array($result333DF)) {
$lookMax=$row1DF['MAX(file_match_id)'];
$lookDF=$lookMax+1;
$pop=0;
$ptop=1;
}
}
$folder_id=$lookDF;
if($gbad==100){
$pop=1;
}
if ($pop ==0){
$saver="Save This Information";
//
$display_foldCurrent ="";
}else{
$saver="Update This Information";
$saver1="Add This Permission";
$saver2="Update This Permission";
}
$sq112aaD ="SELECT * FROM $table_nameApp Where survey_id ='$survey_id' ";
//$sq112aaD ="SELECT * FROM $table_name86 Where survey_id ='$survey_id' ";
$result333D = @mysqli_query($connection,$sq112aaD) or die(mysqli_error($connection));
$num33 = mysqli_num_rows($result333D);
while ($row1D = mysqli_fetch_array($result333D)) {
$survey_id2= $row1D['survey_id'];
$Cname= stripslashes($row1D['name']);
$Ccomments= stripslashes($row1D['comment']);
}
//$sq112aaD ="SELECT * FROM $table_nameApp Where survey_id ='$survey_id' ";
$sq112aaD ="SELECT * FROM $table_name86 Where file_match_id ='$lookDF' ";
if ($gbad==100){
$sq112aaD ="SELECT * FROM $table_name86 ";
}
$result333D = @mysqli_query($connection,$sq112aaD) or die(mysqli_error($connection));
$num33 = mysqli_num_rows($result333D);
If ($num33<1) {
$display_entry .="
|
|
$folder_id |
$Ccreate_date |
|
|
|
|
|
|
$Cstatus2[$Cstatus]
|
";
}
while ($row1D = mysqli_fetch_array($result333D)) {
$Ccparent= $row1D['Parent_F'];
$Cstatus= $row1D['status'];
if ($gbad==100){
$lookDF=$row1D['file_match_id'];
$foldtype=$row1D['foldtype'];
$folder_id=$lookDF;
$bob101=$Cfoldtype[$foldtype];
}
//$foldtype= $row1D['$foldtype'];
$Ccreate_date= stripslashes($row1D['create_date']);
$Ccomments= stripslashes($row1D['comment']);
$Cparent[0]=" Regular";
$Cparent[1]=" Parent";
$Cparent[2]=" Child Folder";
$Cparent[3]=" Child-Child Folder";
$Cstatus2[1]="Enable";
$Cstatus2[2]="Disabled";
$sq112aaDF ="SELECT * FROM $table_name86a Where file_match_id ='$lookDF' ";
$result333DF = @mysqli_query($connection,$sq112aaDF) or die(mysqli_error($connection));
$num33 = mysqli_num_rows($result333DF);
while ($row1DF = mysqli_fetch_array($result333DF)) {
$FFid= $row1DF['file_matcher_id'];
$FFgroup= $row1DF['group_id'];
$FFcustgroup= $row1DF['customer_group_id'];
$FFcust= $row1DF['customer_id'];
$FFuser= $row1DF['user_id'];
$FFusergroup= $row1DF['user_group_id'];
$FFCstatus= $row1DF['status'];
$display_groups_Perm="";
$display_groups_Perm .="
";
$display_groups_Perm4="";
$display_groups_Perm4 .="
";
$display_groups_Perm6="";
$display_groups_Perm6 .="
";
$display_groups_Perm8="";
$display_groups_Perm8 .="
";
$display_groups_Perm10="";
$display_groups_Perm10 .="
";
}
if ($Ccreate_date==$blink){
$Ccreate_date="No records created for this folder
";
}
// formcheck$ag_id
$display_entry .="
|
|
$folder_id |
$Ccreate_date |
|
Update:
$display_groups_Perm
|
Update:
$display_groups_Perm4
|
Update:
$display_groups_Perm6
|
Update:
$display_groups_Perm8
|
Update:
$display_groups_Perm10
|
$Cstatus2[$Cstatus]
|
";
//$edit_block .="Ability to Edit $Record: Status $Cstatus2D[$EditQD]
// Ability to Edit Answers: Status $Cstatus2D[$EditAD]
";
}
$display_blockV .="
Add Stakeholder: Customer, Leader, Support Person, etc.
Add Internal System User, etc.
$noteB