MAINHACK

Viewing / Editing File: edit_project.php

<?php include 'header.php';?>
<style>
    
    .col-md-3,.col-md-2,.col-md-6{
        display:inline-block !important;
    }
</style>
<script>
    
      $(document).ready(function(){
        // Add more
        $('#type').change(function(){
            
         var type = $('#type').val(); 
       //  alert(type);
         if(type=='Direct'){
             $('#direct').show(); 
             $('#agent').hide(); 
 
         }else{
           $('#direct').hide(); 
             $('#agent').show();

}
        });
      });
</script>
<style type="text/css">

#display
	{
		position:absolute;
		width:300px;
		margin-left:0;
		padding:2px;
		display:none;
		border-top:0px;
		overflow:auto;
		border:1px #CCC solid;
		background-color: white;
		z-index:1000;
	}	
	
	.show,.show1
	{
		padding:7px; 
		border-bottom:1px #999 dashed;
		font-size:18px; 
		
	}

.widget{
	overflow:visible !important;
	
}

</style>

}

$(document).ready(function(){
$("#fli").keyup(function() {
var search = $('#fli').val();
//alert(search);
if(search=="")
{
$("#display").html("");
}
else
{
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "search="+ search ,
success: function(html){
$("#display").html(html).show();
}
});
}
});
});
function fill1(Value,Value1,Value2)
{
$('#fli1').val(Value1);
$('#client_id').val(Value);
$('#phone').val(Value2);
$('#display1').hide();

}

$(document).ready(function(){
$("#fli1").keyup(function() {
var search = $('#fli1').val();
//alert(search);
if(search=="")
{
$("#display").html("");
}
else
{
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "search1="+ search ,
success: function(html){
$("#display1").html(html).show();
}
});
}
});
});
</script>
		<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">Edit 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" required="">

<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" required="">
            <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']?>" 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-4 col-md-12 col-sm-12">
            	    <input type="text" name="title"  value="<?=$row['title']?>" 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 ">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']))?>" name="date" class="form-control">
				</div>
					<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']))?>" name="renewal_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']?>" 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']?>" 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"><?=$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-5 col-md-12 col-sm-12">
            	    <input type="text" name="note" value="<?=$row['note']?>"  class="form-control" placeholder="Project Note" required>
			
				</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-3 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;?>">
<?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">
					<input class="btn btn-success" type="submit" name="sub" value="Submit">
					<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 .= "`renewal_date` = :renewal_date,`date` = :date";
$setStr = rtrim($setStr, ",");
$params['project_id'] =$_REQUEST['id'];
$params['renewal_date'] =date('Y-m-d',strtotime($_POST['renewal_date']));
$params['date'] =date('Y-m-d',strtotime($_POST['date']));
$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: edit_project.php

Server Info

System Features

User Info