I Want To Break Free

Editando: add_subcontractor.php

<?php
$page = 'Sub Contractor';
$page_icon = "";
$contractor = "active";
include("check.php");
include 'header.php';

if (@$_REQUEST['btn_add']) {

$name = $_POST['name'];
    $status = $_POST['status'];
    $address = $_POST['address'];
    $contact = $_POST['contact'];
    $contact2 = $_POST['contact2'];
    $email = $_POST['email'];

$insert = mysql_query("insert into employees(status,name,address,contact_no,contact_no2,email_id,cdate,emp_sub_conta) "
            . "values('$status','$name','$address','$contact','$contact2','$email','$date','sub')");
    if (!$insert) {
        $_SESSION['msg'] = "Something is wrong..Please try again..";
        $_SESSION['type'] = "Error";
    } else {
        $_SESSION['msg'] = "Sucessefully inserted record..";
        $_SESSION['type'] = "Success";
    }
    echo '<script>window.location="add_subcontractor.php";</script>';
}

if (@$_REQUEST['btn_update']) {
    $eid = $_POST['eid'];
    $name = $_POST['name'];
    $status = $_POST['status'];
    $address = $_POST['address'];
    $contact = $_POST['contact'];
    $contact2 = $_POST['contact2'];
    $email = $_POST['email'];

$update = mysql_query("update employees set name='$name', address='$address', contact_no='$contact', contact_no2='$contact2',email_id='$email', status='$status' where eid='$eid'");

if (!$update) {
        $_SESSION['msg'] = "Something is wrong..Please try again..";
        $_SESSION['type'] = "Error";
    } else {
        $_SESSION['msg'] = "Sucessefully updated record..";
        $_SESSION['type'] = "Success";
    }
    echo '<script>window.location="add_subcontractor.php";</script>';
}
?>

<div class="page-content-wrap"> 
    <div class="row">
        <div class="col-md-12">
            
            <div class="panel panel-colorful">
                <div class="panel-heading ui-draggable-handle modal-header">                               
                    <h3 class="panel-title">Sub Contractor List</h3>
                    <div class="btn-group pull-right">
                        <a href="javascript:void(0)" data-toggle="modal" data-target="#modal_addsubform" class="btn btn-primary"><i class="fa fa-plus"></i> Add Sub Contractor</a>
                    </div>

<div class="btn-group pull-right">
                        <button class="btn btn-danger dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> Export Data</button>
                        <ul class="dropdown-menu">


                            <li><a href="#" onClick ="$('#sub').tableExport({type: 'csv', escape: 'false'});"><img src='img/icons/csv.png' width="24"/> CSV</a></li>
                            <li><a href="#" onClick ="$('#sub').tableExport({type: 'txt', escape: 'false'});"><img src='img/icons/txt.png' width="24"/> TXT</a></li>
                            <li class="divider"></li>
                            <li><a href="#" onClick ="$('#sub').tableExport({type: 'excel', escape: 'false'});"><img src='img/icons/xls.png' width="24"/> XLS</a></li>
                            <li><a href="#" onClick ="$('#sub').tableExport({type: 'doc', escape: 'false'});"><img src='img/icons/word.png' width="24"/> Word</a></li>
                            
                            <li class="divider"></li>
                            <li><a href="#" onClick ="$('#sub').tableExport({type: 'png', escape: 'false'});"><img src='img/icons/png.png' width="24"/> PNG</a></li>
                            
                        </ul>
                    </div> 
                </div>
                <div class="panel-body">
                    <table id="employee" class="table datatable table-hover table-striped">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>Employee Name</th>
                                <th>Status</th>
                                <th>Contact No</th>
                                <th>Contact No(2)</th>
                                <th>Email Id</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $i = 1;
                            $select = mysql_query("select * from employees where (d_status!='Delete') and (emp_sub_conta='sub')");
                            while ($company_emp_data = mysql_fetch_array($select)) {
                                ?><tr id="employee<?php echo $company_emp_data['eid']; ?>">
                                    <td><?php echo $i; ?></td>
                                    <td><?php echo $company_emp_data['name']; ?></td>
                                    <td><?php echo $company_emp_data['status']; ?></td>
                                    <td><?php echo $company_emp_data['contact_no']; ?></td>
                                    <td><?php echo $company_emp_data['contact_no2']; ?></td>
                                    <td><?php echo $company_emp_data['email_id']; ?></td>
                                    <td>
                                        <a href="javascript:void(0);" data-toggle="modal" data-target="#modal_updatesubform" onClick="viewData('sub_cont_update.php', 'sub', '<?php echo $company_emp_data['eid']; ?>');"><span class="fa fa-edit"></span></a> &nbsp;&nbsp;
                                        <a href="javascript:void(0);"  onClick="delete_row('employee', '<?php echo $company_emp_data['eid']; ?>');"><span class="fa fa-trash-o"></span></a>&nbsp;&nbsp;
                                        <a href="emp_personal_account.php?emp_id=<?php echo $company_emp_data['eid']; ?>&name=<?php echo $company_emp_data['name']; ?>&status=<?php echo $company_emp_data['status']; ?>"  ><span class="fa fa-eye"></span></a>
                                    </td>
                                </tr>
                                <?php
                                $i++;
                            }
                            ?>
                        </tbody>
                    </table>
                </div>
            </div>

</div>
    </div>

</div>

<div class="modal" id="modal_updatesubform" tabindex="-1" role="dialog" aria-labelledby="defModalHead" aria-hidden="true">
    <div class="modal-dialog" id="viewsub">

</div>
</div>
<div class="modal" id="modal_addsubform" tabindex="-1" role="dialog" aria-labelledby="defModalHead" aria-hidden="true">
    <div class="modal-dialog" id="viewemployee">

<form method="post">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
                    <h4 class="modal-title" id="defModalHead">Company Employee Form</h4>
                </div>
                <div class="modal-body">

<div class="row">                      
                        <div class="col-md-6">
                            <div class="form-group">
                                <label class="control-label">Employee Name</label>
                                <input name="name" id="name" value="" required="" type="text" class="form-control"/>
                            </div>
                        </div> 
                        <div class="col-md-6">          
                            <div class="form-group">
                                <label class="control-label">Select Status</label>                        
                                <select name="status" class="form-control" id="status_display" required="">
                                    <?php
                                    $select_status = mysql_query("select * from types_work");
                                    while ($view_status = mysql_fetch_array($select_status)) {
                                        ?>
                                        <option value="<?php echo $view_status['desc']; ?>"><?php echo $view_status['desc']; ?></option>
                                        <?php
                                    }
                                    ?>
                                </select>
                            </div>     
                        </div> 
                    </div>
                    <div class="row">                               
                        <div class="col-md-12">
                            <div class="form-group">
                                <label class="control-label">Address</label>
                                <textarea id="address" class="form-control" name="address" required=""></textarea>
                            </div> 
                        </div> 
                    </div>
                    <div class="row">                     
                        <div class="col-md-6">
                            <div class="form-group">
                                <label class="control-label">Contact No</label>
                                <input name="contact" value="" type="text" onkeypress="return onlyNos(event, this);" required=""  class="form-control" />
                            </div>
                        </div>                         
                        <div class="col-md-6">
                            <div class="form-group">
                                <label class="control-label">Contact No (2)</label>
                                <input name="contact2" value="" onkeypress="return onlyNos(event, this);" type="text" class="form-control"/>
                            </div>
                        </div>
                    </div>
                    <div class="row">                     
                        <div class="col-md-12">
                            <div class="form-group">
                                <label class="control-label">E-mail Id</label>
                                <input name="email" value="" type="text" class="form-control"/>
                            </div>
                        </div> 
                    </div>
                </div>
                <div class="modal-footer">
                    <input type="submit" class="btn btn-primary" name="btn_add" value="Add" />
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>
            </div>
        </form>
    </div>
</div>
<?php
include 'footer.php';
?>

Cancelar