✏️ Edit: export.php
Path:
/home/thiqat5/admincrud.thiqatech.com/sql/modules/views/pgsql/export.php
Size: 6.08 KB · Modified: 2023-08-20 10:31:19 · Perm: 0644 · Writable
← Back to directory
👁 View
⬇ Download
<link href='cache.php?css=theme,default,alerts' rel="stylesheet" /> <style> div#db_objects { margin-top:5px;padding:3px;overflow:auto;height:99%;width:95%;border:3px double #efefef } div.objhead { background-color:#ececec; padding: 5px; margin: 0 0 3px 0 } span.toggler { display:inline-block; float:right; cursor: pointer; font-size:16px; margin: -5px 0 0 0 } div.obj { padding:5px; margin:0 0 0 20px } </style> <div id="popup_wrapper"> <div id="popup_contents"> <table border="0" cellpadding="5" cellspacing="8" style="width: 100%;height:98%"> <tr> <td align="left" valign="top" width="45%" height="99%"> <?php echo __('Select objects to include in export'); ?><br /> <div id="db_objects"> <?php echo __('Either the database is empty, or there was an error retrieving list of database objects'); ?>.<br/> <?php echo __('Please try closing and re-opening this dialog again'); ?>. <div> </td> <td align="left" valign="top" width="55%"> <fieldset> <legend><?php echo __('Export type'); ?></legend> <table border="0" cellspacing="10" cellpadding="5" width="100%"> <tr><td valign="top"> <input type='radio' name='exptype' id='exptype1' value="struct" /><label class="right" for='exptype1'><?php echo __('Structure'); ?></label> </td></tr> <tr><td valign="top"> <input type='radio' name='exptype' id='exptype2' value="data" /><label class="right" for='exptype2'><?php echo __('Table Data'); ?></label> </td></tr> <tr><td valign="top"> <input type='radio' name='exptype' checked="1" id='exptype3' value="all" /><label class="right" for='exptype3'><?php echo __('Structure and Table Data'); ?></label> </td></tr> </table> </fieldset> <fieldset> <legend><?php echo __('Options'); ?></legend> <table border="0" cellspacing="10" cellpadding="5" width="100%"> <!--tr><td valign="top"> <input type='checkbox' name='auto_null' id='auto_null' /><label class="right" for='auto_null'><?php echo __('Set Auto increment field values to NULL'); ?></label> </td></tr--> <tr><td valign="top"> <input type='checkbox' name='dropcmd' id='dropcmd' /><label class="right" for='dropcmd'><?php echo __('Add DROP command before create statements'); ?></label> </td></tr> <tr><td valign="top"> <input type='checkbox' name='emptycmd' id='emptycmd' /><label class="right" for='emptycmd'><?php echo __('Add TRUNCATE command before insert statements'); ?></label> </td></tr> <tr><td valign="top"> <input type='checkbox' name='bulkinsert' id='bulkinsert' /><label class="right" for='bulkinsert'><?php echo __('Generate Bulk insert statements'); ?></label> </td></tr> <tr><td valign="top"> <input disabled="disabled" type='checkbox' name='bulklimit' id='bulklimit' /><label class="right" for='bulklimit'><?php echo __('Maximum size of SQL statement'); ?></label> <input disabled="disabled" type="text" name="bulksize" id="bulksize" style="height:12px;vertical-align:bottom;width:30px" /> KB </td></tr> </table> </fieldset> </td> </tr> </table> </div> <div id="popup_footer"> <div id="popup_buttons"> <input type='button' id="btn_export" value='<?php echo __('Export'); ?>' /> </div> </div> </div> <script type="text/javascript" language='javascript' src="cache.php?script=common,jquery,ui,query,options,alerts"></script> <script type="text/javascript" language="javascript"> window.title = "<?php echo __('Export Database'); ?>"; var exportType = 'export'; <?php foreach( $data as $name => $list ) { echo "var {$name} = " . json_encode( $list ) .";\n"; } ?> $(function() { $('#popup_overlay').remove(); // we do not want to show the popup overlay when form is submitted $('#btn_export').button().click(function() { exportData() }); $("#bulkinsert").click(function() { if( $(this).prop("checked") ) $("#bulklimit").removeAttr("disabled"); else $("#bulklimit").attr("disabled","disabled"); }); $("#bulklimit").click(function() { if( $(this).prop("checked") ) $("#bulksize").removeAttr("disabled"); else $("#bulksize").attr("disabled","disabled"); }); $("[name=exptype]").click(function() { if( $(this).val() == "struct" ) { $("#auto_null").removeAttr("disabled"); $("#exclude_type").removeAttr("disabled"); $("#exclude_charset").removeAttr("disabled"); $("#bulkinsert").removeAttr("checked").attr("disabled","disabled"); $("#bulklimit").removeAttr("checked").attr("disabled","disabled"); $("#bulksize").val('').attr("disabled","disabled"); $("#emptycmd").removeAttr("checked").attr("disabled","disabled"); $("#dropcmd").removeAttr("disabled"); } else if( $(this).val() == "data" ) { $("#exclude_type").removeAttr("checked").attr("disabled","disabled"); $("#exclude_charset").removeAttr("checked").attr("disabled","disabled"); $("#auto_null").removeAttr("checked").attr("disabled","disabled"); $("#bulkinsert").removeAttr("disabled"); $("#emptycmd").removeAttr("disabled"); $("#dropcmd").removeAttr("checked").attr("disabled","disabled"); } else { $("#auto_null").removeAttr("disabled"); $("#exclude_type").removeAttr("disabled"); $("#exclude_charset").removeAttr("disabled"); $("#bulkinsert").removeAttr("disabled"); $("#emptycmd").removeAttr("disabled"); $("#dropcmd").removeAttr("disabled"); } }); <?php if ( count($data) > 0 ) { ?> $('#db_objects').html(''); <?php // skip schemas for now unset($data['schemas']); foreach( $data as $name => $list ) { if( $name == 'tables' ) echo "uiShowObjectList({$name}, '{$name}', '" . __( ucfirst($name) ) . "');\n"; } } ?> $('.selectall').click(function(e) { chk = $(this).attr('checked'); chk ? $(this).parent().next().find('input').attr('checked', "checked") : $(this).parent().next().find('input').removeAttr('checked'); }); $('#db_objects .toggler').click(function() { $(this).parent().next().toggle(); if ($(this).hasClass('c')) { $(this).removeClass('c').html('▴'); } else { $(this).addClass('c').html('▾'); } return false; }); $("#exptype2").click(); $("#exptype1,#exptype3").attr("disabled", "disabled"); }); </script> <?php echo getGeneratedJS(); ?>
💾 Save
Cancel
Save as UTF-8, newlines normalized to LF