FM / admin

/home/u775757334/domains/civicwelllife.com/public_html/management/admin/

/home/u775757334/domains/civicwelllife.com/public_html/management/admin

Name	Size	Mode	Actions
api/	-	0755	rm
dataQuery/	-	0755	rm
dist/	-	0755	rm
fonts/	-	0755	rm
function/	-	0755	rm
icons/	-	0755	rm
images/	-	0755	rm
include/	-	0755	rm
js/	-	0755	rm
loginQuery/	-	0755	rm
scripts/	-	0755	rm
styles/	-	0755	rm
vendor/	-	0755	rm
add-product.php	18141	0644	edit dl rm
apply-fresh.php	26904	0644	edit dl rm
banner-list.php	15940	0644	edit dl rm
banner.php	15867	0644	edit dl rm
blog-list.php	15943	0644	edit dl rm
blog.php	17027	0644	edit dl rm
brand-list.php	15920	0644	edit dl rm
brand-logo-list.php	15299	0644	edit dl rm
brand-logo.php	16979	0644	edit dl rm
brand.php	16209	0644	edit dl rm
brocher-list.php	15713	0644	edit dl rm
career-enquiry-list.php	16537	0644	edit dl rm
categories-list.php	17202	0644	edit dl rm
categories.php	17416	0644	edit dl rm
change-password.php	11770	0644	edit dl rm
city-list.php	16215	0644	edit dl rm
city.php	16082	0644	edit dl rm
company-list.php	15504	0644	edit dl rm
company-office-list.php	15811	0644	edit dl rm
company-office.php	16131	0644	edit dl rm
company-profile.php	19643	0644	edit dl rm
company-stock.php	16999	0644	edit dl rm
company.php	21073	0644	edit dl rm
course-list.php	16177	0644	edit dl rm
course.php	19406	0644	edit dl rm
customer-list.php	18027	0644	edit dl rm
customer-order-list.php	20938	0644	edit dl rm
customer.php	18812	0644	edit dl rm
day.php	13822	0644	edit dl rm
dbc.php	6617	0644	edit dl rm
delivered-parcel-list.php	26169	0644	edit dl rm
distributor-list.php	17837	0644	edit dl rm
distributor-order-details.php	17018	0644	edit dl rm
distributor-order-list.php	22259	0644	edit dl rm
distributor.php	19110	0644	edit dl rm
enquiry-list.php	16660	0644	edit dl rm
export-data.php	16892	0644	edit dl rm
favicon.ico	1150	0644	edit dl rm
forgot-password.php	4019	0644	edit dl rm
gallery-list.php	15893	0644	edit dl rm
gallery.php	16793	0644	edit dl rm
genrate-customer-order.php	25330	0644	edit dl rm
genrate-lead-list.php	19566	0644	edit dl rm
genrate-lead.php	24067	0644	edit dl rm
genrate-order.php	22370	0644	edit dl rm
home.php	16384	0644	edit dl rm
import-deliver-report.php	18563	0644	edit dl rm
import-manager-user.php	20714	0644	edit dl rm
import-mis-report.php	21161	0644	edit dl rm
index.php	4739	0644	edit dl rm
inward-report-list.php	21518	0644	edit dl rm
lead-category-list.php	15237	0644	edit dl rm
lead-category.php	18615	0644	edit dl rm
lead-list.php	15963	0644	edit dl rm
lead-status-list.php	15374	0644	edit dl rm
lead-status.php	18394	0644	edit dl rm
lead.php	23475	0644	edit dl rm
manager-list.php	16921	0644	edit dl rm
manager-user-list.php	27810	0644	edit dl rm
media-list.php	17533	0644	edit dl rm
media.php	14839	0644	edit dl rm
menu-category-list.php	15739	0644	edit dl rm
menu-category.php	16257	0644	edit dl rm
menu-list.php	15953	0644	edit dl rm
menu.php	16723	0644	edit dl rm
message.php	3033	0644	edit dl rm
mis-report-list.php	17045	0644	edit dl rm
mis-sample.csv	483	0644	edit dl rm
my-order-list.php	21040	0644	edit dl rm
my-product-stock.php	17959	0644	edit dl rm
my-retailer-order-list.php	20688	0644	edit dl rm
news-list.php	17941	0644	edit dl rm
news.php	17396	0644	edit dl rm
online-product-list.php	19468	0644	edit dl rm
online-product.php	17214	0644	edit dl rm
order-details.php	20698	0644	edit dl rm
order-list.php	23106	0644	edit dl rm
order-list2.php	22470	0644	edit dl rm
parcel-details-list.php	27146	0644	edit dl rm
parcel-request-list.php	27666	0644	edit dl rm
partners-list.php	15975	0644	edit dl rm
partners.php	17715	0644	edit dl rm
pdf-category-list.php	17954	0644	edit dl rm
pdf-category.php	16234	0644	edit dl rm
pdf-list.php	18100	0644	edit dl rm
pdf.php	18717	0644	edit dl rm
poster-list.php	15925	0644	edit dl rm
poster.php	16129	0644	edit dl rm
print-bill.php	25616	0644	edit dl rm
print-customer-bill.php	25378	0644	edit dl rm
product-list.php	18289	0644	edit dl rm
product.php	22375	0644	edit dl rm
project-category.php	19504	0644	edit dl rm
project-image-list.php	17805	0644	edit dl rm
project-image.php	17612	0644	edit dl rm
project-list.php	18233	0644	edit dl rm
project-product-list.php	17820	0644	edit dl rm
project-product.php	18483	0644	edit dl rm
project.php	19003	0644	edit dl rm
receive-product-list.php	17978	0644	edit dl rm
receive-product.php	19682	0644	edit dl rm
retail-print-bill.php	26362	0644	edit dl rm
retailer-genrate-order.php	22367	0644	edit dl rm
retailer-list.php	17825	0644	edit dl rm
retailer-order-details.php	17213	0644	edit dl rm
retailer-order-list.php	21049	0644	edit dl rm
retailer.php	19086	0644	edit dl rm
rm-order-list.php	22360	0644	edit dl rm
rm-user-list.php	17766	0644	edit dl rm
rm-user.php	19056	0644	edit dl rm
service-list.php	17589	0644	edit dl rm
service.php	15818	0644	edit dl rm
setting.php	19923	0644	edit dl rm
show-student-list.php	20558	0644	edit dl rm
size-list.php	16053	0644	edit dl rm
size.php	15517	0644	edit dl rm
source-list.php	15217	0644	edit dl rm
source.php	18382	0644	edit dl rm
staff-list.php	15906	0644	edit dl rm
staff.php	17700	0644	edit dl rm
state-list.php	15944	0644	edit dl rm
state.php	15242	0644	edit dl rm
stock-transaction.php	17998	0644	edit dl rm
stock.php	16317	0644	edit dl rm
team-list.php	16019	0644	edit dl rm
team.php	16318	0644	edit dl rm
testimonial-list.php	15969	0644	edit dl rm
testimonial.php	16399	0644	edit dl rm
university-list.php	17911	0644	edit dl rm
university.php	18601	0644	edit dl rm
upload-brocher.php	18118	0644	edit dl rm
user-list.php	16591	0644	edit dl rm
user.php	21410	0644	edit dl rm
view-lead.php	23641	0644	edit dl rm
view-product.php	18105	0644	edit dl rm
website-setting.php	12534	0644	edit dl rm

Edit: /home/u775757334/domains/civicwelllife.com/public_html/management/admin/import-manager-user.php (20714B)

<?php include'loginQuery/session_start.php';
    include'dbc.php';
    $pageTitle="List of Attribute ";
    $pageName=" Attribute";
    $tableName = "";
    $addPageUrl=$urlManagerUserList;
    $deleteMode="deleteData";
    $returnurl = "";
    $totalImage =5;
    $user_id =$_SESSION['userid'];
?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
            <meta content="width=device-width, initial-scale=1.0" name="viewport">
                <meta content="IE=edge" http-equiv="X-UA-Compatible">
                    
                    <title>
                        <?php echo $pageTitle;?>
                    </title>
                    
                    
                    
                    <?php include'include/header-file.php';?>
                                        
                    <link rel="stylesheet" href="vendor/select2-3.5.2/select2.css" />
                    <link rel="stylesheet" href="vendor/select2-bootstrap/select2-bootstrap.css" />
                    <link rel="stylesheet" href="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.css" />
                    
                         <?php include'message.php';?>

</meta>
            </meta>
        </meta>
        <style>
        .small-header .panel-body h2 {
        margin-top:3px;
        }
        .hbreadcrumb {
        margin-top:0;
        }
        
        </style>
    </head>
    
    <body>
        
       
        
        
        <?php include'include/header.php';?>

<?php include'include/side-menu.php';?>
        
        
        
        <div id="wrapper">

    <div class="small-header">
        <div class="hpanel">
            <div class="panel-body">
                <div id="hbreadcrumb" class="pull-right">
                    <ol class="hbreadcrumb ">
                        <li><a class="btn btn-danger" href="<?= $addPageUrl ?>"><strong>Back</strong></a></li>
                        
                    </ol>
                </div>
                <h2 class="font-light m-b-xs">
               <?php echo $pageName;?>
               
            </h2>
            <small><?php echo $pageTitle;?></small>
            </div>
        </div>
    </div>

<div class="content ">
                <div class="row">
                    
                    <div class="col-lg-12">
                        <div class="hpanel">
                            
                            <div class="panel-body">
                                <div class="container">
                                    <div class="row">
                                        <form id="frmsubmitimport" action="import-manager-user.php" method="post" name="upload_excel" enctype="multipart/form-data">
                                        <div class="col-xs-12 col-sm-2">
                                            <input type="file" name="file" id="id-input-file-2" />
                                        </div>
                                        <div class="col-xs-12 col-sm-2">
                                            <button type="submit" id="submit" name="Import" 
                                                                class="btn btn-primary button-loading" data-loading-text="Loading...">Upload
                                            </button>
                                        </div>
                                       </form> 
                                        <div class="col-xs-12 col-sm-2">
                                            
                                        </div>
                                        <div class="col-xs-12 col-sm-6">
                                            
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    
                    
                    <div class="col-lg-12">
                        <div class="hpanel">
                            <div class="panel-heading">
                                <div class="panel-tools">
                                    
                                </div>
                                
                            </div>
                            <div class="panel-body">
                            
                                 
  
       
      
       
       
 
 <style type="text/css">
 .getstatus{ margin:10px; cursor:pointer}
  .l{ margin-right:10px; cursor:pointer}
 </style>    
 <div style="float:left">
 
 </div>
 <?php  
$sql=mysqli_query($conn,"select * from $tblManager")or die(mysqli_error($conn));
while($row=mysqli_fetch_assoc($sql))
{
    $managerAry[] = $row['company_code']; 
    $managerIDAry[$row['company_code']] = $row['id']; 
}
?>        
<div class="clearfix"></div>    
    <p>
        <a href="sample.csv" class="btn btn-danger btn-xs">Download Sample</a>
    </p>
   <div id="showrecord" class="table-responsive">                                  
                                
                    <table cellpadding="1" cellspacing="1" class="table table-bordered table-striped">
                    <thead>
                    <tr>
                        <th>Status</th>
                        <th>manager_id</th>
                        <th>user_id</th>
                        <th>s_password</th>
                        <th>name</th>
                        <th>phone</th>
                        <th>email</th>
                        <th>branch_name</th>
                        <th>Address type<br>(1 = ODA,2=Normal</th>
                        <th>Address</th>
                        
                    </tr>
                    </thead>
                    <tbody>
                   
              <?php  
                 $i=1; 
              $var="";
                $MenuListResponse["data"]=array();
                $values=array();
                //$_SESSION['websiteMenuID']=$pageIDAry;
                $flag=0;
            if(isset($_FILES["file"]["tmp_name"])){
                    $filename=$_FILES["file"]["tmp_name"];
                    $file = fopen($filename, "r");
                 $tempid =  date('Ymdsa').rand(1000,9999);    
                 while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
                 {      $totalCol = count($emapData);
                        if($flag==0){
                            $flag=1;
                        }else{
                                echo "<tr>";
                                $manager_id  =  mysqli_real_escape_string($conn,$emapData[0]);
                                
                                $user_id       = mysqli_real_escape_string($conn,$emapData[1]);
                                $s_password   = mysqli_real_escape_string($conn,$emapData[2]);
                                $password   = md5($emapData[2]);
                                $name       = mysqli_real_escape_string($conn,$emapData[3]);
                                $phone      = mysqli_real_escape_string($conn,$emapData[4]);
                                $email      = mysqli_real_escape_string($conn,$emapData[5]);
                                $branch_name      = mysqli_real_escape_string($conn,$emapData[6]);
                                $address_type      = mysqli_real_escape_string($conn,$emapData[7]);
                                $address      = mysqli_real_escape_string($conn,$emapData[8]);
                                $query_status="<span class='text-success'>Insert</span>";
                                if(in_array($manager_id, $managerAry)){
                                    $m_name=$manager_id;
                                    $managerid = $managerIDAry[$manager_id];
                                    
                                    $sqlc = mysqli_query($conn,"select * from $tblManagerUser where user_id='$user_id'") or die(mysqli_error($conn));
                                    if(mysqli_num_rows($sqlc)>0){
                                        
                                       $m_name="";
                                       $query_status="<span class='text-danger'>Not Insert<br>Duplicate  User ID</span>";
                                       
                                    }else{
                                        $values[]   = "('$managerid','$user_id','$s_password','$password','$name','$phone','$email','$branch_name','0','0','0','$address_type','$address')";    
                                    }
                                    
                                }else{
                                    $query_status="<span class='text-danger'>Not Insert</span>";
                                    $m_name="<span class='text-danger'>Invalid</span>";
                                }
                                
    
                                
                                echo "<tr>
                                    <td>{$query_status}</td>
                                    <td>{$m_name}</td>
                                    <td>{$user_id}</td>
                                    <td>{$s_password}</td>
                                    <td>{$name}</td>
                                    <td>{$phone}</td>
                                    <td>{$email}</td>
                                    <td>{$branch_name}</td>
                                    <td>{$addressType[$address_type]}</td>
                                    <td>{$address}</td>
                                    </tr>";     
                            
                         }
                        
                ?>  
               
                    <?php }
                    fclose($file);
                    $sql = "INSERT INTO $tblManagerUser(manager_id,user_id,s_password,password,name,phone,email,branch_name,city_id,state_id,zone_id,address_type,address) VALUES "; 
    if(count($values)>0){
        $sql .= implode(', ', $values);  
        if(mysqli_query($conn,$sql) or die(mysqli_error($conn)))
        {
            
             echo "<h3 class='text-success'>insert success</h3>";
        }
    }else{
        echo "no record";
    }                     
     
                    } 
                     
                    ?>
                    
                    </tbody>
                </table>
                
 
                            </div>
                            
                            
                            
                            
                        </div>
                    </div>
                </div>
            </div>

<?php include'include/footer-file.php';?>

<script src="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.js"></script>
<script src="vendor/select2-3.5.2/select2.min.js"></script>

</body>
</html>
<link rel="stylesheet" href="vendor/sweetalert/lib/sweet-alert.css" />
<script src="vendor/sweetalert/lib/sweet-alert.min.js"></script>

$(document).on('click','.demo3',function(){
        var path=$(this).attr('path');

swal({
                        title: "Are you sure?",
                        text: "Your will not be able to recover this imaginary file!",
                        type: "warning",
                        showCancelButton: true,
                        confirmButtonColor: "#DD6B55",
                        confirmButtonText: "Yes, delete it!"
                    },
                    function () {
                        window.location.href=path
                    });
    });

</script>

//======================= add name end ==================================*/
$(document).on('click','.page-link',function(){
    var pageID=$(this).attr("pageid");
    var status=$(this).attr("pageid2");
    var getbackurl=$("#getbackurl").val();
    
    $("#showrecord").html('<center><i  class="fa fa-spinner fa-spin" aria-hidden="true"></i></center>');
    var cid= $("#applicationid").val();
    var getquerystring= $("#getquerystring").val();

$.ajax({
            type: "POST",
            url: "function/getBrandPageList.php",
            data: "pageID="+ pageID+"&getquerystring="+getquerystring,
            success: function(html){

$("#showrecord").html(html);
        }
    });
    return false;
});
</script>

$(document).ready(function(){
$('.pagination').pagination({
        items: <?php echo $total_records;?>,
        itemsOnPage: <?php echo $limit;?>,
        cssStyle: 'light-theme',
        currentPage : <?php echo $page;?>,
        hrefTextPrefix : 'brands-list.php?page='
    });
    });
</script>
<link rel="stylesheet" href="dist/simplePagination.css" />
<script src="dist/jquery.simplePagination.js"></script>

$(function(){

$("#form_2").validate({
            rules: {
                name: {
                    required: true,
                    minlength: 3
                },
                username: {
                    required: true,
                    minlength: 5
                },
                url: {
                    required: true,
                    url: true
                },
                number: {
                    required: true,
                    number: true
                },
                last_name: {
                    required: true,
                    minlength: 6
                }
            },
            messages: {
                number: {
                    required: "(Please enter your phone number)",
                    number: "(Please enter valid phone number)"
                },
                last_name: {
                    required: "This is custom message for required",
                    minlength: "This is custom message for min length"
                }
            },
            submitHandler: function(form) {
                form.submit();
            },
            errorPlacement: function(error, element) {
                $( element )
                        .closest( "form" )
                        .find( "label[for='" + element.attr( "id" ) + "']" )
                        .append( error );
            },
            errorElement: "span",
        });

});
</script>
 <script>

$(function(){

$('#datepicker').datepicker();
            $("#datepicker").on("changeDate", function(event) {
                $("#my_hidden_input").val(
                        $("#datepicker").datepicker('getFormattedDate')
                )
            });

$('#datapicker2').datepicker();
            $('.input-group.date').datepicker({ });
            $('.input-daterange').datepicker({ });

$("#demo1").TouchSpin({
                min: 0,
                max: 100,
                step: 0.1,
                decimals: 2,
                boostat: 5,
                maxboostedstep: 10,
            });

$("#demo2").TouchSpin({
                verticalbuttons: true
            });

$("#demo3").TouchSpin({
                postfix: '%'
            });

$("#demo4").TouchSpin({
                postfix: "a button",
                postfix_extraclass: "btn btn-default"
            });

$(".js-source-states").select2();
            $(".js-source-states-2").select2();

//turn to inline mode
            $.fn.editable.defaults.mode = 'inline';

//defaults
            $.fn.editable.defaults.url = '#';

//editables
            $('#username').editable({
                url: '#',
                type: 'text',
                pk: 1,
                name: 'username',
                title: 'Enter username'
            });

$('#firstname').editable({
                validate: function(value) {
                    if($.trim(value) == '') return 'This field is required';
                }
            });

$('#sex').editable({
                prepend: "not selected",
                source: [
                    {value: 1, text: 'Male'},
                    {value: 2, text: 'Female'}
                ],
                display: function(value, sourceData) {
                    var colors = {"": "gray", 1: "green", 2: "blue"},
                            elem = $.grep(sourceData, function(o){return o.value == value;});

if(elem.length) {
                        $(this).text(elem[0].text).css("color", colors[value]);
                    } else {
                        $(this).empty();
                    }
                }
            });

$('#dob').editable();

$('#event').editable({
                placement: 'right',
                combodate: {
                    firstItem: 'name'
                }
            });

$('#comments').editable({
                showbuttons: 'bottom'
            });

$('#fruits').editable({
                pk: 1,
                limit: 3,
                source: [
                    {value: 1, text: 'banana'},
                    {value: 2, text: 'peach'},
                    {value: 3, text: 'apple'},
                    {value: 4, text: 'watermelon'},
                    {value: 5, text: 'orange'}
                ]
            });

$('#user .editable').on('hidden', function(e, reason){
                if(reason === 'save' || reason === 'nochange') {
                    var $next = $(this).closest('tr').next().find('.editable');
                    if($('#autoopen').is(':checked')) {
                        setTimeout(function() {
                            $next.editable('show');
                        }, 300);
                    } else {
                        $next.focus();
                    }
                }
            });

// ClockPicker
            $('.clockpicker').clockpicker({autoclose: true});

// DateTimePicker
            $('#datetimepicker1').datetimepicker();

});

</script>

cmd: