Jump to content

winuser2003

Members
  • Content Count

    101
  • Joined

  • Last visited

Community Reputation

1 Neutral

About winuser2003

  • Rank
    Advanced Member
  • Birthday 07/09/1978

Contact Methods

  • AIM
    winuser2003
  • MSN
    north_pj@hotmail.com
  • Website URL
    http://Paulspc.isgreat.org
  • Yahoo
    winuser2003

Profile Information

  • Gender
    Male
  • Location
    Kentucky

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. do you want me to create a new thread? There is no deadline on this type of work either... I have started it, which I believe export to csv is quite easy... I will start new threads based on features I would need assistance with. we can close this signature thread as completed.
  2. Can you help me get a start on the concept I proposed? or do you have a better concept we could think about using?
  3. So the code gets refactored providing a drop down of options the tech can choose from when observing situations. For example in the app within the phone, I believe there is a drop down that consist of different issues that can be selected from. Once selected, this option is reflected into the DB. I believe that part is achieved already. I believe one of the item numbers hold this information.
  4. Answer to Question 3 For comments on 1 and 2 your absolutely correct. Not sure how this would be approached code wise I agree, unless there is a better approach to all this.. Again, my concept was just that a concept. I am sure you get the idea of the goal by now regardless of how its approached or what the design looks like, its just making it work I basically so the clarity of information is alot more organized / clearer / and self explanatory.
  5. that worked to achieve what needs to be achieved would i need to update the PHP version? or can what we want to accomplish here be done in pre PHP 5.6?
  6. added this code --- got the error -- Parse error: syntax error, unexpected '*' in C:\xampp\htdocs3\pmapp\sigtest02.php on line 60 <?php mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); $conn = mysqli_connect("localhost", "winuser2003", "homer123", "pmapp"); $tdata = ''; $res = $conn->query("SELECT id, first_name, last_name, tech_phonenum, store_name, store_num, store_address, manager_name, robot_num, checkin_time, item_one, item_two, item_three, item_four, item_five, item_six, item_seven, item_eight, item_nine, item_ten, item_eleven, item_twelve, item_thirteen, item_fourteen,
  7. Concept Version 1 : - Export Report to CSV file - Print Report Option - View Issues ONLY Report - eMail Report Option - Ability to perform different types of searches - Sorting arrows to sort data - Count Report towards the bottom Just the first concept I had in mind and wanted your thoughts. One of the biggest parts of the report is the issues and the counts. Again, this is first concept and wanted your thoughts. I am not sure if its possible to create a cron job to send out the report every so often, like once a month etc... not sure how
  8. How do we then remain the signature on the left side be used as the standard? My colleague told me something about the print and signature... this is 2 different ways of showing the signature. He said though the print version eventually turns into the signature version. Your signature on the left side looks much and far better!
  9. I agree, I like that much better! the flow is alot more logical thanks for that!
  10. Here is the original table --- has dummy data in it -- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Feb 20, 2020 at 09:12 PM -- Server version: 10.1.19-MariaDB -- PHP Version: 5.5.38 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `pmapp` -- -- -----------------
  11. I can put them back in, not a big deal... then run some new dummy data against it when he runs the phone app. We do need those items like in my original post when we were talking about the date times. - We need this data for reporting <?php mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); $conn = mysqli_connect("localhost", "winuser2003", "homer123", "pmapp"); $tdata = ''; $res = $conn->query("SELECT id, first_name, last_name, tech_phonenum, store_name, store_num, store_address, manager_name, robot_num, checkin_time, item_one, item_two, item_three, item_four, item_fiv
  12. I will have to readd those back in, because per your comment earlier, I believe I missed understood and removed them out. I can readd them back if you want me to, however they will be empty as you know. I do apologize.
  13. So the table visit_item is empty as you know -- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Feb 20, 2020 at 06:48 PM -- Server version: 10.1.19-MariaDB -- PHP Version: 5.5.38 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `pmapp` -- -- -------------------------
×
×
  • 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.