Jump to content

mongoose00318

Members
  • Content Count

    223
  • Joined

  • Last visited

Community Reputation

0 Neutral

About mongoose00318

  • Rank
    Advanced Member

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

1,647 profile views
  1. Awesome man. You're level of SQL knowledge is impressive. Thanks for the thorough explanation. Very cool indeed.
  2. @Barand Very cool though works like a charm.
  3. Okay, can you explain that one to me a bit? So, is the AND ps.order_id IS NULL the part that is basically saying only order that do not exist in the production_status table with these parameters?
  4. I believe so. Can you show the whole query so I can test it?
  5. I only have interest in the order_id and knowing that it exists in that production_status table with those conditions (meaning it's been marked by the shipping dept as shipped)
  6. This should item should come back Because order_id 15298 has an entry in the production_status table where its dept_code is = 13 and it's status_id = 3
  7. -- phpMyAdmin SQL Dump -- version 4.9.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Mar 24, 2021 at 12:21 PM -- Server version: 10.4.10-MariaDB -- PHP Version: 7.3.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; -- -- Database: `fedheath_production` -- -- -------------------------------------------------------- -- -- Table structure for table `production_data` -- DROP TABLE IF EXISTS `production_data`; CREATE TABLE IF NOT EXISTS `production_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `job_n
  8. Shoot. One second. Sorry about that.
  9. @Barand Yes I'm sure about the Maria problem. I may just have an older version. It has said this to me before. Here is some sample data: -- phpMyAdmin SQL Dump -- version 4.9.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Mar 24, 2021 at 12:02 PM -- Server version: 10.4.10-MariaDB -- PHP Version: 7.3.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; -- -- Database: `fedheath_production` -- -- -------------------------------------------------------- -- -- Table structure for table `production
  10. SELECT pd.enterprise, COUNT(*) AS total FROM production_data pd WHERE enterprise = "EXXON" AND as400_ship_date = CAST("2021-03-02" AS DATE) AND hold_date = "0000-00-00" AND pd.id NOT IN( SELECT order_id FROM ( SELECT MAX(id), order_id FROM production_status WHERE order_id = pd.id AND dept_code = 13 AND status_id = 3 ) ) Okay I changed it to this but am still getting a syntax error.
  11. Shoot, well MariaDB doesn't support LIMIT in a subquery. Is there a different way to accomplish this?
  12. I am trying to use this to reference another table to determine if an item has shipped or not; if it has don't include it. But I'm having some issues with my SQL. SELECT pd.enterprise, COUNT(*) AS total FROM production_data pd WHERE enterprise = "EXXON" AND as400_ship_date = CAST("2021-03-02" AS DATE) AND hold_date = "0000-00-00" AND pd.id NOT IN( SELECT order_id FROM production_status WHERE order_id = pd.id AND dept_code = 13 AND status_id = 3 ORDER BY id DESC LIMIT 1 ) I think the problem is where I have order_id = pd
  13. Well I think I've found a solution. I knew there was a built in tooltip for HighCharts but I wasn't sure it would do exactly what I was trying to do with it. After researching more of it's settings I think I have it doing what I want but I am getting a JS error on my returned JSON. 'Uncaught SyntaxError: Unexpected token u in JSON at position 0' Here is a sample of my returned JSON: 0: {id: 14671, job_number: 22094872} 1: {id: 14739, job_number: 22102672} 2: {id: 14740, job_number: 22102682} 3: {id: 14673, job_number: 22102712} 4: {id: 14675, job_number: 22102722} 5: {id: 14678,
  14. Hello Everyone, I've started using HighCharts JS library to make dynamic charts and so far it is pretty impressive. Here is a screenshot of my chart that I'd like to make a custom behavior for: Basically what I would like to do is when a user clicks on a point in a series within a certain category (for example on category 2021-02-15 the user clicks the series with a total of 35 line items) a box would pop out to the side of the series point the user has clicked on and would be populated with an ajax request. Here is my code so far: const chart = Highchar
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.