22

✏️ Editing: import_store.php

<?php

$level_mode = \AgileStoreLocator\Helper::expertise_level();

//  simple level
if($level_mode == '1'): ?>
<style type="text/css">
  .sl-complx {display: none !important;}
</style>
<?php endif; ?>

<div class="asl-p-cont asl-new-bg">
<div class="hide">
  <svg xmlns="http://www.w3.org/2000/svg">
    <symbol id="i-export" viewBox="0 0 32 32" width="13" height="13" fill="none" stroke="currentcolor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2">
      <path d="M28 22 L28 30 4 30 4 22 M16 4 L16 24 M8 12 L16 4 24 12" />
    </symbol>
    <symbol id="i-import" viewBox="0 0 32 32" width="13" height="13" fill="none" stroke="currentcolor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2">
      <path d="M28 22 L28 30 4 30 4 22 M16 4 L16 24 M8 16 L16 24 24 16" />
    </symbol>
    <symbol id="i-trash" viewBox="0 0 32 32" width="16" height="16" fill="none" stroke="currentcolor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2">
        <title><?php echo esc_attr__('Trash','asl_locator') ?></title>
        <path d="M28 6 L6 6 8 30 24 30 26 6 4 6 M16 12 L16 24 M21 12 L20 24 M11 12 L12 24 M12 6 L13 2 19 2 20 6" />
    </symbol>
    <symbol id="i-edit" viewBox="0 0 32 32" width="13" height="13" fill="none" stroke="currentcolor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2">
        <title><?php echo esc_attr__('Edit','asl_locator') ?></title>
        <path d="M30 7 L25 2 5 22 3 29 10 27 Z M21 6 L26 11 Z M5 22 L10 27 Z" />
    </symbol>
    <symbol id="i-info" viewBox="0 0 32 32" width="13" height="13" fill="none" stroke="currentcolor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2">
        <path d="M16 14 L16 23 M16 8 L16 10" />
        <circle cx="16" cy="16" r="14" />
    </symbol>
    <symbol id="i-upload" viewBox="0 0 32 32" width="13" height="13" fill="none" stroke="currentcolor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2">
      <path d="M9 22 C0 23 1 12 9 13 6 2 23 2 22 10 32 7 32 23 23 22 M11 18 L16 14 21 18 M16 14 L16 29" />
    </symbol>
    <symbol id="i-desktop" viewBox="0 0 32 32" width="13" height="13" fill="none" stroke="currentcolor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2">
      <path d="M10 29 C10 29 10 24 16 24 22 24 22 29 22 29 L10 29 Z M2 6 L2 23 30 23 30 6 2 6 Z" />
    </symbol>
    <symbol id="i-reload" viewBox="0 0 32 32" width="13" height="13" fill="none" stroke="currentcolor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2">
      <path d="M29 16 C29 22 24 29 16 29 8 29 3 22 3 16 3 10 8 3 16 3 21 3 25 6 27 9 M20 10 L27 9 28 2" />
    </symbol>
  </svg>
</div>
  <div class="container">
    <div class="row asl-inner-cont">
      <div class="col-md-12">
        <div class="card p-0 mb-4">
          <h3 class="card-title"><?php echo esc_attr__('Import Stores','asl_locator') ?></h3>
          <div class="card-body">
            <div class="dump-message asl-dumper"></div>
            <div class="row">
              <div class="col-md-12" id="message_complete"></div>
              <?php if(!extension_loaded('mbstring')): ?>
              <div class="col-md-12"><p class="alert alert-danger" style="font-size: 14px"><?php echo esc_attr__('Mbstring extension is not installed on your server, contact your server admin OR login to your cpanel and enable it. Import will not work without this extension.','asl_locator') ?></p></div>
              <?php endif; ?>
              <?php if(!is_writable(ASL_PLUGIN_PATH.'public/import')): ?>
               <div class="col-md-12"><p class="alert alert-danger" style="font-size: 14px"><?php echo ASL_PLUGIN_PATH.'public/import' ?> <= <?php echo esc_attr__('Directory is not writable, Excel Import will Fail, Make directory writable.','asl_locator') ?> ?></p></div>
              <?php endif; ?>
            </div>
            <div class="card-text mb-3"><?php echo esc_attr__('Please Validate the Google Server API Key before Import process, to make sure the coordinates will be fetched correctly through the Google Maps API, ASL is not responsible if Google API doesn\'t provide correct values, please save your Server Google API Key in ASL Settings.','asl_locator') ?></b></div>
            <div class="row">
              <div class="col-md-6">
                <div class="asl-google-api-key asl-import-stores-box mb-4">
                  <h4 class="asl-box-title"><?php echo esc_attr__('Server Google Maps Key','asl_locator') ?></h4>
                  <div class="input-group">
                    <input type="text" id="txt_server_key" readonly="readonly" value="<?php echo esc_attr($api_key) ?>" class="form-control">
                    <p class="help-p"><a target="_blank" class="text-muted" href="https://agilestorelocator.com/wiki/what-is-google-server-key/">What is Google Server Key?</a> | <a target="_blank" class="text-muted" href="https://agilestorelocator.com/wiki/google-server-api-key-troubleshooting/">Troubleshoot</a></p>
                    <div class="input-group-append">
                      <a id="btn-validate-key" data-loading-text="<?php echo esc_attr__('Validating...','asl_locator') ?>" class="btn btn-sm btn-primary"><?php echo esc_attr__('Validate Key','asl_locator') ?></a>
                    </div>
                  </div>
                </div>
              </div>
              <div class="col-md-6">
                <div class="asl-fatch-coordinates sl-complx asl-import-stores-box mb-4">
                  <h4 class="asl-box-title"><?php echo esc_attr__('Fetch Coordinates','asl_locator') ?></h4>
                  <div class="card-text mb-3"><?php echo esc_attr__('Please use fetch coordinates button to fill your missing coordinates (Lat/Lng) of your stores through the Google Geocoding API Service, it is important to validate the response of the Google Server Maps API Key and that should report "Valid API Key".','asl_locator') ?></div>
                  <a data-loading-text="<?php echo esc_attr__('Fetching Coordinates...','asl_locator') ?>" id="btn-fetch-miss-coords" class="btn btn-sm btn-primary"><?php echo esc_attr__('Fetch Missing Coordinates','asl_locator') ?></a>
                </div>
                </div>
            </div>
            <div class="row">
              <div class="col-md-12">
                <div class="card-title mt-3 mb-3"><?php echo esc_attr__('Imported CSV Files','asl_locator') ?></div>
                <p class="alert alert-warning"><?php echo esc_attr__('Current build works with CSV with comma as the delimiter. Please contact us at support@agilelogix.com for support.','asl_locator') ?></p>
                <?php if(defined( 'ASL_INSERT_ON_UPDATE' )): ?>
                <p class="alert alert-info mt-2"><?php echo esc_attr__('Notice: your wp-config.php contains `ASL_INSERT_ON_UPDATE` update operation will do the insertion for missing key.','asl_locator') ?></p>
                <?php endif; ?>
                <div class="card-text mb-3"><?php echo esc_attr__('Please upload your CSV file and then import it though the import button, please make sure to follow the given template and the columns should be in the right format as described in the documentation or simply use Template.csv format, please validate your API Key before import.','asl_locator') ?> <?php echo esc_attr__('Guide article: ','asl_locator') ?> <a target="_blank" href="https://agilestorelocator.com/wiki/can-import-stores-using-excel-sheet/"><b><?php echo esc_attr__('Import Stores Using Excel/CSV','asl_locator') ?></b></a>.</div>
                <div class="row">
                  <div class="col-md-6 mb-3">
                    <div class="float-md-left">
                      <button type="button" class="btn btn-success mr-2" data-toggle="smodal" data-target="#import_store_file_emodel"><i><svg width="13" height="13"><use xlink:href="#i-upload"></use></svg></i><?php echo esc_attr__('Upload','asl_locator') ?></button>
                      <button type="button" class="btn btn-success mr-2" id="export_store_file_"><i><svg width="13" height="13"><use xlink:href="#i-export"></use></svg></i><?php echo esc_attr__('Export All','asl_locator') ?></button>
                      <a target="_blank" class="btn btn-dark" href="<?php echo ASL_URL_PATH.'public/export/template-import.csv' ?>">Template.csv</a>         
                    </div>
                  </div>
                  <div class="col-md-6 mb-3">
                    <div class="float-md-right">
                      <button type="button" class="btn btn-danger mr-2" data-loading-text="<?php echo esc_attr__('Deleting...','asl_locator') ?>" id="asl-delete-stores"><i><svg width="13" height="13"><use xlink:href="#i-trash"></use></svg></i><?php echo esc_attr__('Delete All Stores','asl_locator') ?></button>
                      <button type="button" class="btn btn-warning mr-2 sl-complx" data-loading-text="<?php echo esc_attr__('Removing...','asl_locator') ?>" id="asl-duplicate-remove"><i><svg width="13" height="13"><use xlink:href="#i-trash"></use></svg></i><?php echo esc_attr__('Remove Duplicates','asl_locator') ?></button>
                    </div>
                  </div>
                  <div class="col-md-12">
                    <div class="row mt-3">
                      <div class="col-lg-6 mb-2">
                        <div class="form-group sl-complx mb-1">
                          <label class="d-block" for="sl-duplicates-data"><?php echo esc_attr__('Avoid Duplication','asl_locator') ?></label>
                          <select name="sl-duplicates"  id="sl-duplicates-data" class="custom-select m-250 form-control">                     
                            <option value=""><?php echo esc_attr__('None','asl_locator') ?></option>
                            <option value="email"><?php echo esc_attr__('Email','asl_locator') ?></option>
                            <option value="title"><?php echo esc_attr__('Title','asl_locator') ?></option>
                            <option value="phone"><?php echo esc_attr__('Phone','asl_locator') ?></option>
                            <option value="lat_lng"><?php echo esc_attr__('Coordinates','asl_locator') ?></option>
                          </select>
                        </div>
                        <p class="text-muted"><small><?php echo esc_attr__('It may slow import process for a large CSV file with 5k+ rows.','asl_locator') ?></small></p>
                      </div>
                      <div class="col-lg-6">
                        <div class="form-group sl-complx">
                          <label class="switch" for="asl-export-ids"><input type="checkbox" class="custom-control-input" id="asl-export-ids"><span class="slider round"></span></label>
                          <label for="asl-export-ids"><?php echo esc_attr__('Export with Store IDs (IDs are required for update)','asl_locator') ?></label>
                        </div>
                        <div class="form-group sl-complx">
                          <label class="switch" for="asl-logo-images"><input type="checkbox" class="custom-control-input" id="asl-logo-images"><span class="slider round"></span></label>
                          <label for="asl-logo-images"><?php echo esc_attr__('Export with Logo Images Path','asl_locator') ?>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
                <div class="table-responsive">
                <table id="tbl_stores" class="table table-bordered">
                    <thead>
                      <tr>        
                        <th align="center"><?php echo esc_attr__('File Name','asl_locator') ?></th>
                        <th align="center"><?php echo esc_attr__('Date','asl_locator') ?></th>
                        <th align="center"><?php echo esc_attr__('View','asl_locator') ?></th>
                        <th align="center"><?php echo esc_attr__('Import','asl_locator') ?></th>
                        <th align="center"><?php echo esc_attr__('Delete','asl_locator') ?></th>
                      </tr>
                    </thead>
                    <tbody>
                    <?php 
                    $dir    = ASL_PLUGIN_PATH.'public/import/';
                    $files  = scandir($dir);

if($files && is_array($files)) {

// Remove "." and ".." from the file list
                      $files = array_diff($files, array('.', '..'));

// Sort the file list by modification time in descending order
                      usort($files, function($a, $b) use ($dir) {
                          return filemtime($dir . '/' . $b) - filemtime($dir . '/' . $a);
                      });

foreach($files as $file):
                      ?>
                        <tr>
                        <td><?php echo esc_attr($file); ?></td>
                        <td><?php echo date("F d Y ",filemtime($dir.$file)); ?></td>
                        <td><a href="<?php echo ASL_URL_PATH.'public/import/'.$file ?>" class="btn btn-info"><i><svg width="13" height="13"><use xlink:href="#i-desktop"></use></svg></i><?php echo esc_attr__('Download','asl_locator') ?></a></td>
                        <td><button type="button" class="btn btn-primary btn-asl-import_store" data-loading-text="<?php echo esc_attr__('Importing...','asl_locator') ?>"  data-id="<?php echo $file;?>"><i><svg width="13" height="13"><use xlink:href="#i-import"></use></svg></i><?php echo esc_attr__('Import','asl_locator') ?></button></td>
                        <td><button type="button" class="btn btn-danger btn-asl-delete_import_file"  data-id="<?php echo esc_attr($file);?>"><i><svg width="13" height="13"><use xlink:href="#i-trash"></use></svg></i><?php echo esc_attr__('Delete','asl_locator') ?></button></td> 
                        <tr>
                    <?php
                      endforeach;
                    }
                    ?>
                  </tbody>
                </table>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>

<div class="smodal fade" id="import_store_file_emodel" role="dialog">
    <div class="smodal-dialog" role="document">
      <div class="smodal-content">
        <div class="smodal-header">
          <h5 class="smodal-title"><?php echo esc_attr__('Upload CSV File','asl_locator') ?></h5>
          <button type="button" class="close" data-dismiss="smodal" aria-label="Close">
            <span aria-hidden="true">&times;</span>
          </button>
        </div>
        <div class="smodal-body">
          <form id="import_store_file" name="import_store_file">
            <div class="row">
              <div class="col-md-12 form-group mb-3">
                <div class="input-group" id="drop-zone">
                  <div class="input-group-prepend">
                    <span class="input-group-text"><?php echo esc_attr__('File','asl_locator') ?></span>
                  </div>
                  <div class="custom-file">
                   <input type="file" class="btn btn-default" accept=".csv" style="width:98%;opacity:0;position:absolute;top:0;left:0"  name="files" id="file-logo-1" />
                    <label  class="custom-file-label" for="file-logo-1"><?php echo esc_attr__('File Path...','asl_locator') ?></label>
                  </div>
                </div>
              </div>
              <div class="col-md-12 form-group mb-3">
                <div class="progress hideelement" style="display:none" id="progress_bar_">
                  <div class="progress-bar" role="progressbar" aria-valuenow="60" aria-valuemin="0" aria-valuemax="100" style="width:0%;">
                    <span style="position:relative" class="sr-only">0% Complete</span>
                  </div>
                </div>
              </div>
              <div class="col-md-12">
                <ul></ul>
              </div>
              <p id="message_upload" class="alert alert-warning hide"></p>
              <div class="col-md-12 form-group mb-0">
                <button class="btn btn-primary float-right btn-start" type="button" data-loading-text="Submitting ..."><?php echo esc_attr__('Upload File','asl_locator') ?></button>
              </div>
            </div>
          </form>
        </div>
      </div>
    </div>
  </div>
      
</div>

<script type="text/javascript">
  var ASL_Instance = {
    admin: '<?php echo admin_url( 'admin-ajax.php' ).'?action=asl_ajax_handler&sl-action=export_file&asl-nounce='.wp_create_nonce('asl-nounce'); ?>',
    url: '<?php echo ASL_UPLOAD_URL ?>'
  };
  
  window.addEventListener("load", function() {
    asl_engine.pages.import_store();
  });
</script>

MR SKB