WordPress.org
Get WordPress

Plugin Directory

Changeset 3352905


Ignore:
Timestamp:
08/29/2025 10:20:13 PM (7 months ago)
Author:
wppluginboxdev
Message:

update files

Location:
stylish-google-sheet-reader
Files:
10 edited

Legend:

Unmodified
Added
Removed

  • stylish-google-sheet-reader/tags/5.1/Pages/all-sheets.php

    r3352836 r3352905  
    99
    1010<?php
     11global $sgsr_copy_msg;
     12
    1113if(isset($_GET['delete_sgsr'])){
    1214SGSR_RECORDS_DELETE($_GET['delete_sgsr']);
    … …  
    1820
    1921<div style="height: 20px;"></div>
     22<?php
     23if($sgsr_copy_msg !== ""){
     24echo '<p class="sgsr-green-msg">'.$sgsr_copy_msg.'</p>';
     25}
     26?>
    2027
    2128<table class="all_sgsr_list">
    … …  
    4552         <span btn="action-edit" sgsr-id="'.$data["no"].'"></span>
    4653         <span btn="action-delete" sgsr-id="'.$data["no"].'" sgsr-name="'.$data["sheet_name"].'"></span>
     54
     55         <span btn="action-copy" sgsr-id="'.$data["no"].'"></span>
    4756      </td>
    4857</tr>

  • stylish-google-sheet-reader/tags/5.1/action/admin-actions.php

    r3352836 r3352905  
    1717$sgsr_update_status = 0;
    1818if(isset($_POST['sgsr-update']) && $_POST['sgsr-update'] != "-1"){ // update
     19
    1920$sgsr_update_data = $_POST;
    2021$sgsr_debug_info = SGSR_RECORDS_UPDATE($_POST, $no = $_POST['sgsr-update']);
    … …  
    2324}
    2425
     26//======= copy sheet ========
     27$sgsr_copy_msg = '';
     28if(isset($_POST['sgsr-copy'])   ){
     29$row2copy = intval($_POST['sgsr-copy']);
     30sgsr_RECORDS_COPY($row2copy);
     31$sgsr_copy_msg = " ✔ Copy of data table is created";
     32}
     33//===========================
    2534
    2635//======= get table ========

  • stylish-google-sheet-reader/tags/5.1/action/functions.php

    r3352836 r3352905  
    162162    return array_map('trim', $array);
    163163}
     164
     165// function SGSR_TRIM($array) {
     166//     $trimmed = [];
     167//     foreach ($array as $key => $value) {
     168//         if (is_string($value)) {
     169//             $trimmed[$key] = trim($value);
     170//         } else {
     171//             // Leave arrays/objects untouched
     172//             $trimmed[$key] = $value;
     173//         }
     174//     }
     175//     return $trimmed;
     176// }
     177
    164178
    165179function SGSR_RECORDS_UPDATE($data, $no = null) {
    … …  
    272286
    273287
    274 
     288function sgsr_RECORDS_COPY($no) {
     289    global $wpdb;
     290    $table_name = $wpdb->prefix . "stylish_sgsr_v5";
     291
     292    // Fetch the existing row by "no"
     293    $row = $wpdb->get_row(
     294        $wpdb->prepare("SELECT * FROM $table_name WHERE no = %d", $no),
     295        ARRAY_A
     296    );
     297
     298    if (!$row) {
     299        return "Row with no=$no not found.";
     300    }
     301
     302    // Remove the primary key so WPDB can auto-increment
     303    unset($row['no']);
     304
     305    // Update sheet_name to "Copy of ..."
     306    if (!empty($row['sheet_name'])) {
     307        $row['sheet_name'] = "Copy of " . $row['sheet_name'];
     308    } else {
     309        $row['sheet_name'] = "Copy";
     310    }
     311
     312    // Assign new project_uid
     313    if (function_exists('SGSR_RANDOM_KEY')) {
     314        $row['project_uid'] = SGSR_RANDOM_KEY(16);
     315    }
     316
     317    // Insert the duplicated row
     318    $created = $wpdb->insert($table_name, $row);
     319
     320    if ($created !== false) {
     321        return [
     322            'status' => 1,
     323            'inserted_no' => $wpdb->insert_id,
     324            'copied_from' => $no
     325        ];
     326    } else {
     327        return "Error copying data: " . $wpdb->last_error;
     328    }
     329}
     330
     331
     332// sgsr_RECORDS_COPY(2);
    275333
    276334function sgsr_DELDB(){

  • stylish-google-sheet-reader/tags/5.1/production/admin.css

    r3352836 r3352905  
    186186    cursor: pointer;
    187187    font-size: 16px;
     188    color: red;
    188189
    189190}
    … …  
    196197cursor: pointer;
    197198font-size: 16px;
    198 }
     199color: red;
     200}
     201
     202[btn="action-copy"]:before{
     203content: "\f0c5 \00a0";
     204font-family: "Font Awesome 5 Pro";
     205font-weight: 500;
     206margin-right: 10px;
     207cursor: pointer;
     208font-size: 16px;
     209color: red;
     210}
     211
     212
    199213
    200214[btn="action-link"]:before{
    … …  
    206220}
    207221
    208 [btn="action-edit"]:hover,[btn="action-delete"]:hover,[btn="action-link"]:hover{
     222[btn="action-copy"]:before::hover,
     223[btn="action-edit"]:before::hover,
     224[btn="action-delete"]:before::hover,
     225[btn="action-link"]:before::hover{
    209226  transform: scale(1.2);
    210227  transition: 0.2s ease;
    211   color: red;
     228/*  color: red;*/
    212229}
    213230
    … …  
    487504    font-weight: 400;
    488505    text-decoration: underline;
     506}
     507
     508
     509.sgsr-main .sgsr-green-msg {
     510    padding: 8px 12px;
     511    border: 1px solid #4caf50;
     512    width: fit-content;
     513    background-color: #4caf501a;
     514    color: #4caf50;
     515    border-radius: 6px;
     516    font-weight: 400;
     517    margin: 18px auto;
    489518}
    490519/* ======= End: pages.css ======= */

  • stylish-google-sheet-reader/tags/5.1/production/admin.js

    r3352836 r3352905  
    1 function sgsr_get_parameter(e){const r=new URLSearchParams(window.location.search);return r.get(e)}function sgsr_remove_parameter(e){const r=new URL(window.location.href);r.searchParams.delete(e),window.history.replaceState({},document.title,r.toString())}function update_sgsr_checkbox(e,r){r=jQuery(r).prop("checked")?"1":"0";jQuery("select#"+e).val(r).trigger("change")}function update_sgsr_toogle_features(){jQuery('[parent-row] input[type="checkbox"]').each(function(e,r){var o=jQuery(this).prop("checked"),t=this.id;"slider-enable_paging"==t&&(o?(jQuery('[child-option="paging"][show-for="1"]').show(),jQuery('[child-option="paging"][show-for="0"]').hide()):(jQuery('[child-option="paging"][show-for="0"]').show(),jQuery('[child-option="paging"][show-for="1"]').hide())),"slider-enable_auto_refresh"==t&&(o?(jQuery('[child-option="refresh"][show-for="1"]').show(),jQuery('[child-option="refresh"][show-for="0"]').hide()):(jQuery('[child-option="refresh"][show-for="0"]').show(),jQuery('[child-option="refresh"][show-for="1"]').hide())),"slider-enable_cache"==t&&(o?(jQuery('[child-option="cache"][show-for="1"]').show(),jQuery('[child-option="cache"][show-for="0"]').hide()):(jQuery('[child-option="cache"][show-for="0"]').show(),jQuery('[child-option="cache"][show-for="1"]').hide())),"slider-enable_form"==t&&(o?(jQuery('[child-option="enable_form"][show-for="1"]').show(),jQuery("#submission_email").prop("required",!0)):(jQuery('[child-option="enable_form"][show-for="1"]').hide(),jQuery("#submission_email").prop("required",!1)))})}function wpbox_sgsr_nadd_sheets(){jQuery('button[type="submit"][data-action="add-db"]').prop("disabled",!0),jQuery('button[type="submit"][data-action="add-db"]').addClass("pro-btn").attr("sgsr-title","Enhance your access — upgrade to create unlimited tables.")}function sgsr_disable_pro_blocks(){jQuery(".sgsr-pro-feature").each(function(e,r){var o="This is a Pro feature — upgrade to enjoy full access. <br><br> ➡️ Purchase Pro or start a free trial to explore all premium features.",t=jQuery(this).closest("tr").find("td:nth-child(2)");t.find("input").prop("disabled",!0).attr("sgsr-title",o),t.find("label").addClass("sgsr-disabled").attr("sgsr-title",o),t.find("select").prop("disabled",!0).attr("sgsr-title",o)})}function sgsr_update_sheet_notify(e){window.open("?page=sgsr_manage_all_sheets&sgsr_updated="+e,"_self")}function sgsr_add_sheet_notify(e){window.open("?page=sgsr_manage_all_sheets&sgsr_added="+e,"_self")}function sgsr_control_toogles(e,r=!1){e=jQuery("#slider-"+e);e.prop("checked")===r||e.trigger("click")}function sgsr_refresh_conditions(){jQuery("#slider-enable_auto_refresh").prop("checked")?(jQuery('[sgsr-refresh-features-msg="1"]').show(),sgsr_control_toogles("enable_form",!1),sgsr_control_toogles("enable_cache",!1)):jQuery('[sgsr-refresh-features-msg="1"]').hide()}function creat_sgsr_options(e,r,o=""){for(var t='<option value="">- Select -</option>',s="",n=0;n<e.length;n++)""!=e[n]&&(e[n]==o&&(s="selected"),t+='<option value="'+e[n]+'" '+s+">"+e[n]+"</option>");r=jQuery("#"+r),s=r.val();r.html(t),e.includes(s)&&r.val(s)}function sgsr_sheet_data(){var e=jQuery("#sgsr-sheet").val();if(console.log(e),!e.includes("https://")&&!e.includes("http://"))return alert("Invalid google sheet url. \n\n Your google sheet url should look like: https://docs.google.com/spreadsheets/d/1rssdz-mVK-kCu9Dcu1f2KOR"),0;sgsr_show_popup_msg("sheet-fetching");e="gsheet-url="+e;jQuery.ajax({url:"https://apps.wppluginbox.com/sgsr/fetch-sheet/index.php",type:"POST",data:e,cache:!1}).done(function(e){jQuery(".fetch-g-sheet").hide(),console.log(e);var r=JSON.parse(e);r.error_code;"0"==r.error_code&&(sgsr_show_popup_msg("sheet-fetching-success"),setTimeout(function(){close_sgsr_popup(),jQuery("#sheet_name").val(r.sheet_title),jQuery("#sheet_id").val(r.sheet_id),creat_sgsr_options(r.sheet_names,"tab_name")},2e3)),"1"==r.error_code&&sgsr_show_popup_msg("sheet-fetch-error")})}function sgsr_set_field_defaults(e,r){var o,t,s=jQuery('[name="'+e+'"]');s.length&&(s.is(":checkbox")?s.prop("checked","1"==r):s.is("select")?(0===s.find('option[value="'+r+'"]').length&&s.append(jQuery("<option>",{value:r,text:r})),s.val(r),"1"===s.attr("has-toogle-btn")&&(o="1"===r,(t=jQuery("#slider-"+e)).length&&t.prop("checked",o).trigger("change")),"theme"==e&&jQuery('[select-menu="theme"]').find('[data-value="'+r+'"]').trigger("click")):s.val(r),s.trigger("change"))}function enable_sgsr_update_btn(){jQuery("#add-SGSR-sheet").hide(),jQuery('[data-action="update-db"]').show(),jQuery('[name="sgsr-update"]').val(sgsr_get_parameter("edit_sgsr"))}function wpbox_sgsr_show_popup_msg(e){var r="sgsr_hide_msg_"+e,o="sgsr_last_shown_"+e;const t=Date.now();"1"!==localStorage.getItem(r)?(r=parseInt(localStorage.getItem(o),10),!isNaN(r)&&t-r<12e4&&console.log("msg_id "+e+" shown recently, skipping"),localStorage.setItem(o,t.toString()),jQuery(".wpbox_sgsr-popup [wpbox_sgsr_msg_id]").hide(),jQuery('[wpbox_sgsr_msg_id="'+e+'"]').show(),open_wpbox_sgsr_popup()):console.log("msg_id "+e+" is hidden permanently")}function open_wpbox_sgsr_popup(){console.log("opening..."),document.getElementById("wpbox_sgsr-popup").style.display="block",document.getElementById("wpbox_sgsr-popup-Overlay").style.display="block"}function close_wpbox_sgsr_popup(){document.getElementById("wpbox_sgsr-popup").style.display="none",document.getElementById("wpbox_sgsr-popup-Overlay").style.display="none"}function sgsr_form_save_2_json(){let o=[];document.querySelectorAll("tbody#sgsr-form-settings tr").forEach((e,r)=>{r+=1;o.push({label:e.querySelector("[id='form_field_"+r+"']").value.trim(),placeholder:e.querySelector("[id='form_field_"+r+"_placeholder']").value.trim(),enabled:e.querySelector("[id='enable_form_field_"+r+"']").value,required:e.querySelector("[id='form_field_"+r+"_required']").value})}),document.getElementById("form_fields").value=JSON.stringify(o)}function sgsr_json_to_form(r=""){if("{}"==r||""==r||null==r)return console.log("inv_json:",r),0;let e=[];try{if("string"==typeof r)r=jQuery("<textarea/>").html(r).text(),e=JSON.parse(r);else{if(!Array.isArray(r))return console.warn("Unsupported input type:",typeof r),0;e=r}e.forEach((e,r)=>{r+=1;let o=document.getElementById("form_field_"+r);o&&(o.value=e.label||"");let t=document.getElementById("form_field_"+r+"_placeholder");t&&(t.value=e.placeholder||"");let s=document.getElementById("form_field_"+r+"_required");s&&(s.value=e.required||0);let n=jQuery("#slider-enable_form_field_"+r);n.length&&(e="1"==e.enabled||!0===e.enabled,n.prop("checked",e).trigger("change"))})}catch(e){console.error("Invalid JSON passed to sgsr_json_to_form:",e,r)}}jQuery(document).on("click",'[btn="action-edit"]',function(){var e="?page=sgsr_create_new&edit_sgsr="+jQuery(this).attr("sgsr-id");window.open(e,"_self")}),jQuery(document).on("click",'[btn="action-delete"]',function(){var e=jQuery(this).attr("sgsr-id"),r=jQuery(this).attr("sgsr-name");confirm('Are you sure, you want to delete "'+r+'"?')&&(e="?page=sgsr_manage_all_sheets&delete_sgsr="+e,window.open(e,"_self"))}),jQuery(document).on("click","[data-url]",function(){var e=jQuery(this).attr("data-url");if("-"==e||""==e)return console.log("invalid_link"),0;e="https://docs.google.com/spreadsheets/d/"+e,window.open(e,"_blank")}),jQuery(document).on("click",'[parent-row] input[type="checkbox"]',function(){update_sgsr_toogle_features()}),jQuery(document).ready(function(){update_sgsr_toogle_features()}),jQuery(document).on("change","#range",function(){var e=jQuery(this).val().toUpperCase();jQuery(this).val(e)}),jQuery(document).ready(function(){jQuery(".sgsr-checkbox").trigger("change")}),jQuery(document).on("click",".sgsr-choose-btn",function(){var e=jQuery(this).closest(".sgsr-row-box");e.find(".sgsr-choose-btn").removeClass("sgsr-checked");var r=e.attr("select-menu"),e=jQuery(this).attr("data-value");jQuery(this).addClass("sgsr-checked"),jQuery("#"+r).val(e),"white"==e?jQuery('[child-theme-option="white"]').show():jQuery('[child-theme-option="white"]').hide()}),jQuery(document).ready(function(){null===sgsr_get_parameter("edit_sgsr")&&jQuery('[data-value="white"]').trigger("click")}),jQuery(document).ready(function(e){jQuery(".color-val").each(function(){const e=jQuery(this);var r=e.attr("id");const o=jQuery("#display-"+r);o.val(e.val())}),jQuery(document).on("input",".sgsr-main .color-val",function(){var e=jQuery(this).attr("id");jQuery("#display-"+e).val(jQuery(this).val())}),jQuery(document).on("input",".sgsr-main .sgsr-color-code",function(){var e=jQuery(this).attr("id").replace("display-","");jQuery("#"+e).val(jQuery(this).val())})}),jQuery(document).on("click",'[show-sgsr-info="cache"]',function(){jQuery('[sgsr-info-box="cache"]').toggle()}),jQuery(document).ready(function(){jQuery(document).tooltip({tooltipClass:"sgsr-tooltip",items:"[sgsr-title]",content:function(){return jQuery(this).attr("sgsr-title")}})}),jQuery(document).on("change","#slider-enable_auto_refresh",function(){sgsr_refresh_conditions()}),jQuery(document).on("change","#slider-enable_form,#slider-enable_cache",function(){sgsr_control_toogles("enable_auto_refresh",!1)}),jQuery(document).on("change","#slider-enable_form",function(){sgsr_control_toogles("enable_row_selection",!0)}),jQuery(document).on("click",'[sgsr-action="fetch-sheet"], .sgsr-fetch-settings',function(){sgsr_sheet_data()}),jQuery(document).on("change",'[popup-hide-opt="1"]',function(){var e=jQuery(this).closest("[wpbox_sgsr_msg_id]").attr("wpbox_sgsr_msg_id");this.checked?(localStorage.setItem("sgsr_hide_msg_"+e,"1"),console.log("Stored in localStorage: sgsr_hide_msg_"+e)):(localStorage.removeItem("sgsr_hide_msg_"+e),console.log("Removed from localStorage: sgsr_hide_msg_"+e))}),jQuery(document).on("change","#sgsr-form-settings input,#sgsr-form-settings select",function(){sgsr_form_save_2_json()}),jQuery(document).ready(function(){});
     1function sgsr_get_parameter(e){const r=new URLSearchParams(window.location.search);return r.get(e)}function sgsr_remove_parameter(e){const r=new URL(window.location.href);r.searchParams.delete(e),window.history.replaceState({},document.title,r.toString())}function update_sgsr_checkbox(e,r){r=jQuery(r).prop("checked")?"1":"0";jQuery("select#"+e).val(r).trigger("change")}function update_sgsr_toogle_features(){jQuery('[parent-row] input[type="checkbox"]').each(function(e,r){var o=jQuery(this).prop("checked"),t=this.id;"slider-enable_paging"==t&&(o?(jQuery('[child-option="paging"][show-for="1"]').show(),jQuery('[child-option="paging"][show-for="0"]').hide()):(jQuery('[child-option="paging"][show-for="0"]').show(),jQuery('[child-option="paging"][show-for="1"]').hide())),"slider-enable_auto_refresh"==t&&(o?(jQuery('[child-option="refresh"][show-for="1"]').show(),jQuery('[child-option="refresh"][show-for="0"]').hide()):(jQuery('[child-option="refresh"][show-for="0"]').show(),jQuery('[child-option="refresh"][show-for="1"]').hide())),"slider-enable_cache"==t&&(o?(jQuery('[child-option="cache"][show-for="1"]').show(),jQuery('[child-option="cache"][show-for="0"]').hide()):(jQuery('[child-option="cache"][show-for="0"]').show(),jQuery('[child-option="cache"][show-for="1"]').hide())),"slider-enable_form"==t&&(o?(jQuery('[child-option="enable_form"][show-for="1"]').show(),jQuery("#submission_email").prop("required",!0)):(jQuery('[child-option="enable_form"][show-for="1"]').hide(),jQuery("#submission_email").prop("required",!1)))})}function wpbox_sgsr_nadd_sheets(){jQuery('button[type="submit"][data-action="add-db"]').prop("disabled",!0),jQuery('button[type="submit"][data-action="add-db"]').addClass("pro-btn").attr("sgsr-title","Enhance your access — upgrade to create unlimited tables.")}function sgsr_disable_pro_blocks(){jQuery(".sgsr-pro-feature").each(function(e,r){var o="This is a Pro feature — upgrade to enjoy full access. <br><br> ➡️ Purchase Pro or start a free trial to explore all premium features.",t=jQuery(this).closest("tr").find("td:nth-child(2)");t.find("input").prop("disabled",!0).attr("sgsr-title",o),t.find("label").addClass("sgsr-disabled").attr("sgsr-title",o),t.find("select").prop("disabled",!0).attr("sgsr-title",o)})}function sgsr_update_sheet_notify(e){window.open("?page=sgsr_manage_all_sheets&sgsr_updated="+e,"_self")}function sgsr_add_sheet_notify(e){window.open("?page=sgsr_manage_all_sheets&sgsr_added="+e,"_self")}function sgsr_control_toogles(e,r=!1){e=jQuery("#slider-"+e);e.prop("checked")===r||e.trigger("click")}function sgsr_refresh_conditions(){jQuery("#slider-enable_auto_refresh").prop("checked")?(jQuery('[sgsr-refresh-features-msg="1"]').show(),sgsr_control_toogles("enable_form",!1),sgsr_control_toogles("enable_cache",!1)):jQuery('[sgsr-refresh-features-msg="1"]').hide()}function creat_sgsr_options(e,r,o=""){for(var t='<option value="">- Select -</option>',s="",n=0;n<e.length;n++)""!=e[n]&&(e[n]==o&&(s="selected"),t+='<option value="'+e[n]+'" '+s+">"+e[n]+"</option>");r=jQuery("#"+r),s=r.val();r.html(t),e.includes(s)&&r.val(s)}function sgsr_sheet_data(){var e=jQuery("#sgsr-sheet").val();if(console.log(e),!e.includes("https://")&&!e.includes("http://"))return alert("Invalid google sheet url. \n\n Your google sheet url should look like: https://docs.google.com/spreadsheets/d/1rssdz-mVK-kCu9Dcu1f2KOR"),0;sgsr_show_popup_msg("sheet-fetching");e="gsheet-url="+e;jQuery.ajax({url:"https://apps.wppluginbox.com/sgsr/fetch-sheet/index.php",type:"POST",data:e,cache:!1}).done(function(e){jQuery(".fetch-g-sheet").hide(),console.log(e);var r=JSON.parse(e);r.error_code;"0"==r.error_code&&(sgsr_show_popup_msg("sheet-fetching-success"),setTimeout(function(){close_sgsr_popup(),jQuery("#sheet_name").val(r.sheet_title),jQuery("#sheet_id").val(r.sheet_id),creat_sgsr_options(r.sheet_names,"tab_name")},2e3)),"1"==r.error_code&&sgsr_show_popup_msg("sheet-fetch-error")})}function sgsr_set_field_defaults(e,r){var o,t,s=jQuery('[name="'+e+'"]');s.length&&(s.is(":checkbox")?s.prop("checked","1"==r):s.is("select")?(0===s.find('option[value="'+r+'"]').length&&s.append(jQuery("<option>",{value:r,text:r})),s.val(r),"1"===s.attr("has-toogle-btn")&&(o="1"===r,(t=jQuery("#slider-"+e)).length&&t.prop("checked",o).trigger("change")),"theme"==e&&jQuery('[select-menu="theme"]').find('[data-value="'+r+'"]').trigger("click")):s.val(r),s.trigger("change"))}function enable_sgsr_update_btn(){jQuery("#add-SGSR-sheet").hide(),jQuery('[data-action="update-db"]').show(),jQuery('[name="sgsr-update"]').val(sgsr_get_parameter("edit_sgsr"))}function wpbox_sgsr_show_popup_msg(e){var r="sgsr_hide_msg_"+e,o="sgsr_last_shown_"+e;const t=Date.now();"1"!==localStorage.getItem(r)?(r=parseInt(localStorage.getItem(o),10),!isNaN(r)&&t-r<12e4&&console.log("msg_id "+e+" shown recently, skipping"),localStorage.setItem(o,t.toString()),jQuery(".wpbox_sgsr-popup [wpbox_sgsr_msg_id]").hide(),jQuery('[wpbox_sgsr_msg_id="'+e+'"]').show(),open_wpbox_sgsr_popup()):console.log("msg_id "+e+" is hidden permanently")}function open_wpbox_sgsr_popup(){console.log("opening..."),document.getElementById("wpbox_sgsr-popup").style.display="block",document.getElementById("wpbox_sgsr-popup-Overlay").style.display="block"}function close_wpbox_sgsr_popup(){document.getElementById("wpbox_sgsr-popup").style.display="none",document.getElementById("wpbox_sgsr-popup-Overlay").style.display="none"}function sgsr_form_save_2_json(){let o=[];document.querySelectorAll("tbody#sgsr-form-settings tr").forEach((e,r)=>{r+=1;o.push({label:e.querySelector("[id='form_field_"+r+"']").value.trim(),placeholder:e.querySelector("[id='form_field_"+r+"_placeholder']").value.trim(),enabled:e.querySelector("[id='enable_form_field_"+r+"']").value,required:e.querySelector("[id='form_field_"+r+"_required']").value})}),document.getElementById("form_fields").value=JSON.stringify(o)}function sgsr_json_to_form(r=""){if("{}"==r||""==r||null==r)return console.log("inv_json:",r),0;let e=[];try{if("string"==typeof r)r=jQuery("<textarea/>").html(r).text(),e=JSON.parse(r);else{if(!Array.isArray(r))return console.warn("Unsupported input type:",typeof r),0;e=r}e.forEach((e,r)=>{r+=1;let o=document.getElementById("form_field_"+r);o&&(o.value=e.label||"");let t=document.getElementById("form_field_"+r+"_placeholder");t&&(t.value=e.placeholder||"");let s=document.getElementById("form_field_"+r+"_required");s&&(s.value=e.required||0);let n=jQuery("#slider-enable_form_field_"+r);n.length&&(e="1"==e.enabled||!0===e.enabled,n.prop("checked",e).trigger("change"))})}catch(e){console.error("Invalid JSON passed to sgsr_json_to_form:",e,r)}}jQuery(document).on("click",'[btn="action-edit"]',function(){var e="?page=sgsr_create_new&edit_sgsr="+jQuery(this).attr("sgsr-id");window.open(e,"_self")}),jQuery(document).on("click",'[btn="action-delete"]',function(){var e=jQuery(this).attr("sgsr-id"),r=jQuery(this).attr("sgsr-name");confirm('Are you sure, you want to delete "'+r+'"?')&&(e="?page=sgsr_manage_all_sheets&delete_sgsr="+e,window.open(e,"_self"))}),jQuery(document).on("click",'[btn="action-copy"]',function(){var e=jQuery(this).attr("sgsr-id"),r=jQuery("<form>",{method:"POST",action:"?page=sgsr_manage_all_sheets"});r.append(jQuery("<input>",{type:"hidden",name:"sgsr-copy",value:e})),jQuery("body").append(r),r.submit()}),jQuery(document).on("click","[data-url]",function(){var e=jQuery(this).attr("data-url");if("-"==e||""==e)return console.log("invalid_link"),0;e="https://docs.google.com/spreadsheets/d/"+e,window.open(e,"_blank")}),jQuery(document).on("click",'[parent-row] input[type="checkbox"]',function(){update_sgsr_toogle_features()}),jQuery(document).ready(function(){update_sgsr_toogle_features()}),jQuery(document).on("change","#range",function(){var e=jQuery(this).val().toUpperCase();jQuery(this).val(e)}),jQuery(document).ready(function(){jQuery(".sgsr-checkbox").trigger("change")}),jQuery(document).on("click",".sgsr-choose-btn",function(){var e=jQuery(this).closest(".sgsr-row-box");e.find(".sgsr-choose-btn").removeClass("sgsr-checked");var r=e.attr("select-menu"),e=jQuery(this).attr("data-value");jQuery(this).addClass("sgsr-checked"),jQuery("#"+r).val(e),"white"==e?jQuery('[child-theme-option="white"]').show():jQuery('[child-theme-option="white"]').hide()}),jQuery(document).ready(function(){null===sgsr_get_parameter("edit_sgsr")&&jQuery('[data-value="white"]').trigger("click")}),jQuery(document).ready(function(e){jQuery(".color-val").each(function(){const e=jQuery(this);var r=e.attr("id");const o=jQuery("#display-"+r);o.val(e.val())}),jQuery(document).on("input",".sgsr-main .color-val",function(){var e=jQuery(this).attr("id");jQuery("#display-"+e).val(jQuery(this).val())}),jQuery(document).on("input",".sgsr-main .sgsr-color-code",function(){var e=jQuery(this).attr("id").replace("display-","");jQuery("#"+e).val(jQuery(this).val())})}),jQuery(document).on("click",'[show-sgsr-info="cache"]',function(){jQuery('[sgsr-info-box="cache"]').toggle()}),jQuery(document).ready(function(){jQuery(document).tooltip({tooltipClass:"sgsr-tooltip",items:"[sgsr-title]",content:function(){return jQuery(this).attr("sgsr-title")}})}),jQuery(document).on("change","#slider-enable_auto_refresh",function(){sgsr_refresh_conditions()}),jQuery(document).on("change","#slider-enable_form,#slider-enable_cache",function(){sgsr_control_toogles("enable_auto_refresh",!1)}),jQuery(document).on("change","#slider-enable_form",function(){sgsr_control_toogles("enable_row_selection",!0)}),jQuery(document).on("click",'[sgsr-action="fetch-sheet"], .sgsr-fetch-settings',function(){sgsr_sheet_data()}),jQuery(document).on("change",'[popup-hide-opt="1"]',function(){var e=jQuery(this).closest("[wpbox_sgsr_msg_id]").attr("wpbox_sgsr_msg_id");this.checked?(localStorage.setItem("sgsr_hide_msg_"+e,"1"),console.log("Stored in localStorage: sgsr_hide_msg_"+e)):(localStorage.removeItem("sgsr_hide_msg_"+e),console.log("Removed from localStorage: sgsr_hide_msg_"+e))}),jQuery(document).on("change","#sgsr-form-settings input,#sgsr-form-settings select",function(){sgsr_form_save_2_json()}),jQuery(document).ready(function(){});

  • stylish-google-sheet-reader/trunk/Pages/all-sheets.php

    r3340465 r3352905  
    99
    1010<?php
     11global $sgsr_copy_msg;
     12
    1113if(isset($_GET['delete_sgsr'])){
    1214SGSR_RECORDS_DELETE($_GET['delete_sgsr']);
    … …  
    1820
    1921<div style="height: 20px;"></div>
     22<?php
     23if($sgsr_copy_msg !== ""){
     24echo '<p class="sgsr-green-msg">'.$sgsr_copy_msg.'</p>';
     25}
     26?>
    2027
    2128<table class="all_sgsr_list">
    … …  
    4552         <span btn="action-edit" sgsr-id="'.$data["no"].'"></span>
    4653         <span btn="action-delete" sgsr-id="'.$data["no"].'" sgsr-name="'.$data["sheet_name"].'"></span>
     54
     55         <span btn="action-copy" sgsr-id="'.$data["no"].'"></span>
    4756      </td>
    4857</tr>

  • stylish-google-sheet-reader/trunk/action/admin-actions.php

    r3338275 r3352905  
    1717$sgsr_update_status = 0;
    1818if(isset($_POST['sgsr-update']) && $_POST['sgsr-update'] != "-1"){ // update
     19
    1920$sgsr_update_data = $_POST;
    2021$sgsr_debug_info = SGSR_RECORDS_UPDATE($_POST, $no = $_POST['sgsr-update']);
    … …  
    2324}
    2425
     26//======= copy sheet ========
     27$sgsr_copy_msg = '';
     28if(isset($_POST['sgsr-copy'])   ){
     29$row2copy = intval($_POST['sgsr-copy']);
     30sgsr_RECORDS_COPY($row2copy);
     31$sgsr_copy_msg = " ✔ Copy of data table is created";
     32}
     33//===========================
    2534
    2635//======= get table ========

  • stylish-google-sheet-reader/trunk/action/functions.php

    r3338275 r3352905  
    162162    return array_map('trim', $array);
    163163}
     164
     165// function SGSR_TRIM($array) {
     166//     $trimmed = [];
     167//     foreach ($array as $key => $value) {
     168//         if (is_string($value)) {
     169//             $trimmed[$key] = trim($value);
     170//         } else {
     171//             // Leave arrays/objects untouched
     172//             $trimmed[$key] = $value;
     173//         }
     174//     }
     175//     return $trimmed;
     176// }
     177
    164178
    165179function SGSR_RECORDS_UPDATE($data, $no = null) {
    … …  
    272286
    273287
    274 
     288function sgsr_RECORDS_COPY($no) {
     289    global $wpdb;
     290    $table_name = $wpdb->prefix . "stylish_sgsr_v5";
     291
     292    // Fetch the existing row by "no"
     293    $row = $wpdb->get_row(
     294        $wpdb->prepare("SELECT * FROM $table_name WHERE no = %d", $no),
     295        ARRAY_A
     296    );
     297
     298    if (!$row) {
     299        return "Row with no=$no not found.";
     300    }
     301
     302    // Remove the primary key so WPDB can auto-increment
     303    unset($row['no']);
     304
     305    // Update sheet_name to "Copy of ..."
     306    if (!empty($row['sheet_name'])) {
     307        $row['sheet_name'] = "Copy of " . $row['sheet_name'];
     308    } else {
     309        $row['sheet_name'] = "Copy";
     310    }
     311
     312    // Assign new project_uid
     313    if (function_exists('SGSR_RANDOM_KEY')) {
     314        $row['project_uid'] = SGSR_RANDOM_KEY(16);
     315    }
     316
     317    // Insert the duplicated row
     318    $created = $wpdb->insert($table_name, $row);
     319
     320    if ($created !== false) {
     321        return [
     322            'status' => 1,
     323            'inserted_no' => $wpdb->insert_id,
     324            'copied_from' => $no
     325        ];
     326    } else {
     327        return "Error copying data: " . $wpdb->last_error;
     328    }
     329}
     330
     331
     332// sgsr_RECORDS_COPY(2);
    275333
    276334function sgsr_DELDB(){

  • stylish-google-sheet-reader/trunk/production/admin.css

    r3352836 r3352905  
    186186    cursor: pointer;
    187187    font-size: 16px;
     188    color: red;
    188189
    189190}
    … …  
    196197cursor: pointer;
    197198font-size: 16px;
    198 }
     199color: red;
     200}
     201
     202[btn="action-copy"]:before{
     203content: "\f0c5 \00a0";
     204font-family: "Font Awesome 5 Pro";
     205font-weight: 500;
     206margin-right: 10px;
     207cursor: pointer;
     208font-size: 16px;
     209color: red;
     210}
     211
     212
    199213
    200214[btn="action-link"]:before{
    … …  
    206220}
    207221
    208 [btn="action-edit"]:hover,[btn="action-delete"]:hover,[btn="action-link"]:hover{
     222[btn="action-copy"]:before::hover,
     223[btn="action-edit"]:before::hover,
     224[btn="action-delete"]:before::hover,
     225[btn="action-link"]:before::hover{
    209226  transform: scale(1.2);
    210227  transition: 0.2s ease;
    211   color: red;
     228/*  color: red;*/
    212229}
    213230
    … …  
    487504    font-weight: 400;
    488505    text-decoration: underline;
     506}
     507
     508
     509.sgsr-main .sgsr-green-msg {
     510    padding: 8px 12px;
     511    border: 1px solid #4caf50;
     512    width: fit-content;
     513    background-color: #4caf501a;
     514    color: #4caf50;
     515    border-radius: 6px;
     516    font-weight: 400;
     517    margin: 18px auto;
    489518}
    490519/* ======= End: pages.css ======= */

  • stylish-google-sheet-reader/trunk/production/admin.js

    r3352836 r3352905  
    1 function sgsr_get_parameter(e){const r=new URLSearchParams(window.location.search);return r.get(e)}function sgsr_remove_parameter(e){const r=new URL(window.location.href);r.searchParams.delete(e),window.history.replaceState({},document.title,r.toString())}function update_sgsr_checkbox(e,r){r=jQuery(r).prop("checked")?"1":"0";jQuery("select#"+e).val(r).trigger("change")}function update_sgsr_toogle_features(){jQuery('[parent-row] input[type="checkbox"]').each(function(e,r){var o=jQuery(this).prop("checked"),t=this.id;"slider-enable_paging"==t&&(o?(jQuery('[child-option="paging"][show-for="1"]').show(),jQuery('[child-option="paging"][show-for="0"]').hide()):(jQuery('[child-option="paging"][show-for="0"]').show(),jQuery('[child-option="paging"][show-for="1"]').hide())),"slider-enable_auto_refresh"==t&&(o?(jQuery('[child-option="refresh"][show-for="1"]').show(),jQuery('[child-option="refresh"][show-for="0"]').hide()):(jQuery('[child-option="refresh"][show-for="0"]').show(),jQuery('[child-option="refresh"][show-for="1"]').hide())),"slider-enable_cache"==t&&(o?(jQuery('[child-option="cache"][show-for="1"]').show(),jQuery('[child-option="cache"][show-for="0"]').hide()):(jQuery('[child-option="cache"][show-for="0"]').show(),jQuery('[child-option="cache"][show-for="1"]').hide())),"slider-enable_form"==t&&(o?(jQuery('[child-option="enable_form"][show-for="1"]').show(),jQuery("#submission_email").prop("required",!0)):(jQuery('[child-option="enable_form"][show-for="1"]').hide(),jQuery("#submission_email").prop("required",!1)))})}function wpbox_sgsr_nadd_sheets(){jQuery('button[type="submit"][data-action="add-db"]').prop("disabled",!0),jQuery('button[type="submit"][data-action="add-db"]').addClass("pro-btn").attr("sgsr-title","Enhance your access — upgrade to create unlimited tables.")}function sgsr_disable_pro_blocks(){jQuery(".sgsr-pro-feature").each(function(e,r){var o="This is a Pro feature — upgrade to enjoy full access. <br><br> ➡️ Purchase Pro or start a free trial to explore all premium features.",t=jQuery(this).closest("tr").find("td:nth-child(2)");t.find("input").prop("disabled",!0).attr("sgsr-title",o),t.find("label").addClass("sgsr-disabled").attr("sgsr-title",o),t.find("select").prop("disabled",!0).attr("sgsr-title",o)})}function sgsr_update_sheet_notify(e){window.open("?page=sgsr_manage_all_sheets&sgsr_updated="+e,"_self")}function sgsr_add_sheet_notify(e){window.open("?page=sgsr_manage_all_sheets&sgsr_added="+e,"_self")}function sgsr_control_toogles(e,r=!1){e=jQuery("#slider-"+e);e.prop("checked")===r||e.trigger("click")}function sgsr_refresh_conditions(){jQuery("#slider-enable_auto_refresh").prop("checked")?(jQuery('[sgsr-refresh-features-msg="1"]').show(),sgsr_control_toogles("enable_form",!1),sgsr_control_toogles("enable_cache",!1)):jQuery('[sgsr-refresh-features-msg="1"]').hide()}function creat_sgsr_options(e,r,o=""){for(var t='<option value="">- Select -</option>',s="",n=0;n<e.length;n++)""!=e[n]&&(e[n]==o&&(s="selected"),t+='<option value="'+e[n]+'" '+s+">"+e[n]+"</option>");r=jQuery("#"+r),s=r.val();r.html(t),e.includes(s)&&r.val(s)}function sgsr_sheet_data(){var e=jQuery("#sgsr-sheet").val();if(console.log(e),!e.includes("https://")&&!e.includes("http://"))return alert("Invalid google sheet url. \n\n Your google sheet url should look like: https://docs.google.com/spreadsheets/d/1rssdz-mVK-kCu9Dcu1f2KOR"),0;sgsr_show_popup_msg("sheet-fetching");e="gsheet-url="+e;jQuery.ajax({url:"https://apps.wppluginbox.com/sgsr/fetch-sheet/index.php",type:"POST",data:e,cache:!1}).done(function(e){jQuery(".fetch-g-sheet").hide(),console.log(e);var r=JSON.parse(e);r.error_code;"0"==r.error_code&&(sgsr_show_popup_msg("sheet-fetching-success"),setTimeout(function(){close_sgsr_popup(),jQuery("#sheet_name").val(r.sheet_title),jQuery("#sheet_id").val(r.sheet_id),creat_sgsr_options(r.sheet_names,"tab_name")},2e3)),"1"==r.error_code&&sgsr_show_popup_msg("sheet-fetch-error")})}function sgsr_set_field_defaults(e,r){var o,t,s=jQuery('[name="'+e+'"]');s.length&&(s.is(":checkbox")?s.prop("checked","1"==r):s.is("select")?(0===s.find('option[value="'+r+'"]').length&&s.append(jQuery("<option>",{value:r,text:r})),s.val(r),"1"===s.attr("has-toogle-btn")&&(o="1"===r,(t=jQuery("#slider-"+e)).length&&t.prop("checked",o).trigger("change")),"theme"==e&&jQuery('[select-menu="theme"]').find('[data-value="'+r+'"]').trigger("click")):s.val(r),s.trigger("change"))}function enable_sgsr_update_btn(){jQuery("#add-SGSR-sheet").hide(),jQuery('[data-action="update-db"]').show(),jQuery('[name="sgsr-update"]').val(sgsr_get_parameter("edit_sgsr"))}function wpbox_sgsr_show_popup_msg(e){var r="sgsr_hide_msg_"+e,o="sgsr_last_shown_"+e;const t=Date.now();"1"!==localStorage.getItem(r)?(r=parseInt(localStorage.getItem(o),10),!isNaN(r)&&t-r<12e4&&console.log("msg_id "+e+" shown recently, skipping"),localStorage.setItem(o,t.toString()),jQuery(".wpbox_sgsr-popup [wpbox_sgsr_msg_id]").hide(),jQuery('[wpbox_sgsr_msg_id="'+e+'"]').show(),open_wpbox_sgsr_popup()):console.log("msg_id "+e+" is hidden permanently")}function open_wpbox_sgsr_popup(){console.log("opening..."),document.getElementById("wpbox_sgsr-popup").style.display="block",document.getElementById("wpbox_sgsr-popup-Overlay").style.display="block"}function close_wpbox_sgsr_popup(){document.getElementById("wpbox_sgsr-popup").style.display="none",document.getElementById("wpbox_sgsr-popup-Overlay").style.display="none"}function sgsr_form_save_2_json(){let o=[];document.querySelectorAll("tbody#sgsr-form-settings tr").forEach((e,r)=>{r+=1;o.push({label:e.querySelector("[id='form_field_"+r+"']").value.trim(),placeholder:e.querySelector("[id='form_field_"+r+"_placeholder']").value.trim(),enabled:e.querySelector("[id='enable_form_field_"+r+"']").value,required:e.querySelector("[id='form_field_"+r+"_required']").value})}),document.getElementById("form_fields").value=JSON.stringify(o)}function sgsr_json_to_form(r=""){if("{}"==r||""==r||null==r)return console.log("inv_json:",r),0;let e=[];try{if("string"==typeof r)r=jQuery("<textarea/>").html(r).text(),e=JSON.parse(r);else{if(!Array.isArray(r))return console.warn("Unsupported input type:",typeof r),0;e=r}e.forEach((e,r)=>{r+=1;let o=document.getElementById("form_field_"+r);o&&(o.value=e.label||"");let t=document.getElementById("form_field_"+r+"_placeholder");t&&(t.value=e.placeholder||"");let s=document.getElementById("form_field_"+r+"_required");s&&(s.value=e.required||0);let n=jQuery("#slider-enable_form_field_"+r);n.length&&(e="1"==e.enabled||!0===e.enabled,n.prop("checked",e).trigger("change"))})}catch(e){console.error("Invalid JSON passed to sgsr_json_to_form:",e,r)}}jQuery(document).on("click",'[btn="action-edit"]',function(){var e="?page=sgsr_create_new&edit_sgsr="+jQuery(this).attr("sgsr-id");window.open(e,"_self")}),jQuery(document).on("click",'[btn="action-delete"]',function(){var e=jQuery(this).attr("sgsr-id"),r=jQuery(this).attr("sgsr-name");confirm('Are you sure, you want to delete "'+r+'"?')&&(e="?page=sgsr_manage_all_sheets&delete_sgsr="+e,window.open(e,"_self"))}),jQuery(document).on("click","[data-url]",function(){var e=jQuery(this).attr("data-url");if("-"==e||""==e)return console.log("invalid_link"),0;e="https://docs.google.com/spreadsheets/d/"+e,window.open(e,"_blank")}),jQuery(document).on("click",'[parent-row] input[type="checkbox"]',function(){update_sgsr_toogle_features()}),jQuery(document).ready(function(){update_sgsr_toogle_features()}),jQuery(document).on("change","#range",function(){var e=jQuery(this).val().toUpperCase();jQuery(this).val(e)}),jQuery(document).ready(function(){jQuery(".sgsr-checkbox").trigger("change")}),jQuery(document).on("click",".sgsr-choose-btn",function(){var e=jQuery(this).closest(".sgsr-row-box");e.find(".sgsr-choose-btn").removeClass("sgsr-checked");var r=e.attr("select-menu"),e=jQuery(this).attr("data-value");jQuery(this).addClass("sgsr-checked"),jQuery("#"+r).val(e),"white"==e?jQuery('[child-theme-option="white"]').show():jQuery('[child-theme-option="white"]').hide()}),jQuery(document).ready(function(){null===sgsr_get_parameter("edit_sgsr")&&jQuery('[data-value="white"]').trigger("click")}),jQuery(document).ready(function(e){jQuery(".color-val").each(function(){const e=jQuery(this);var r=e.attr("id");const o=jQuery("#display-"+r);o.val(e.val())}),jQuery(document).on("input",".sgsr-main .color-val",function(){var e=jQuery(this).attr("id");jQuery("#display-"+e).val(jQuery(this).val())}),jQuery(document).on("input",".sgsr-main .sgsr-color-code",function(){var e=jQuery(this).attr("id").replace("display-","");jQuery("#"+e).val(jQuery(this).val())})}),jQuery(document).on("click",'[show-sgsr-info="cache"]',function(){jQuery('[sgsr-info-box="cache"]').toggle()}),jQuery(document).ready(function(){jQuery(document).tooltip({tooltipClass:"sgsr-tooltip",items:"[sgsr-title]",content:function(){return jQuery(this).attr("sgsr-title")}})}),jQuery(document).on("change","#slider-enable_auto_refresh",function(){sgsr_refresh_conditions()}),jQuery(document).on("change","#slider-enable_form,#slider-enable_cache",function(){sgsr_control_toogles("enable_auto_refresh",!1)}),jQuery(document).on("change","#slider-enable_form",function(){sgsr_control_toogles("enable_row_selection",!0)}),jQuery(document).on("click",'[sgsr-action="fetch-sheet"], .sgsr-fetch-settings',function(){sgsr_sheet_data()}),jQuery(document).on("change",'[popup-hide-opt="1"]',function(){var e=jQuery(this).closest("[wpbox_sgsr_msg_id]").attr("wpbox_sgsr_msg_id");this.checked?(localStorage.setItem("sgsr_hide_msg_"+e,"1"),console.log("Stored in localStorage: sgsr_hide_msg_"+e)):(localStorage.removeItem("sgsr_hide_msg_"+e),console.log("Removed from localStorage: sgsr_hide_msg_"+e))}),jQuery(document).on("change","#sgsr-form-settings input,#sgsr-form-settings select",function(){sgsr_form_save_2_json()}),jQuery(document).ready(function(){});
     1function sgsr_get_parameter(e){const r=new URLSearchParams(window.location.search);return r.get(e)}function sgsr_remove_parameter(e){const r=new URL(window.location.href);r.searchParams.delete(e),window.history.replaceState({},document.title,r.toString())}function update_sgsr_checkbox(e,r){r=jQuery(r).prop("checked")?"1":"0";jQuery("select#"+e).val(r).trigger("change")}function update_sgsr_toogle_features(){jQuery('[parent-row] input[type="checkbox"]').each(function(e,r){var o=jQuery(this).prop("checked"),t=this.id;"slider-enable_paging"==t&&(o?(jQuery('[child-option="paging"][show-for="1"]').show(),jQuery('[child-option="paging"][show-for="0"]').hide()):(jQuery('[child-option="paging"][show-for="0"]').show(),jQuery('[child-option="paging"][show-for="1"]').hide())),"slider-enable_auto_refresh"==t&&(o?(jQuery('[child-option="refresh"][show-for="1"]').show(),jQuery('[child-option="refresh"][show-for="0"]').hide()):(jQuery('[child-option="refresh"][show-for="0"]').show(),jQuery('[child-option="refresh"][show-for="1"]').hide())),"slider-enable_cache"==t&&(o?(jQuery('[child-option="cache"][show-for="1"]').show(),jQuery('[child-option="cache"][show-for="0"]').hide()):(jQuery('[child-option="cache"][show-for="0"]').show(),jQuery('[child-option="cache"][show-for="1"]').hide())),"slider-enable_form"==t&&(o?(jQuery('[child-option="enable_form"][show-for="1"]').show(),jQuery("#submission_email").prop("required",!0)):(jQuery('[child-option="enable_form"][show-for="1"]').hide(),jQuery("#submission_email").prop("required",!1)))})}function wpbox_sgsr_nadd_sheets(){jQuery('button[type="submit"][data-action="add-db"]').prop("disabled",!0),jQuery('button[type="submit"][data-action="add-db"]').addClass("pro-btn").attr("sgsr-title","Enhance your access — upgrade to create unlimited tables.")}function sgsr_disable_pro_blocks(){jQuery(".sgsr-pro-feature").each(function(e,r){var o="This is a Pro feature — upgrade to enjoy full access. <br><br> ➡️ Purchase Pro or start a free trial to explore all premium features.",t=jQuery(this).closest("tr").find("td:nth-child(2)");t.find("input").prop("disabled",!0).attr("sgsr-title",o),t.find("label").addClass("sgsr-disabled").attr("sgsr-title",o),t.find("select").prop("disabled",!0).attr("sgsr-title",o)})}function sgsr_update_sheet_notify(e){window.open("?page=sgsr_manage_all_sheets&sgsr_updated="+e,"_self")}function sgsr_add_sheet_notify(e){window.open("?page=sgsr_manage_all_sheets&sgsr_added="+e,"_self")}function sgsr_control_toogles(e,r=!1){e=jQuery("#slider-"+e);e.prop("checked")===r||e.trigger("click")}function sgsr_refresh_conditions(){jQuery("#slider-enable_auto_refresh").prop("checked")?(jQuery('[sgsr-refresh-features-msg="1"]').show(),sgsr_control_toogles("enable_form",!1),sgsr_control_toogles("enable_cache",!1)):jQuery('[sgsr-refresh-features-msg="1"]').hide()}function creat_sgsr_options(e,r,o=""){for(var t='<option value="">- Select -</option>',s="",n=0;n<e.length;n++)""!=e[n]&&(e[n]==o&&(s="selected"),t+='<option value="'+e[n]+'" '+s+">"+e[n]+"</option>");r=jQuery("#"+r),s=r.val();r.html(t),e.includes(s)&&r.val(s)}function sgsr_sheet_data(){var e=jQuery("#sgsr-sheet").val();if(console.log(e),!e.includes("https://")&&!e.includes("http://"))return alert("Invalid google sheet url. \n\n Your google sheet url should look like: https://docs.google.com/spreadsheets/d/1rssdz-mVK-kCu9Dcu1f2KOR"),0;sgsr_show_popup_msg("sheet-fetching");e="gsheet-url="+e;jQuery.ajax({url:"https://apps.wppluginbox.com/sgsr/fetch-sheet/index.php",type:"POST",data:e,cache:!1}).done(function(e){jQuery(".fetch-g-sheet").hide(),console.log(e);var r=JSON.parse(e);r.error_code;"0"==r.error_code&&(sgsr_show_popup_msg("sheet-fetching-success"),setTimeout(function(){close_sgsr_popup(),jQuery("#sheet_name").val(r.sheet_title),jQuery("#sheet_id").val(r.sheet_id),creat_sgsr_options(r.sheet_names,"tab_name")},2e3)),"1"==r.error_code&&sgsr_show_popup_msg("sheet-fetch-error")})}function sgsr_set_field_defaults(e,r){var o,t,s=jQuery('[name="'+e+'"]');s.length&&(s.is(":checkbox")?s.prop("checked","1"==r):s.is("select")?(0===s.find('option[value="'+r+'"]').length&&s.append(jQuery("<option>",{value:r,text:r})),s.val(r),"1"===s.attr("has-toogle-btn")&&(o="1"===r,(t=jQuery("#slider-"+e)).length&&t.prop("checked",o).trigger("change")),"theme"==e&&jQuery('[select-menu="theme"]').find('[data-value="'+r+'"]').trigger("click")):s.val(r),s.trigger("change"))}function enable_sgsr_update_btn(){jQuery("#add-SGSR-sheet").hide(),jQuery('[data-action="update-db"]').show(),jQuery('[name="sgsr-update"]').val(sgsr_get_parameter("edit_sgsr"))}function wpbox_sgsr_show_popup_msg(e){var r="sgsr_hide_msg_"+e,o="sgsr_last_shown_"+e;const t=Date.now();"1"!==localStorage.getItem(r)?(r=parseInt(localStorage.getItem(o),10),!isNaN(r)&&t-r<12e4&&console.log("msg_id "+e+" shown recently, skipping"),localStorage.setItem(o,t.toString()),jQuery(".wpbox_sgsr-popup [wpbox_sgsr_msg_id]").hide(),jQuery('[wpbox_sgsr_msg_id="'+e+'"]').show(),open_wpbox_sgsr_popup()):console.log("msg_id "+e+" is hidden permanently")}function open_wpbox_sgsr_popup(){console.log("opening..."),document.getElementById("wpbox_sgsr-popup").style.display="block",document.getElementById("wpbox_sgsr-popup-Overlay").style.display="block"}function close_wpbox_sgsr_popup(){document.getElementById("wpbox_sgsr-popup").style.display="none",document.getElementById("wpbox_sgsr-popup-Overlay").style.display="none"}function sgsr_form_save_2_json(){let o=[];document.querySelectorAll("tbody#sgsr-form-settings tr").forEach((e,r)=>{r+=1;o.push({label:e.querySelector("[id='form_field_"+r+"']").value.trim(),placeholder:e.querySelector("[id='form_field_"+r+"_placeholder']").value.trim(),enabled:e.querySelector("[id='enable_form_field_"+r+"']").value,required:e.querySelector("[id='form_field_"+r+"_required']").value})}),document.getElementById("form_fields").value=JSON.stringify(o)}function sgsr_json_to_form(r=""){if("{}"==r||""==r||null==r)return console.log("inv_json:",r),0;let e=[];try{if("string"==typeof r)r=jQuery("<textarea/>").html(r).text(),e=JSON.parse(r);else{if(!Array.isArray(r))return console.warn("Unsupported input type:",typeof r),0;e=r}e.forEach((e,r)=>{r+=1;let o=document.getElementById("form_field_"+r);o&&(o.value=e.label||"");let t=document.getElementById("form_field_"+r+"_placeholder");t&&(t.value=e.placeholder||"");let s=document.getElementById("form_field_"+r+"_required");s&&(s.value=e.required||0);let n=jQuery("#slider-enable_form_field_"+r);n.length&&(e="1"==e.enabled||!0===e.enabled,n.prop("checked",e).trigger("change"))})}catch(e){console.error("Invalid JSON passed to sgsr_json_to_form:",e,r)}}jQuery(document).on("click",'[btn="action-edit"]',function(){var e="?page=sgsr_create_new&edit_sgsr="+jQuery(this).attr("sgsr-id");window.open(e,"_self")}),jQuery(document).on("click",'[btn="action-delete"]',function(){var e=jQuery(this).attr("sgsr-id"),r=jQuery(this).attr("sgsr-name");confirm('Are you sure, you want to delete "'+r+'"?')&&(e="?page=sgsr_manage_all_sheets&delete_sgsr="+e,window.open(e,"_self"))}),jQuery(document).on("click",'[btn="action-copy"]',function(){var e=jQuery(this).attr("sgsr-id"),r=jQuery("<form>",{method:"POST",action:"?page=sgsr_manage_all_sheets"});r.append(jQuery("<input>",{type:"hidden",name:"sgsr-copy",value:e})),jQuery("body").append(r),r.submit()}),jQuery(document).on("click","[data-url]",function(){var e=jQuery(this).attr("data-url");if("-"==e||""==e)return console.log("invalid_link"),0;e="https://docs.google.com/spreadsheets/d/"+e,window.open(e,"_blank")}),jQuery(document).on("click",'[parent-row] input[type="checkbox"]',function(){update_sgsr_toogle_features()}),jQuery(document).ready(function(){update_sgsr_toogle_features()}),jQuery(document).on("change","#range",function(){var e=jQuery(this).val().toUpperCase();jQuery(this).val(e)}),jQuery(document).ready(function(){jQuery(".sgsr-checkbox").trigger("change")}),jQuery(document).on("click",".sgsr-choose-btn",function(){var e=jQuery(this).closest(".sgsr-row-box");e.find(".sgsr-choose-btn").removeClass("sgsr-checked");var r=e.attr("select-menu"),e=jQuery(this).attr("data-value");jQuery(this).addClass("sgsr-checked"),jQuery("#"+r).val(e),"white"==e?jQuery('[child-theme-option="white"]').show():jQuery('[child-theme-option="white"]').hide()}),jQuery(document).ready(function(){null===sgsr_get_parameter("edit_sgsr")&&jQuery('[data-value="white"]').trigger("click")}),jQuery(document).ready(function(e){jQuery(".color-val").each(function(){const e=jQuery(this);var r=e.attr("id");const o=jQuery("#display-"+r);o.val(e.val())}),jQuery(document).on("input",".sgsr-main .color-val",function(){var e=jQuery(this).attr("id");jQuery("#display-"+e).val(jQuery(this).val())}),jQuery(document).on("input",".sgsr-main .sgsr-color-code",function(){var e=jQuery(this).attr("id").replace("display-","");jQuery("#"+e).val(jQuery(this).val())})}),jQuery(document).on("click",'[show-sgsr-info="cache"]',function(){jQuery('[sgsr-info-box="cache"]').toggle()}),jQuery(document).ready(function(){jQuery(document).tooltip({tooltipClass:"sgsr-tooltip",items:"[sgsr-title]",content:function(){return jQuery(this).attr("sgsr-title")}})}),jQuery(document).on("change","#slider-enable_auto_refresh",function(){sgsr_refresh_conditions()}),jQuery(document).on("change","#slider-enable_form,#slider-enable_cache",function(){sgsr_control_toogles("enable_auto_refresh",!1)}),jQuery(document).on("change","#slider-enable_form",function(){sgsr_control_toogles("enable_row_selection",!0)}),jQuery(document).on("click",'[sgsr-action="fetch-sheet"], .sgsr-fetch-settings',function(){sgsr_sheet_data()}),jQuery(document).on("change",'[popup-hide-opt="1"]',function(){var e=jQuery(this).closest("[wpbox_sgsr_msg_id]").attr("wpbox_sgsr_msg_id");this.checked?(localStorage.setItem("sgsr_hide_msg_"+e,"1"),console.log("Stored in localStorage: sgsr_hide_msg_"+e)):(localStorage.removeItem("sgsr_hide_msg_"+e),console.log("Removed from localStorage: sgsr_hide_msg_"+e))}),jQuery(document).on("change","#sgsr-form-settings input,#sgsr-form-settings select",function(){sgsr_form_save_2_json()}),jQuery(document).ready(function(){});
Note: See TracChangeset for help on using the changeset viewer.