Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Paulqvz

  • Rank
  1. Good day I have three tables - receiving - shipping and stock movement. everyday i transfer into stock movent the sum of receining with date - havein a stock movent entry per day - I also at end of day update with shipping for that day, in stock table I calculate ne stock level. my problem is that when three days bac i stil have stock i need to start subtracting from oldest entry first till it reaches 0 the move over to second eldest? i have no idea where to start or how to achieve this
  2. Good morning guys. I am pulling data from vehicle tracking site via soap curl. but the data format that I am getting it in is unusable, maybee i am doing something wrong. please have a look. here is the code. <?php //Data, connection, auth $dataFromTheForm = $_POST['fieldName']; // request data from the form $soapUrl = "https://fleet11.******.co.za/api/"; // asmx URL of WSDL $soapUser = "********"; // username $soapPassword = "********"; // password // xml post structure $xml_post_string = '<?xml version="1.0" encoding="utf-8"?> <soapenv:Envelope xmlns:xsi="ht
  3. Sorry this is my cases.js file the js looks like this if(category == 'itc_profile_update') {type_list_name = 'ITC Profile Update'; type_list_name2 = 'itc_profile_update_qt';} if(category == 'vehicle_sales') {type_list_name = 'Vehicle Sales'; type_list_name2 = 'Vehicle_Sales_qt';} if(category == 'icu_query') {type_list_name = 'ICU Query'; type_list_name2 = 'icu_query_qt';} if(category == 'self_help_app') {type_list_name = 'Self Help App Query
  4. Quick question how would i get only 'ITC Profile Update if i search for itc_profile_update. then when category == 'itc_profile_update' = itc_profile_update then only show 'ITC Profile Update' from {type_list_name = 'ITC Profile Update'; if(category == 'itc_profile_update') {type_list_name = 'ITC Profile Update'; type_list_name2 = 'itc_profile_update_qt';}
  5. Exactly what i was looking for. Thank you thank you
  6. I am already reading it, getting the output, now i need a way to start a my start point and then to end at last tab before ne line without a tab
  7. stop worrying about "query_complaint_type_list" that was just me seeing if i can return data between 2 points - and it worked, but the problem is i wil always know the start point but never the end point, hend me trying to start at Example. \nsales_stage_dom $pos = strpos($content,"nsales_stage_dom"); and end befor \nsales_probability_dom as that is where the dropdown info stops' $end = strpos($content,"\n); and not $end = strpos($content,"\n\t); \nsales_stage_dom \n\t@clear \n\t@orig Closed Lost \n\t@orig Closed Won \n\t@orig Id. Decision Makers
  8. requinix. yes that is the layout of the file. the php starts with <?php return; /* no output */> then the rest is this. query_complaint_type_list is a list name- same as account_type_dom,industry_dom When the api calls "account_type_dom" it must only return @clear "": "" @orig Customer "Brand Owner ": "Brand Owner " Printing Company: Printing Company Installation Company: Installation Company Sales Person: Sales Person Zebra: Zebra When the api calls "industry_dom" it must only return @clear "":
  9. Good day all. I am trying to get strings from txt file with a start and an end. $file = "/var/www/html/sataxicrm/custom/include/language/lang.en_us.lists.php"; $content = file_get_contents($file); $pos = strpos($content,"query_complaint_type_list"); $end = strpos($content,"status_0"); $string = substr($content,$pos,($end- $pos)); $array = nl2br($string); //print $content; echo "Database Value:Label Value <br>"; print $array; The above code works well if you knowwhat your end string is, but in my case i do not know. i only know the start. Below is an example of
  10. I have below script. it does the while loop 100%. it updates the mysql database one at a time as it should. the problem I have now is that the while loop does not end and go to the next statement as it should. it keeps pollong the database. so when in back end you change to 0 it automatically updates again. Please see if you can help me to see where I can stop this while loop when there are no more loops // Here I select the amount of rows $sql_query = "SELECT ae FROM `debitorderrejectionimport` WHERE ae = '0'"; $rowCount = mysqli_query($conn,$sql_query); $rowCountUpdate = mysq
  • 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.