WordPress.org
Get WordPress

Plugin Directory

Changeset 2504902


Ignore:
Timestamp:
03/29/2021 02:03:46 AM (5 years ago)
Author:
mobilebsmith
Message:

Versio 2.06

Location:
brads-entity-attribute-value-database
Files:
4 edited
6 copied

Legend:

Unmodified
Added
Removed

  • brads-entity-attribute-value-database/tags/2.06/entity-attribute-value-database.php

    r2504873 r2504902  
    44* Plugin URI: http://mobilebsmith.hopto.org
    55* Description: Brad's Entity Attribute Value Database
    6 * Version: 2.05
     6* Version: 2.06
    77* Author: Bradley Smith
    88* Author URI: http://mobilebsmith.hopto.org
    … …  
    7373require_once( plugin_dir_path( __FILE__ ) . 'includes/shortcodes.php');
    7474
    75 //
    76 // eav_showrecord (entity, id, updateable)
    77 function eav_showrecord($v_entity, $v_id, $update) {
    78     global $wpdb;
    79    
    80    
    81     $tsql = "select tblname from " . $wpdb->base_prefix . "eav_tbl where entity = " . $v_entity;
    82     $results = $wpdb->get_row($tsql);
    83     $tablename = $results->tblname;
    84    
    85     echo '<form action="" method="post">' ;
    86     //show all database fields in table
    87     $hsql = "select  a.entity_desc, a.entity_name, a.entity_attrib, a.entity_format, " .
    88         " b.entity_order from " . $wpdb->base_prefix . "eav_attrib a, " . $wpdb->base_prefix . "eav_layout b " .
    89         " where a.entity_attrib=b.entity_attrib " .
    90         " and b.entity = " . $v_entity . " order by b.entity_order";
    91     $results = $wpdb->get_results($hsql);   
    92     foreach($results as $element) {
    93         echo '<label for="'. esc_html($element->entity_name) . '"  >' .  esc_html($element->entity_desc) . ':</label>&nbsp;&nbsp;' ;
    94        
    95         $vsql="select val_char from " . $wpdb->base_prefix . "eav_entity where entity=" . $v_entity .
    96             " and entity_id = " . $v_id . " and entity_attrib = " . $element->entity_attrib;
    97         $v_results = $wpdb->get_row($vsql);
    98         if (isset($v_results->val_char))
    99             $val = $v_results->val_char;
    100         else
    101             $val = "";
    102         echo '<input type="text" name="' . esc_html($element->entity_attrib) . '" size="50" ' . $update ;
    103         echo ' value="' . esc_html($val) . '" >';
    104         echo '<br>';
    105     }
    106     echo '<input type="hidden" name="u_entity" value="' . esc_html($v_entity) . '">';
    107     echo '<input type="hidden" name="u_entity_id" value="' . esc_html($v_id) . '">';
    108     echo '<input type="hidden" id="tablename" name="tablename" value="' . esc_html($tablename) . '">';
    109     if ($update != "readonly")
    110         echo '<input type="submit" value="Submit" name="eav_submit" ></form>';
    111     else
    112         echo '<a href="javascript:history.back()">Go Back</a>';
    113 }
    11475
    11576function eav_handle_defaults($value) {

  • brads-entity-attribute-value-database/tags/2.06/includes/shortcodes.php

    r2504283 r2504902  
    2323    $sql = "select entity_attrib, entity_name, entity_format, entity_desc, entity_default from " . $wpdb->base_prefix . "eav_attrib where entity_name = '" . $fieldname . "'";
    2424    $result_tbl = $wpdb->get_row($sql);
    25     $default = eav_handle_defaults($result_tbl->entity_default);
    26     $int = strlen(sprintf($result_tbl->entity_format, ""));
     25    if (isset($result_tbl->entity_default))
     26        $default = eav_handle_defaults($result_tbl->entity_default);
     27    else
     28        $default = "";
     29    if (isset($result_tbl->entity_format))
     30        $int = strlen(sprintf($result_tbl->entity_format, ""));
     31    else
     32        $int = 20; //default length
    2733    echo '&nbsp;<input type="' . $typeval . '" size="' . $int . '" name="' .  esc_html($fieldname) . '" id="' .  esc_html($fieldname) . '" value="' . $default . '" >';
    2834   
    … …  
    4753        $tblid = "select entity, tblname, tbldescr from " . $wpdb->base_prefix . "eav_tbl where tblname = '" . $primarytbl . "'";
    4854        $result_tbl1 =$wpdb->get_row($tblid);
     55        if (isset($result_tbl1->entity) == false) {
     56            echo "<P><H1>No parent table defined on " . esc_html($primarytbl) . ", No data saved.</H1><P>";
     57            echo "SQL is: " . esc_html($tblid) . "<P>";
     58            $content = ob_get_contents();
     59            ob_end_clean();
     60            return $content;
     61        }           
    4962        $v_entity = $result_tbl1->entity;
    5063        // find new row number
    … …  
    262275        $fsql = "select entity_attrib, entity_name, entity_format, entity_desc from " . $wpdb->base_prefix . "eav_attrib where entity_name = '" . $element->entity_name . "'";
    263276        $fldret = $wpdb->get_row($fsql);
    264         $int = strlen(sprintf($fldret->entity_format, "")) * 2;
     277        $int = strlen(sprintf($fldret->entity_format, ""));
    265278       
    266279        echo 'var cell' . $cellno . ' = row.insertCell(' . ($cellno -1 ) . ');';
    … …  
    287300        $fsql = "select entity_attrib, entity_name, entity_format, entity_desc from " . $wpdb->base_prefix . "eav_attrib where entity_name = '" . $element->entity_name . "'";
    288301        $fldret = $wpdb->get_row($fsql);
    289         $int = strlen(sprintf($fldret->entity_format, ""));
     302        if (isset($fldret->entity_format))
     303            $int = strlen(sprintf($fldret->entity_format, "")) - 5;
     304        else
     305            $int = 20;
    290306        echo '<th style= "width: ' . $int . 'px" >' . esc_html($element->entity_name) . '</th>';
    291307    }
    … …  
    299315        $fsql = "select entity_attrib, entity_name, entity_format, entity_desc from " . $wpdb->base_prefix . "eav_attrib where entity_name = '" . $element->entity_name . "'";
    300316        $fldret = $wpdb->get_row($fsql);
    301         $int = strlen(sprintf($fldret->entity_format, "")) * 2;
     317        $int = strlen(sprintf($fldret->entity_format, "")) ;
    302318        echo '<td>';   
    303319        echo '<input type="text"  size="' . $int . '" name="' . esc_html($element->entity_name) . '[]"   />';
    … …  
    511527   
    512528        echo '</tr></table>';
    513        
     529
    514530        $content = ob_get_contents();
    515531        ob_end_clean();
    516532        return $content;
    517533    }   
     534}
     535//
     536// eav_showrecord (entity, id, updateable)
     537function eav_showrecord($v_entity, $v_id, $update) {
     538    global $wpdb;
     539   
     540   
     541    $tsql = "select tblname from " . $wpdb->base_prefix . "eav_tbl where entity = " . $v_entity;
     542    $results = $wpdb->get_row($tsql);
     543    $tablename = $results->tblname;
     544   
     545    echo '<form action="" method="post">' ;
     546    //show all database fields in table
     547    $hsql = "select  a.entity_desc, a.entity_name, a.entity_attrib, a.entity_format, " .
     548        " b.entity_order from " . $wpdb->base_prefix . "eav_attrib a, " . $wpdb->base_prefix . "eav_layout b " .
     549        " where a.entity_attrib=b.entity_attrib " .
     550        " and b.entity = " . $v_entity . " order by b.entity_order";
     551    $results = $wpdb->get_results($hsql);   
     552    foreach($results as $element) {
     553        echo '<label for="'. esc_html($element->entity_name) . '"  >' .  esc_html($element->entity_desc) . ':</label>&nbsp;&nbsp;' ;
     554       
     555        $vsql="select val_char from " . $wpdb->base_prefix . "eav_entity where entity=" . $v_entity .
     556            " and entity_id = " . $v_id . " and entity_attrib = " . $element->entity_attrib;
     557        $v_results = $wpdb->get_row($vsql);
     558        if (isset($v_results->val_char))
     559            $val = $v_results->val_char;
     560        else
     561            $val = "";
     562        echo '<input type="text" name="' . esc_html($element->entity_attrib) . '" size="50" ' . $update ;
     563        echo ' value="' . esc_html($val) . '" >';
     564        echo '<br>';
     565    }
     566    echo '<input type="hidden" name="u_entity" value="' . esc_html($v_entity) . '">';
     567    echo '<input type="hidden" name="u_entity_id" value="' . esc_html($v_id) . '">';
     568    echo '<input type="hidden" id="tablename" name="tablename" value="' . esc_html($tablename) . '">';
     569    if ($update != "readonly")
     570        echo '<input type="submit" value="Submit" name="eav_submit" ></form>';
     571    else {
     572        //
     573        // show child records - $v_entity, $v_id
     574        // get child records
     575        $c1sql= "select entity, tblname from " . $wpdb->base_prefix . "eav_tbl where parent_entity = " . $v_entity ;
     576        $result_tbl = $wpdb->get_row($c1sql);
     577        if (isset($result_tbl->entity)) {
     578            // in here we have child rows to see if we have data
     579            $vc_entity = $result_tbl->entity;
     580            //show all database fields in table
     581            $hsql = "select a.entity_desc, a.entity_name, a.entity_attrib, a.entity_format, " .
     582                " b.entity_order from " . $wpdb->base_prefix . "eav_attrib a, " . $wpdb->base_prefix . "eav_layout b " .
     583                " where a.entity_attrib=b.entity_attrib and b.entity = " . $vc_entity . ' order by b.entity_order' ;
     584            $results = $wpdb->get_results($hsql);
     585            echo '<table style="margin-left: auto; margin-right: auto; width: 80%; border: 1px solid black" id="myTable" >';
     586            echo '<tr ><th style="border: 1px solid black"></th>';  // first column is for view data
     587            $colid = 0;
     588            foreach($results as $element) {
     589                $int = strlen(sprintf($element->entity_format, ""));
     590                //echo '<th style="width: ' . $int . 'px; border: 1px solid black"; onclick="eav_sortTable(' . $colid . ')">' . esc_html($element->entity_desc) . '</th>';
     591                echo '<th style="border: 1px solid black"; onclick="eav_sortTable(' . $colid . ')">' . esc_html($element->entity_desc) . '</th>';
     592                $colid = $colid + 1;
     593            }
     594            echo '</tr>';
     595           
     596            $new_row = 0;
     597           
     598            $dcsql = "select a.entity,  a.entity_id, a.entity_attrib, a.val_char, a.parent_entity, a.parent_entity_id, b.entity_order  " .
     599            " from " . $wpdb->base_prefix . "eav_entity a, " . $wpdb->base_prefix . "eav_layout b " .
     600            " where a.entity_attrib=b.entity_attrib and b.entity = " . $vc_entity .
     601            " and a.parent_entity = " .  $v_entity . " and a.parent_entity_id = " . $v_id .
     602            " and a.entity_attrib=b.entity_attrib and a.entity=b.entity " . ' order by entity_id,b.entity_order' ;
     603
     604   
     605            $sql="select max(entity_order) as max from " . $wpdb->base_prefix . "eav_layout where entity = " .  $vc_entity;
     606            $result_tbl =$wpdb->get_row($sql);
     607            $max_col = $result_tbl->max;
     608   
     609            $results = $wpdb->get_results($dcsql);
     610            $colno = 1;
     611            echo "<tr>";
     612            foreach($results as $element) {
     613                if (( $new_row <> sanitize_text_field($element->entity_id)) && ( $new_row <> 0)) {
     614                    //finish out row if no data
     615                    for($ii = $colno; $ii < $max_col; $ii++) {
     616                        echo '<td style="border: 1px solid black"></td>';
     617                    }
     618                    /* new row */
     619                    $colno = 1;
     620                    echo '</tr><tr><td td style="border: 1px solid black"></td>';
     621                } else if (($colno == 1)&& ($new_row == 0)) { // first time
     622                    echo '<td style="border: 1px solid black"></td>';
     623                }
     624                $new_row = sanitize_text_field($element->entity_id);
     625                $newcol = sanitize_text_field($element->entity_order);
     626                if ($newcol != ($colno +1)) {
     627                    // missing columns
     628                    for($ii = ($colno +1); $ii < $newcol; $ii++)
     629                        echo '<td style="border: 1px solid black"></td>';
     630                }                   
     631                echo '<td style="border: 1px solid black">';
     632                echo esc_html($element->val_char) . '</td>';
     633                $colno = $newcol;
     634            }
     635            //Finish out last row
     636            for($ii = $colno; $ii < $max_col; $ii++)
     637                    echo '<td style="border: 1px solid black"></td>';
     638   
     639            echo '</tr></table>';
     640
     641       
     642            $c2sql = "select entity, entity_id, entity_attrib, val_cha, parent_entity, parent_entity_id
     643                from " . $wpdb->base_prefix . "eav_entity where parent_entity = " . $v_entity .
     644                " and parent_entity_id = " . $v_id;
     645            echo '<a href="javascript:history.back()">Go Back</a>';
     646        }
     647    }
    518648}
    519649

  • brads-entity-attribute-value-database/tags/2.06/readme.txt

    r2504873 r2504902  
    88Requires at least: 5.7
    99Tested up to: 5.7
    10 Stable tag: 2.05
    11 Version: 2.05
     10Stable tag: 2.06
     11Version: 2.06
    1212License: GPLv2 or later
    1313License URI: https://www.gnu.org/licenses/gpl-2.0.html
    … …  
    7979
    8080== Changelog ==
     81= v2.06 [3/28/2021]
     82* bug fixes on shortcodes for eav_tbl and eav_subrec
     83
    8184= v2.05 [3/28/2021]
    8285* bug fixes for missing prefix on tables

  • brads-entity-attribute-value-database/trunk/entity-attribute-value-database.php

    r2504873 r2504902  
    44* Plugin URI: http://mobilebsmith.hopto.org
    55* Description: Brad's Entity Attribute Value Database
    6 * Version: 2.05
     6* Version: 2.06
    77* Author: Bradley Smith
    88* Author URI: http://mobilebsmith.hopto.org
    … …  
    7373require_once( plugin_dir_path( __FILE__ ) . 'includes/shortcodes.php');
    7474
    75 //
    76 // eav_showrecord (entity, id, updateable)
    77 function eav_showrecord($v_entity, $v_id, $update) {
    78     global $wpdb;
    79    
    80    
    81     $tsql = "select tblname from " . $wpdb->base_prefix . "eav_tbl where entity = " . $v_entity;
    82     $results = $wpdb->get_row($tsql);
    83     $tablename = $results->tblname;
    84    
    85     echo '<form action="" method="post">' ;
    86     //show all database fields in table
    87     $hsql = "select  a.entity_desc, a.entity_name, a.entity_attrib, a.entity_format, " .
    88         " b.entity_order from " . $wpdb->base_prefix . "eav_attrib a, " . $wpdb->base_prefix . "eav_layout b " .
    89         " where a.entity_attrib=b.entity_attrib " .
    90         " and b.entity = " . $v_entity . " order by b.entity_order";
    91     $results = $wpdb->get_results($hsql);   
    92     foreach($results as $element) {
    93         echo '<label for="'. esc_html($element->entity_name) . '"  >' .  esc_html($element->entity_desc) . ':</label>&nbsp;&nbsp;' ;
    94        
    95         $vsql="select val_char from " . $wpdb->base_prefix . "eav_entity where entity=" . $v_entity .
    96             " and entity_id = " . $v_id . " and entity_attrib = " . $element->entity_attrib;
    97         $v_results = $wpdb->get_row($vsql);
    98         if (isset($v_results->val_char))
    99             $val = $v_results->val_char;
    100         else
    101             $val = "";
    102         echo '<input type="text" name="' . esc_html($element->entity_attrib) . '" size="50" ' . $update ;
    103         echo ' value="' . esc_html($val) . '" >';
    104         echo '<br>';
    105     }
    106     echo '<input type="hidden" name="u_entity" value="' . esc_html($v_entity) . '">';
    107     echo '<input type="hidden" name="u_entity_id" value="' . esc_html($v_id) . '">';
    108     echo '<input type="hidden" id="tablename" name="tablename" value="' . esc_html($tablename) . '">';
    109     if ($update != "readonly")
    110         echo '<input type="submit" value="Submit" name="eav_submit" ></form>';
    111     else
    112         echo '<a href="javascript:history.back()">Go Back</a>';
    113 }
    11475
    11576function eav_handle_defaults($value) {

  • brads-entity-attribute-value-database/trunk/includes/shortcodes.php

    r2504283 r2504902  
    2323    $sql = "select entity_attrib, entity_name, entity_format, entity_desc, entity_default from " . $wpdb->base_prefix . "eav_attrib where entity_name = '" . $fieldname . "'";
    2424    $result_tbl = $wpdb->get_row($sql);
    25     $default = eav_handle_defaults($result_tbl->entity_default);
    26     $int = strlen(sprintf($result_tbl->entity_format, ""));
     25    if (isset($result_tbl->entity_default))
     26        $default = eav_handle_defaults($result_tbl->entity_default);
     27    else
     28        $default = "";
     29    if (isset($result_tbl->entity_format))
     30        $int = strlen(sprintf($result_tbl->entity_format, ""));
     31    else
     32        $int = 20; //default length
    2733    echo '&nbsp;<input type="' . $typeval . '" size="' . $int . '" name="' .  esc_html($fieldname) . '" id="' .  esc_html($fieldname) . '" value="' . $default . '" >';
    2834   
    … …  
    4753        $tblid = "select entity, tblname, tbldescr from " . $wpdb->base_prefix . "eav_tbl where tblname = '" . $primarytbl . "'";
    4854        $result_tbl1 =$wpdb->get_row($tblid);
     55        if (isset($result_tbl1->entity) == false) {
     56            echo "<P><H1>No parent table defined on " . esc_html($primarytbl) . ", No data saved.</H1><P>";
     57            echo "SQL is: " . esc_html($tblid) . "<P>";
     58            $content = ob_get_contents();
     59            ob_end_clean();
     60            return $content;
     61        }           
    4962        $v_entity = $result_tbl1->entity;
    5063        // find new row number
    … …  
    262275        $fsql = "select entity_attrib, entity_name, entity_format, entity_desc from " . $wpdb->base_prefix . "eav_attrib where entity_name = '" . $element->entity_name . "'";
    263276        $fldret = $wpdb->get_row($fsql);
    264         $int = strlen(sprintf($fldret->entity_format, "")) * 2;
     277        $int = strlen(sprintf($fldret->entity_format, ""));
    265278       
    266279        echo 'var cell' . $cellno . ' = row.insertCell(' . ($cellno -1 ) . ');';
    … …  
    287300        $fsql = "select entity_attrib, entity_name, entity_format, entity_desc from " . $wpdb->base_prefix . "eav_attrib where entity_name = '" . $element->entity_name . "'";
    288301        $fldret = $wpdb->get_row($fsql);
    289         $int = strlen(sprintf($fldret->entity_format, ""));
     302        if (isset($fldret->entity_format))
     303            $int = strlen(sprintf($fldret->entity_format, "")) - 5;
     304        else
     305            $int = 20;
    290306        echo '<th style= "width: ' . $int . 'px" >' . esc_html($element->entity_name) . '</th>';
    291307    }
    … …  
    299315        $fsql = "select entity_attrib, entity_name, entity_format, entity_desc from " . $wpdb->base_prefix . "eav_attrib where entity_name = '" . $element->entity_name . "'";
    300316        $fldret = $wpdb->get_row($fsql);
    301         $int = strlen(sprintf($fldret->entity_format, "")) * 2;
     317        $int = strlen(sprintf($fldret->entity_format, "")) ;
    302318        echo '<td>';   
    303319        echo '<input type="text"  size="' . $int . '" name="' . esc_html($element->entity_name) . '[]"   />';
    … …  
    511527   
    512528        echo '</tr></table>';
    513        
     529
    514530        $content = ob_get_contents();
    515531        ob_end_clean();
    516532        return $content;
    517533    }   
     534}
     535//
     536// eav_showrecord (entity, id, updateable)
     537function eav_showrecord($v_entity, $v_id, $update) {
     538    global $wpdb;
     539   
     540   
     541    $tsql = "select tblname from " . $wpdb->base_prefix . "eav_tbl where entity = " . $v_entity;
     542    $results = $wpdb->get_row($tsql);
     543    $tablename = $results->tblname;
     544   
     545    echo '<form action="" method="post">' ;
     546    //show all database fields in table
     547    $hsql = "select  a.entity_desc, a.entity_name, a.entity_attrib, a.entity_format, " .
     548        " b.entity_order from " . $wpdb->base_prefix . "eav_attrib a, " . $wpdb->base_prefix . "eav_layout b " .
     549        " where a.entity_attrib=b.entity_attrib " .
     550        " and b.entity = " . $v_entity . " order by b.entity_order";
     551    $results = $wpdb->get_results($hsql);   
     552    foreach($results as $element) {
     553        echo '<label for="'. esc_html($element->entity_name) . '"  >' .  esc_html($element->entity_desc) . ':</label>&nbsp;&nbsp;' ;
     554       
     555        $vsql="select val_char from " . $wpdb->base_prefix . "eav_entity where entity=" . $v_entity .
     556            " and entity_id = " . $v_id . " and entity_attrib = " . $element->entity_attrib;
     557        $v_results = $wpdb->get_row($vsql);
     558        if (isset($v_results->val_char))
     559            $val = $v_results->val_char;
     560        else
     561            $val = "";
     562        echo '<input type="text" name="' . esc_html($element->entity_attrib) . '" size="50" ' . $update ;
     563        echo ' value="' . esc_html($val) . '" >';
     564        echo '<br>';
     565    }
     566    echo '<input type="hidden" name="u_entity" value="' . esc_html($v_entity) . '">';
     567    echo '<input type="hidden" name="u_entity_id" value="' . esc_html($v_id) . '">';
     568    echo '<input type="hidden" id="tablename" name="tablename" value="' . esc_html($tablename) . '">';
     569    if ($update != "readonly")
     570        echo '<input type="submit" value="Submit" name="eav_submit" ></form>';
     571    else {
     572        //
     573        // show child records - $v_entity, $v_id
     574        // get child records
     575        $c1sql= "select entity, tblname from " . $wpdb->base_prefix . "eav_tbl where parent_entity = " . $v_entity ;
     576        $result_tbl = $wpdb->get_row($c1sql);
     577        if (isset($result_tbl->entity)) {
     578            // in here we have child rows to see if we have data
     579            $vc_entity = $result_tbl->entity;
     580            //show all database fields in table
     581            $hsql = "select a.entity_desc, a.entity_name, a.entity_attrib, a.entity_format, " .
     582                " b.entity_order from " . $wpdb->base_prefix . "eav_attrib a, " . $wpdb->base_prefix . "eav_layout b " .
     583                " where a.entity_attrib=b.entity_attrib and b.entity = " . $vc_entity . ' order by b.entity_order' ;
     584            $results = $wpdb->get_results($hsql);
     585            echo '<table style="margin-left: auto; margin-right: auto; width: 80%; border: 1px solid black" id="myTable" >';
     586            echo '<tr ><th style="border: 1px solid black"></th>';  // first column is for view data
     587            $colid = 0;
     588            foreach($results as $element) {
     589                $int = strlen(sprintf($element->entity_format, ""));
     590                //echo '<th style="width: ' . $int . 'px; border: 1px solid black"; onclick="eav_sortTable(' . $colid . ')">' . esc_html($element->entity_desc) . '</th>';
     591                echo '<th style="border: 1px solid black"; onclick="eav_sortTable(' . $colid . ')">' . esc_html($element->entity_desc) . '</th>';
     592                $colid = $colid + 1;
     593            }
     594            echo '</tr>';
     595           
     596            $new_row = 0;
     597           
     598            $dcsql = "select a.entity,  a.entity_id, a.entity_attrib, a.val_char, a.parent_entity, a.parent_entity_id, b.entity_order  " .
     599            " from " . $wpdb->base_prefix . "eav_entity a, " . $wpdb->base_prefix . "eav_layout b " .
     600            " where a.entity_attrib=b.entity_attrib and b.entity = " . $vc_entity .
     601            " and a.parent_entity = " .  $v_entity . " and a.parent_entity_id = " . $v_id .
     602            " and a.entity_attrib=b.entity_attrib and a.entity=b.entity " . ' order by entity_id,b.entity_order' ;
     603
     604   
     605            $sql="select max(entity_order) as max from " . $wpdb->base_prefix . "eav_layout where entity = " .  $vc_entity;
     606            $result_tbl =$wpdb->get_row($sql);
     607            $max_col = $result_tbl->max;
     608   
     609            $results = $wpdb->get_results($dcsql);
     610            $colno = 1;
     611            echo "<tr>";
     612            foreach($results as $element) {
     613                if (( $new_row <> sanitize_text_field($element->entity_id)) && ( $new_row <> 0)) {
     614                    //finish out row if no data
     615                    for($ii = $colno; $ii < $max_col; $ii++) {
     616                        echo '<td style="border: 1px solid black"></td>';
     617                    }
     618                    /* new row */
     619                    $colno = 1;
     620                    echo '</tr><tr><td td style="border: 1px solid black"></td>';
     621                } else if (($colno == 1)&& ($new_row == 0)) { // first time
     622                    echo '<td style="border: 1px solid black"></td>';
     623                }
     624                $new_row = sanitize_text_field($element->entity_id);
     625                $newcol = sanitize_text_field($element->entity_order);
     626                if ($newcol != ($colno +1)) {
     627                    // missing columns
     628                    for($ii = ($colno +1); $ii < $newcol; $ii++)
     629                        echo '<td style="border: 1px solid black"></td>';
     630                }                   
     631                echo '<td style="border: 1px solid black">';
     632                echo esc_html($element->val_char) . '</td>';
     633                $colno = $newcol;
     634            }
     635            //Finish out last row
     636            for($ii = $colno; $ii < $max_col; $ii++)
     637                    echo '<td style="border: 1px solid black"></td>';
     638   
     639            echo '</tr></table>';
     640
     641       
     642            $c2sql = "select entity, entity_id, entity_attrib, val_cha, parent_entity, parent_entity_id
     643                from " . $wpdb->base_prefix . "eav_entity where parent_entity = " . $v_entity .
     644                " and parent_entity_id = " . $v_id;
     645            echo '<a href="javascript:history.back()">Go Back</a>';
     646        }
     647    }
    518648}
    519649

  • brads-entity-attribute-value-database/trunk/readme.txt

    r2504873 r2504902  
    88Requires at least: 5.7
    99Tested up to: 5.7
    10 Stable tag: 2.05
    11 Version: 2.05
     10Stable tag: 2.06
     11Version: 2.06
    1212License: GPLv2 or later
    1313License URI: https://www.gnu.org/licenses/gpl-2.0.html
    … …  
    7979
    8080== Changelog ==
     81= v2.06 [3/28/2021]
     82* bug fixes on shortcodes for eav_tbl and eav_subrec
     83
    8184= v2.05 [3/28/2021]
    8285* bug fixes for missing prefix on tables
Note: See TracChangeset for help on using the changeset viewer.