MAINHACK

Viewing / Editing File: show_project.php

<?php include 'header.php';?>
<style>
    
    .col-md-3,.col-md-2,.col-md-6{
        display:inline-block !important;
    }
</style>

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="row">
<div class="col-md-12">
<div class="card">
	<div class="card-header">
		<div class="card-title">Show Project</div>
	</div>
 	<form method="post" id="exampleValidation" data-toggle="validator" enctype="multipart/form-data" > 
<?php
$count=1;
$sr='project';
$stmt =$show->readwithdata($sr,'project_id',$_REQUEST['id']);
$num = $stmt->rowCount();
    if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];  
      
      //echo date('d-m-Y',strtotime($row['date']));
     ?>
		<div class="card-body">
		    	<div class="form-group form-show-validation row">
				
				<div class="col-lg-3 col-md-12 col-sm-12" id="direct" style="display:">

<label>Project Type  <span class="required-label">*</span></label>
          		<input type="text" name="project_type" value="<?=$row['project_type']?>" class="form-control" id="fli" placeholder="Search for all Project Type" readonly="">

<label>Choose Customer   <span class="required-label">*</span></label>
            <input type="text" name="customer_name" value="<?=$row['name']?>" class="form-control" id="fli1" placeholder="Search for all Customer" readonly="">
            <input type="hidden" name="customer_id" id="client_id" value="<?=$row['customer_id']?>">
            <input type="hidden" name="customer_phone" id="phone" value="<?=$row['customer_phone']?>">

<div id="display1"></div>	   
     
				</div>	
			</div>
			
		    	<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Project Name <span class="required-label">*</span></label>
				<div class="col-lg-5 col-md-12 col-sm-12">
            	    <input type="text" name="name" value="<?=$row['name']?>" readonly class="form-control" placeholder="Project Name">
				</div>
				   	<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Project Title <span class="required-label">*</span></label>
				<div class="col-lg-5 col-md-12 col-sm-12">
            	    <input type="text" name="title"  value="<?=$row['title']?>" readonly class="form-control" placeholder="Project Title " required>
				</div>
			</div>
		    	<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Renewal Date <span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="date" value="<?=date('Y-m-d',strtotime($row['renewal_date']))?>" readonly name="renewal_date" class="form-control">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Project Date <span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="date" value="<?=date('Y-m-d',strtotime($row['date']))?>" readonly name="date" class="form-control">
				</div>
			</div>
		<div class="form-group form-show-validation row">
				 
			 	<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Proposed Cost <span class="required-label">*</span></label>
				<div class="col-lg-4 col-md-12 col-sm-12">
            	    <input type="text" name="proposed_cost" value="<?=$row['proposed_cost']?>" readonly class="form-control" placeholder="Proposed Cost" required>
				</div>
					 	<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Final Cost <span class="required-label">*</span></label>
				<div class="col-lg-4 col-md-12 col-sm-12">
            	    <input type="text" name="final_cost" value="<?=$row['final_cost']?>" readonly class="form-control" placeholder="Final Cost" required>
				</div>
			</div>
				<div class="form-group form-show-validation row">
		    	<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Description </label>
				<div class="col-lg-9 col-md-12 col-sm-12">
            	    <textarea name="description" class="form-control" placeholder="Description" readonly><?=$row['description']?></textarea>
				</div>
			</div>
			<div class="form-group form-show-validation row">
				   	<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Project Note <span class="required-label">*</span></label>
				<div class="col-lg-6 col-md-12 col-sm-12">
            	    <input type="text" name="note" value="<?=$row['note']?>"  class="form-control" placeholder="Project Note" readonly>
			
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Project Status <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
 	<?php 
    					 $interests = array('Proposal Sent','Payment Pending','In Progress','Project Confirmed','Cancelled','Completed'); 
?>
						<select name="status" class="form-control" id="status<?=$count;?>" readonly>
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['status']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>				</div>
			
			</div>	
			
		<div class="card-action">
			<div class="row">
				<div class="col-md-12">
					<a href="all_project.php" class="btn btn-info">Back</a>
				</div>										
			</div>
		</div>
</div>
<?php } } ?>
	</form>
		
			
<?php

if(isset($_POST['sub'])){
	
$allowed = ["project_type","name","title","description","proposed_cost","final_cost","note","customer_id","customer_name","customer_phone","status"];

$params = [];
$setStr = "";
foreach ($allowed as $key)
{
    if (isset($_POST[$key]) && $key != "uid")
    {
        $setStr .= "`$key` = :$key,";
        $params[$key] = htmlspecialchars($_POST[$key]);
    }
}
// $setStr .= "`source` = :source,`agent_id` = :agent_id,`agent_name` = :agent_name,`agent_phone` = :agent_phone,";
$setStr = rtrim($setStr, ",");
$params['project_id'] =$_REQUEST['id'];
$show->table ='project';
$show->cols =$setStr;
$show->id_name ='project_id';
$show->params =$params;
//print_r($params);
if($show->update_all()){
   		
echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You ",
            text: "for Updating!",
            type: "success"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';
} else{
	echo "ss";
}

}?>
</div>	
					</div>
					<div class="col-md-12">
							<div class="card">
					<div class="card-header">
		<div class="card-title">All Proposals</div>
	</div>		
								<div class="card-body">
									<div class="table-responsive">
					            <table id="basic-datatables" class="display table table-striped table-hover">
                                        <thead>
                                        <th>ID</th>
                                        <th>Date</th>
                                        <th>Follow Up date</th>
                                        <th>Follow Up Note</th>
                                        <th>Proposal</th>
                                        <th>Proposed Cost</th>
                                        <th>Description</th>
                                            
                                        </thead>
<tbody>
		
<?php
$count=1;
$sr='project_proposal';
$stmt =$show->readwithdata($sr,'project_id',$_REQUEST['id']);
$num = $stmt->rowCount();
    if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];

// echo $usr_p;
$followd=$row['follow_date']==''?'--':date('d-m-Y',strtotime($row['follow_date']));
$follow=$row['followup']==''?'--':$row['followup'];
           // echo $usr_p;

echo "<tr>
							    <td>$count</td>
								<td>".date('d-m-Y',strtotime($row['date']))."</td>
								<td>".$followd."</td>
								<td>".$follow."</td>
								<td><a href='".$pic_img."/".$row['proposal']."' class='btn btn-xs btn-success' target='_blank'>Download</a></td>
								<td>".$row['proposed_cost']."</td>
								<td><span style='color:red'>".htmlspecialchars_decode($row['content'])."</span></td>
								";
								?>
		
                                <?php echo "
								</tr>";

++$count;
 }
}

?>							
</tbody>
                                    </table>

</div>
				
									</div>
								</div>
							</div>

</div>
			</div>
			
		</div>

<?php include 'footer.php'; ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: show_project.php

Server Info

System Features

User Info