FM / program

/home/wespack/public_html/admin/program/

/home/wespack/public_html/admin/program

Name	Size	Mode	Actions
css/	-	0755	rm
images/	-	0755	rm
js/	-	0755	rm
upload/	-	0755	rm
_notes/	-	0755	rm
.htaccess	198	0644	edit dl rm
capwes.php	15580	0644	edit dl rm
category.php	14202	0644	edit dl rm
chartjs.html	37827	0644	edit dl rm
company.php	17038	0644	edit dl rm
create-folder.php	1101	0644	edit dl rm
currency.php	3766	0644	edit dl rm
error_log	40249889	0644	edit dl rm
fb-callback.php	2399	0644	edit dl rm
fb-delete-post.php	1956	0644	edit dl rm
fb-post-update.php	9649	0644	edit dl rm
fb_config.php	382	0644	edit dl rm
fb_login.php	1510	0644	edit dl rm
folder.php	17240	0644	edit dl rm
footer.php	25663	0644	edit dl rm
footer_24092017.php	24005	0644	edit dl rm
forgot-password.php	3501	0644	edit dl rm
graph1.php	4652	0644	edit dl rm
graph2.php	4862	0644	edit dl rm
graph3.php	4863	0644	edit dl rm
graph4.php	4938	0644	edit dl rm
graph5.php	4938	0644	edit dl rm
graph6.php	4945	0644	edit dl rm
graphapps.php	2617	0644	edit dl rm
header.php	2657	0644	edit dl rm
image-list.php	7698	0644	edit dl rm
index.php	9981	0644	edit dl rm
index27092017.php	17186	0644	edit dl rm
index_24092017.php	16566	0644	edit dl rm
index_ori.php	9981	0644	edit dl rm
insert-ajax.php	1622	0644	edit dl rm
invoice-details.php	10242	0644	edit dl rm
invoice-folder.php	8602	0644	edit dl rm
invoice-list.php	8262	0644	edit dl rm
login.php	2048	0644	edit dl rm
menu.php	9474	0644	edit dl rm
m_group.php	8791	0644	edit dl rm
m_group_p.php	5567	0644	edit dl rm
m_group_u.php	5843	0644	edit dl rm
m_profile.php	11289	0644	edit dl rm
m_user.php	10178	0644	edit dl rm
m_user_app.php	6062	0644	edit dl rm
original_file.php	4581	0644	edit dl rm
product-update.php	9194	0644	edit dl rm
product-update29092017.php	7940	0644	edit dl rm
profile.php	8754	0644	edit dl rm
project.php	15265	0644	edit dl rm
sales-tracking.php	11350	0644	edit dl rm
setup.php	20151	0644	edit dl rm
survey_report.php	4595	0644	edit dl rm
tritex.php	15467	0644	edit dl rm
type.php	10274	0644	edit dl rm
update-file.php	16960	0644	edit dl rm
update.php	3105	0644	edit dl rm
upload-05102017.php	7111	0644	edit dl rm
upload-ajax.php	946	0644	edit dl rm
upload-image.php	24332	0644	edit dl rm
upload-inv-file.php	1520	0644	edit dl rm
upload-invoice-push.php	2036	0644	edit dl rm
upload-invoice-pushios.php	2032	0644	edit dl rm
upload-invoice.php	14096	0644	edit dl rm
upload-ori.php	4571	0644	edit dl rm
upload-products-29092017.php	37037	0644	edit dl rm
upload-products.php	41210	0644	edit dl rm
upload-to-fb-batch.php	4674	0644	edit dl rm
upload-to-fb.php	2169	0644	edit dl rm
upload.php	11459	0644	edit dl rm
upload09102017.php	10089	0644	edit dl rm
upload29092017.php	6781	0644	edit dl rm
user.php	21183	0644	edit dl rm
visitor2.php	2149	0644	edit dl rm
visitor3.php	2149	0644	edit dl rm
visitor4.php	1923	0644	edit dl rm
visitors.php	2133	0644	edit dl rm
wespack.php	15482	0644	edit dl rm

Edit: /home/wespack/public_html/admin/program/index.php (9981B)

<?PHP include "header.php";?>
<?PHP include "menu.php";?>
  
        <div class="right_col" role="main">
        
         <?PHP if($_SESSION['access_level']=="1") // normal user only view their own files 
						{?>
          
          <div class="row tile_count">
            <div class="col-md-2 col-sm-4 col-xs-6 tile_stats_count">
              <span class="count_top"><i class="fa fa-user"></i> Total Users</span>
              <div class="count">
              <?PHP
              $query_c_user="SELECT * FROM user";
			  $run_query_c_user=mysqli_query($con,$query_c_user);
			  echo $count_c_user=mysqli_num_rows($run_query_c_user);
			  ?>
              </div>
              
            </div>
           
            <div class="col-md-2 col-sm-4 col-xs-6 tile_stats_count">
              <span class="count_top"><i class="fa fa-user"></i> Total Projects</span>
              <div class="count green"><?PHP 
			   $query_c_user2="SELECT * FROM project";
			  $run_query_c_user2=mysqli_query($con,$query_c_user2);
			  echo $count_c_user2=mysqli_num_rows($run_query_c_user2);
			  ?></div>
              
            </div>
           
            
             <div class="col-md-2 col-sm-4 col-xs-6 tile_stats_count">
              <span class="count_top"><i class="fa fa-clock-o"></i> Total Active Projects</span>
              <div class="count">
              <?PHP 
			   $query_c_user4="SELECT * FROM project WHERE status='1'";
			  $run_query_c_user4=mysqli_query($con,$query_c_user4);
			  echo $count_c_user4=mysqli_num_rows($run_query_c_user4);
			  ?>
              </div>
              
            </div>
            
             <div class="col-md-2 col-sm-4 col-xs-6 tile_stats_count">
              <span class="count_top"><i class="fa fa-clock-o"></i> Total Company</span>
              <div class="count">
              <?PHP 
			   $query_c_user5="SELECT * FROM company";
			  $run_query_c_user5=mysqli_query($con,$query_c_user5);
			  echo $count_c_user5=mysqli_num_rows($run_query_c_user5);
			  ?>
              </div>
              
            </div>
           
           
          </div>
          
          <?PHP } ?>

<div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
              <div class="dashboard_graph">
                <div class="panel-heading">
                           <form role="form" method="post" enctype="multipart/form-data" action="index.php">
                             <div class="form-group">
                             
                                    <?PHP
									if(isset($_POST["project"]))
									{
										$r_project=$_POST['project'];
									}
									else{$r_project="0";}
									
									if($_SESSION['access_level']=="1"){ // DROPDOWN FOR ADMIN ?>
                                    <select class="form-control" name="project" onchange='this.form.submit()'>
                                        <option value="0">View Project</option>
                                        <option value="All" <?PHP if($r_project=="All"){echo "SELECTED";}else{}?>>All Project</option>
                                        <?PHP 
										$query_project="SELECT * FROM project WHERE status='1' ORDER BY project_id DESC";
										$run_query_project=mysqli_query($con,$query_project);
										$cp="1";
										while($fetch_project=mysqli_fetch_array($run_query_project))
										{
											$project_id0=$fetch_project['project_id'];
											$project_name=$fetch_project['project_name'];
										
										?>
                                        <option value="<?PHP echo $project_id0; ?>" <?PHP if($r_project==$project_id0){echo "SELECTED";}else{}?>><?PHP echo $project_name;?></option>
                                        <?PHP } ?>
                                    </select>
                                   
                                    <?PHP } else { //for normal user ?>
                                    
                                    
                                    <select class="form-control" name="project" onchange='this.form.submit()'>
                                        <option value="0">View Project</option>
                                      
                                        <?PHP 
										$query_project="SELECT * FROM setting WHERE user_id='".$_SESSION['user_id']."'  GROUP BY project_id ORDER BY project_id DESC";
										$run_query_project=mysqli_query($con,$query_project);
										$cp="1";
										while($fetch_project=mysqli_fetch_array($run_query_project))
										{
											$project_id0=$fetch_project['project_id'];
											
											$query_project="SELECT * FROM project WHERE project_id='$project_id0'";
											$run_query_project=mysqli_query($con,$query_project);
											$fetch_project=mysqli_fetch_array($run_query_project);
											
											$project_id0=$fetch_project['project_id'];
											$project_name=$fetch_project['project_name'];
										
										?>
                                        <option value="<?PHP echo $project_id0;?>" <?PHP if($r_project==$project_id0){echo "SELECTED";}else{}?>><?PHP echo $project_name;?></option>
                                        <?PHP } ?>
                                    </select>
                                     
                                     <?PHP } ?>
                                    
                             </div>
                           </form>
                        </div>
                        
                        
                       <table id="datatable" class="table table-striped table-bordered">
                       <thead>
                        <tr>
                          <th>Bil</th>
                          <th>File Title</th>
                          <th>File Remarks</th>
                          <th>Created</th>
                          <th>Action</th>
                         
                        </tr>
                      </thead>

<tbody>
                      
                      <?PHP

if(isset($_POST["project"])) //project selected
						{
							
							    if($_POST["project"]=="All")
							{ //all project 
							
								if($_SESSION['access_level']=="1")//admin view all
								{
									$query_property="SELECT * FROM img ORDER BY i_id DESC";
								}
									else //non admin view
									{
									$query_property="SELECT * FROM img WHERE user_id='".$_SESSION['user_id']."' OR user_id='1' ORDER BY i_id DESC";
									}
								
							
							
							}
							else //not all project
							{ 
								if($_SESSION['access_level']=="1")//admin view all
								{$query_property="SELECT * FROM img WHERE project_id='".$_POST['project']."' ORDER BY i_id DESC";} 
								else { 
								$query_property="SELECT * FROM img WHERE project_id='".$_POST['project']."' AND user_id='".$_SESSION['user_id']."' OR user_id='1' ORDER BY i_id DESC";}
							}
						}
						else // project not selected
						{
							if($_SESSION['access_level']=="1"){
							$query_property="SELECT * FROM img WHERE user_id='".$_SESSION['user_id']."' ORDER BY i_id DESC";
							}else
							{$query_property="SELECT * FROM img WHERE i_id='9999999999999999999'";}
						}
							
						
						
						$count="1";
						$run_query_property=mysqli_query($con,$query_property);
					
						while($fetch_property=mysqli_fetch_array($run_query_property))
						{
							$i_id=$fetch_property['i_id'];
							$project_id=$fetch_property['project_id'];
							$user_id=$fetch_property['user_id'];
							$img_title=$fetch_property['image_title'];
							$img_remarks=$fetch_property['image_remarks'];
							$img_path=$fetch_property['img_path'];
							$created=$fetch_property['created'];
							$status=$fetch_property['status'];
							
							//query project name
							$query_project2="SELECT * FROM project WHERE project_id='$project_id0'";
							$run_query_project2=mysqli_query($con,$query_project2);
							$fetch_project2=mysqli_fetch_array($run_query_project2);
							
							$project_id2=$fetch_project2['project_id'];
							$project_name2=$fetch_project2['project_name'];
							
							
							//query user details
							$query_ad="SELECT * FROM user WHERE user_id='$user_id'";
							$run_query_ad=mysqli_query($con,$query_ad);
							$fetch_ad=mysqli_fetch_array($run_query_ad);
							
							$first_name=$fetch_ad['first_name'];
							$last_name=$fetch_ad['last_name'];
							$email=$fetch_ad['email'];
							
						
							
						?>
                        <tr>
                          <td><?PHP echo $count;?></td>
                          <td><?PHP echo $img_title;?></td>
                          <td><?PHP echo $img_remarks;?></td>
                          <td><?PHP 
						  echo $first_name." ".$last_name;
						  echo "<br>";
						  echo(date("d-M-Y",$created));?></td>
                          <td>
                          <a href="<?PHP echo $img_path;?>" target="_blank" title="Download">
                          <i class="fa fa-download" aria-hidden="true"></i>
                          </a>
                          </td>
                         
                        </tr>
                        <?PHP $count++; } ?>
                       
                      </tbody>
                    </table>
              </div>
              </div>

<?PHP include "footer.php";?>

Total Users

Total Projects

Total Active Projects

Total Company

Bil	File Title	File Remarks	Created	Action
			"; echo(date("d-M-Y",$created));?>