MAINHACK

Viewing / Editing File: add_project.php

<?php include 'header.php' ;

$show=new Oops($db);
?>
<style type="text/css">

#fli,#fli1
	{
	
	}
	#display
	{
		position:absolute;
		width:315px;
		margin-left:0;
		margin-top:0px;
		max-height:300px;
		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:15px; 
		
	}
	
	.show:hover,.show1:hover
	{
		background:#4f52ba;
		color:#FFF;
		cursor:pointer;
	}	
.widget{
	overflow:visible !important;
	
}	
</style>
<script>
    $(document).ready(function(){
    $("input[type='radio']").on('click', function(){
    var radioValue = $("input[name='type']:checked").val();
    if(radioValue=='New'){
        
        $('#new').show();
        $('#exist').hide();
        
    }else{
        $('#exist').show();
        $('#new').hide();
    }
    });
});
function fill(Value1,Value2,Value3,Value4)
{
$('#fli').val(Value1);
$('#com_name').val(Value2);
$('#person').val(Value3);
$('#phn').val(Value4);
$('#display').hide();

}

$(document).ready(function(){
$("#fli").keyup(function() {
var fli = $('#fli').val();

//alert(fli);
if(fli=="")
{
$("#display").html("");
}
else
{
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "fli="+ fli ,
beforeSend: function() {
$("#load").show();
},
success: function(html){
$("#display").html(html).show();
$("#load").hide();

}
});
}
});
});

$(document).ready(function(){
            // Add more
            $('#addmore').click(function(){
                // Get last id 
                var lastname_id = $('.tr_input input[type=text]').last().attr('id');
                var split_id = lastname_id.split('_');
                // New index
                var index = Number(split_id[1]) + 1;
		        document.getElementById('getid').value=index;
		        //alert(split_id);
                // Create row with input elements
                 var html = "<div class='tr_input'><div class='col-md-12'><div class='col-md-4'><select name='category[]' id='cate"+index+"' onchange='check()' required class='form-control'><option value=''>Choose</option><?php $stmt=$show->state('job');$r=$stmt->rowCount(); if($r>0){while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){echo "<option value='".$row['job_id'].":".$row['title']."'>".$row['title']."</option>";}}?> </select></div><div class='col-md-6'><input type='hidden' class='form-control' id='title"+index+"'  name='title[]' placeholder='Product des'><input type='text' class='form-control' id='testcode_"+index+"'  name='des[]' placeholder='Product des'></div><div class='col-md-2'><a href='javascript:void(0);' id='remove_field'  class='remCF btn btn-info' >-</a></div></div></div>";
                // Append data
                $('#tab').append(html);
            });
			
                $("#tab").on('click','.remCF',function(){
                $(this).parent().parent().remove();
	        	var lastname_id = document.getElementById('getid').value;
		        //alert(lastname_id);
                // New index
                var index = lastname_id - 1;
                // Create row with input elements
				document.getElementById('getid').value=index;
    });
        });
function check(){
var id=document.getElementById('getid').value;
var c="#cate"+id;
var c_val=$(c).val();
var category=c_val.split(':');

var des='#testcode_'+id;
var title='#title'+id;

//alert(title);
//var a;
 $.ajax({
type: "POST",
url: "ajax_check.php",
data: "category="+ category[0]+"&id="+id ,
beforeSend: function() {
$("#load").show();
},
success: function(data){

var t_val=$(title).val(category[1]);

$(des).val(data);

}
});
}
function pay(){

var amt=$("#cost").val();
    var gst=$("#gst").val();
    var gst_amt=gst/100;
    var total=parseFloat(amt*gst_amt)+Number(amt);
    $("#total").val(total);

}
</script>
      	<div id="page-wrapper">
			<div class="main-page">
				<div class="row">
                        <div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
						<div class="form-title">
							<h4>Add Project :</h4>
						</div>
						<div class="form-body">
							<form method="post"  enctype="multipart/form-data"> 
							<div class="col-md-12"><label>Client</label>
							<input type="radio" name="type" value="New" required>New
							<input type="radio" name="type" value="Exist" checked required>Existing
							</div>
                            <div id="new" style="display:none">
							<div class="col-md-4">
								<div class="form-group">
									<label>Company Name</label>
									<input type="text" class="form-control" id="com_name" name="company_name1" placeholder="Company Name">
								</div>
							</div>
							<div class="col-md-4">
								<div class="form-group">
									<label>Company Website</label>
									<input type="text" class="form-control" id="com_name" name="company_website1" placeholder="Company Website">
								</div>
							</div>
								<div class="col-md-4">
								<div class="form-group">
									<label>GSTIN</label>
									<input type="text" class="form-control" name="gstin1" id="gstin"  placeholder="GSTIN">
								</div>
							</div>
								<div class="col-md-4">
								<div class="form-group">
									<label>Email ID</label>
									<input type="text" class="form-control" name="email1" id="gstin"  placeholder="Email ID">
								</div>
							</div>							
							<div class="col-md-4">
								<div class="form-group">
									<label>Contact Name 1</label>
									<input type="text" class="form-control" name="contact_person11" placeholder="Contact Name 1" >
								</div>
							</div>
							<div class="col-md-4">
								<div class="form-group">
									<label for="exampleInputEmail1">Contact Phone 1</label>
									<input type="text" class="form-control" name="phone11" placeholder="Contact Phone 1">
								</div>
							</div>
							<div class="col-md-4">
								<div class="form-group">
									<label>Contact Name 2</label>
									<input type="text" class="form-control" name="contact_person21" placeholder="Contact Name 2" >
								</div>
							</div>
							<div class="col-md-4">
								<div class="form-group">
									<label for="exampleInputEmail1">Contact Phone 2</label>
									<input type="text" class="form-control" name="phone21" placeholder="Contact Phone 2">
								</div>
							</div>
						
							<div class="col-md-12">
								<div class="form-group">
									<label>Address</label>
						<input type="text" class="form-control" name="address1" id="address" placeholder=" Address" >
								</div>
							</div>
							<div class="col-md-4 pr-1">
								<div class="form-group">
									<label>State</label>
									<select name="state1" class="form-control">
									    <option value="">Choose</option>
									 <?php 
									 $stmt=$show->state('state_list');
									 $r=$stmt->rowCount();
									 if($r>0){
                                     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
									    echo "<option value='".$row['state']."'>".$row['state']."</option>";
    									}
    									}
									 ?>   
									    
									</select>
								</div>
							</div>
							<div class="col-md-4 pr-1">
								<div class="form-group">
									<label>City</label>
									<input type="text" class="form-control" name="city1" placeholder="City">
								</div>
							</div>
							<div class="col-md-4 pl-1">
								<div class="form-group">
									<label>Postal Code</label>
									<input type="number" class="form-control" name="pincode1" placeholder="ZIP Code">
								</div>
							</div>
							<div class="col-md-4 pl-1">
								<div class="form-group">
									<label>Reference</label>
									<input type="text" class="form-control" name="reference1" placeholder="Reference">
								</div>
							</div>
						<div class="col-md-4 pl-1">
								<div class="form-group">
									<label>Date of Registration</label>
									<input type="text"  id="date" class="form-control" name="date_of_register1" placeholder="Date of Registration">
								</div>
							</div>
							</div>
							<div id="exist" style="display:">
							<div class="col-md-3">
								<div class="form-group">
									<label>Name/Contact Person/Phone</label>   
							<input type="text" class="form-control" id="fli" name="client_id" placeholder="Company ID/Name/Contact Person/Phone">
							<div id="display"></div> 
							</div>	</div>
							<div class="col-md-3">
								<div class="form-group">
									<label>Company Name </label>
									<input type="text" class="form-control" id="com_name" name="com_name" placeholder="Company Name" readonly>
								</div>
							</div>
							<div class="col-md-3">
								<div class="form-group">
									<label>Contact Name </label>
									<input type="text" class="form-control" id="person" name="contact_person1" placeholder="Contact Name" readonly>
								</div>
							</div>
							<div class="col-md-3">
								<div class="form-group">
									<label for="exampleInputEmail1">Contact Phone </label>
									<input type="text" class="form-control" id="phn" name="phone1" placeholder="Contact Phone" readonly>
								</div>
							</div>
							
							</div>
							<div class="col-md-12"><hr><h4>Project Details</h4>
							<div class="col-md-3">
						    <div class="form-group">
							<label>Project Name</label>   
							<input type="text" class="form-control" id="" name="pro_name" placeholder="Project Name">
							</div>	
							</div>
                            <div class="col-md-3">
						    <div class="form-group">
							<label>Project Start Date</label>   
							<input type="text" class="form-control" id="date3" name="start_date" placeholder="Project Start Date">
							</div>	
							</div>						
						    <div class="col-md-3">
						    <div class="form-group">
							<label>Project Estimated End Date</label>   
							<input type="text" class="form-control" id="date1" name="end_date" placeholder="Project Estimated End Date">
							</div>	
							</div>	
							<div class="col-md-3">
						    <div class="form-group">
							<label>Project Cost</label>   
							<input type="text" class="form-control" id="cost" name="cost" placeholder="Project Cost">
							</div>	
							</div>
								<div class="col-md-3">
						    <div class="form-group">
							<label>Project Gst</label>   
							<input type="text" class="form-control" id="gst" onkeyup="pay()" name="gst" placeholder="Project Gst">
							</div>	
							</div>
								<div class="col-md-3">
						    <div class="form-group">
							<label>Project Total</label>   
							<input type="text" class="form-control" id="total" name="total" placeholder="Project Total" readonly>
							</div>	
							</div>
							<div class="col-md-12">
						    <div class="form-group">
							<label>Project Description</label>   
							<textarea name="p_description"></textarea>
							</div>	
							</div>		
							
							
							</div>
							<div class="col-md-12">
							<input type="hidden" id="getid" name="getid" value="1">
                            <div class="col-md-12">
                            <div class="col-md-4">	<label>Job Title</label></div>
                            <div class="col-md-6">	<label>Description</label></div>
                            <div class="col-md-2"></div>
                            </div>
							<div class='tr_input' id="tab" style="border:none !important;">
							<div class='col-md-12'>
							<div class="col-md-4">
								<div class="form-group">
								
									<select name="category[]" id="cate1" onchange="check()" required class="form-control">
									    <option value="">Choose</option>
									 <?php 
									 $stmt=$show->state('job');
									 $r=$stmt->rowCount();
									 if($r>0){
                                     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
									    echo "<option value='".$row['job_id'].":".$row['title']."'>".$row['title']."</option>";
    									}
    									}
									 ?>   
									    
									</select>
								</div>
							</div>
						
							<div class="col-md-6">
								<div class="form-group">
						<input type="hidden" class="form-control" name="title[]" id="title1" placeholder="Description" >
								
						<input type="text" class="form-control" name="des[]" id="testcode_1" placeholder="Description" >
								</div>
							</div>
						
							<div class="col-md-2">
    								<input type="button" class="btn btn-info" value="+" id="addmore">
    							</div>
    						</div>
                            </div>	    
							    
							</div>
							
							</div>
							
						<div class="col-md-2"><button type="submit" class="btn btn-info btn-fill pull-right" name="sub">Submit</button></div>
						<div class="clearfix"></div>
                                    </form>
<?php
if(isset($_POST['sub'])){
	
if($_POST['type']=='New'){
  	$table='client';
	include 'ids.php';
	$data=array(	
	'client_id'=>$uid,
	'company_name'=>$_POST['company_name1'],
	'company_website'=>$_POST['company_website1'],
	'gstin'=>$_POST['gstin1'],
	'email'=>$_POST['email1'],
	'contact_person1'=>$_POST['contact_person11'],
	'phone1'=>$_POST['phone11'],
	'contact_person2'=>$_POST['contact_person21'],
	'phone2'=>$_POST['phone21'],
	'address'=>$_POST['address1'],
	'state'=>$_POST['state1'],
	'city'=>$_POST['city1'],
	'pincode'=>$_POST['pincode1'],
	'date'=>date('Y-m-d'),
	'reference'=>$_POST['reference1'],
	'date_of_register'=>date('Y-m-d',strtotime($_POST['date_of_register1'])),
	);
    $r=$show->insert($table,$data);  
    include 'project_id.php';

$data1=array(	
	'project_id'=>$pid,
	'project_name'=>$_POST['pro_name'],
	'description'=>$_POST['p_description'],
	'start_date'=>date('Y-m-d',strtotime($_POST['start_date'])),
	'end_date'=>date('Y-m-d',strtotime($_POST['end_date'])),
	'cost'=>$_POST['cost'],
	'client_id'=>$uid,
	'name'=>$_POST['contact_person11'],
	'phone'=>$_POST['phone11'],
	'date_of_entry'=>date('Y-m-d'),
	'due'=>$_POST['total'],
	'gst'=>$_POST['gst'],
	'total'=>$_POST['total'],

);    
	$r1=$show->insert('project',$data1);

foreach($_POST['category'] as $key=>$value){
      $job_id=explode(':',$_POST['category'][$key]);
     $data2=array(	
	'project_id'=>$pid,
	'job_id'=>$job_id[0],
	'title'=>$_POST['title'][$key],
	'description'=>$_POST['des'][$key],
	); 
     $r2=$show->insert('job_project',$data2);

}  
		echo "<script>sweetAlert('Ok','New Project has been added','success');</script>";

}else{
  
    include 'project_id.php';

$data1=array(	
	'project_id'=>$pid,
	'project_name'=>$_POST['pro_name'],
	'description'=>$_POST['p_description'],
	'start_date'=>date('Y-m-d',strtotime($_POST['start_date'])),
	'end_date'=>date('Y-m-d',strtotime($_POST['end_date'])),
	'cost'=>$_POST['cost'],
	'client_id'=>$_POST['client_id'],
	'name'=>$_POST['contact_person1'],
	'phone'=>$_POST['phone1'],
	'date_of_entry'=>date('Y-m-d'),
	'due'=>$_POST['total'],
	'gst'=>$_POST['gst'],
	'total'=>$_POST['total'],

);    
	$r1=$show->insert('project',$data1);

}    
		echo "<script>sweetAlert('Ok','New Project has been added','success');</script>";

}

}
?>
									
                                </div>
                            </div>
                            </div>
                            </div>
                          </div>
         
<?php include 'footer.php' ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: add_project.php

Server Info

System Features

User Info