Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. global $wpdb;
  2. $user_id = get_current_user_id();
  3. $results = $wpdb->get_results("
  4.  
  5. SELECT post_title, stock_level, guid AS link
  6. FROM wp_posts p
  7.  
  8. INNER JOIN wp_post_stocklv s ON s.product_ID = p.ID
  9. INNER JOIN wp_term_relationships ON wp_term_relationships.object_id = p.ID
  10. INNER JOIN wp_postmeta m ON m.post_id = p.ID
  11.  
  12. WHERE p.post_type = 'product'
  13. AND s.user_ID = $user_id
  14. AND wp_term_relationships.term_taxonomy_id = 34
  15. AND p.post_status = 'publish'
  16. AND m.meta_value = 'yes' OR m.meta_value = p.ID
  17. ORDER BY post_title ASC
  18. ");
  19.  
  20. if(!empty($results)) {
  21. echo '<form action="#" method="post">
  22. <table>
  23. <tbody>';
  24. foreach($results as $r) {
  25. echo '
  26. <td><a style="text-decoration: none" href="' .$r->link. '" target="blank">'.$r->post_title.'</a></td>
  27. <td><input class="text stock" name="stocklevels[]" step="any" type="number" value="' .$r->stock_level. '" /></td>
  28. ';
  29. }
  30. echo '<input type="submit" value="stocksubmit" name="stocksubmit" id="stocksubmit" style="float: right" class="update-btn"></form></table>
  31.  
  32. if (isset($_POST['stocksubmit'])){
  33.  
  34. var_dump($_POST['stocklevels']);
  35.  
  36. echo "<div class='stock-success'>Success! You have updated your stock! <div id='stock-success-close'>Close</div></div>";
  37.  
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement