Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- global $wpdb;
- $user_id = get_current_user_id();
- $results = $wpdb->get_results("
- SELECT post_title, stock_level, guid AS link
- FROM wp_posts p
- INNER JOIN wp_post_stocklv s ON s.product_ID = p.ID
- INNER JOIN wp_term_relationships ON wp_term_relationships.object_id = p.ID
- INNER JOIN wp_postmeta m ON m.post_id = p.ID
- WHERE p.post_type = 'product'
- AND s.user_ID = $user_id
- AND wp_term_relationships.term_taxonomy_id = 34
- AND p.post_status = 'publish'
- AND m.meta_value = 'yes' OR m.meta_value = p.ID
- ORDER BY post_title ASC
- ");
- if(!empty($results)) {
- echo '<form action="#" method="post">
- <table>
- <tbody>';
- foreach($results as $r) {
- echo '
- <td><a style="text-decoration: none" href="' .$r->link. '" target="blank">'.$r->post_title.'</a></td>
- <td><input class="text stock" name="stocklevels[]" step="any" type="number" value="' .$r->stock_level. '" /></td>
- ';
- }
- echo '<input type="submit" value="stocksubmit" name="stocksubmit" id="stocksubmit" style="float: right" class="update-btn"></form></table>
- if (isset($_POST['stocksubmit'])){
- var_dump($_POST['stocklevels']);
- echo "<div class='stock-success'>Success! You have updated your stock! <div id='stock-success-close'>Close</div></div>";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement