Jump to content

jeffjb

Members
  • Content count

    56
  • Joined

  • Last visited

  1. jeffjb

    Order Tracker New Contrib....

    I was wondering if any one has added SALE TAX tracking to this report? I would like see tax numbers on these reports. Thanks, jeff
  2. ok two things solved my problem. First since cURL is built into my php I did not need to have the path so I have cURL path set to none. Second country and state codes need to be 2 digits in our case AZ and US. It now works like a charm here is a link from FedEx that might help Click the link below to obtain a copy of the Tagged Transaction Guide, please disregard this link if you're utilizing the FedEx XML solution: http://www.fedex.com/us/solutions/wis/pdf/TagTransGuide.pdf hope this might help someone else.
  3. I have also noticed that my cURL path has white spaces in it. this is running on a liux box and I was wondering if this is a issue for the mod. the hosting company tested it and said it works on their end and FedEx says it works on theirs. here is the path: Again any help would be appreciated Jeff
  4. I am having the same problem as Craig. I called FedEX and they said my account is fine on their end and it most be on my end. Here is the error at the top because I have debug on: Then this is the error in the shipping area of the page: I have open SSL and CURL running. Please help if you can. Thanks Jeff
  5. jeffjb

    Order Tracker New Contrib....

    Jared, I am just changing the order status to Refunded which I set up as status 4. this why I can keep track of how much was refunded in a month or year. I have been trying to edit the file and subtract all the order status 4 from the total but so far no luck. I would appreciate any help Thanks, Jeff
  6. jeffjb

    Order Tracker New Contrib....

    thank you for this contrib it is great!!! Is there a way to subtract refunded orders from the daily, monthly and yearly totals, or to add the refunded orders totals $ amounts. I added the stauts (4 in my case) to the report so it shows the number of orders refunded but not the $ amount, It also throws my totals off since I have given the money back except for shipping. Thank you Jeff
  7. When ever I try changing anything in catalog/includes/classes/shipsched.php I get the following error on the checkout shipping page. if I leave it at the default it works fine. I am not changing the function. all I am trying to do is exclude Saturday and make next Wed the earlist day if you order after Wed. here is the shipsched.php: <? class ShippingSchedule { var $time_diff; var $schedule; var $earliest_date; var $charges; function ShippingSchedule(){ //Configure possible earliest delivery date for an order as follows. This system //allows for complex situations where stores need variable amounts of preparation time,etc. //as well as simpler schemes. //The schedule array uses index 0-6 for each day of the week. 0 is sunday, 1 monday, etc., //'start_time' is an integer representing the hour of the day (24 hour) //Each day uses the previous day's 'target date' as the earliest //possible date to deliver on until the 'start_time' specified -- at that point //it will use it's own 'target date' as the earliest delivery day. //ex. an order at 12:25pm on Monday (schedule[1]), the earliest possible day to deliver //will be 3 (Wednesday), but after 13:00 on Monday, the earliest poss. day will be 4 (Thurs). //A start time of 0 would indicate to always use the current day's 'target day'. In this example, //any order on Sunday would have an earliest delivery date of Wednesday. $this->schedule[0]=array('start_time'=>0,'target_day'=>3); $this->schedule[1]=array('start_time'=>13,'target_day'=>4); $this->schedule[2]=array('start_time'=>13,'target_day'=>5); $this->schedule[3]=array('start_time'=>13,'target_day'=>6); $this->schedule[4]=array('start_time'=>15,'target_day'=>2); $this->schedule[5]=array('start_time'=>0,'target_day'=>2); $this->schedule[6]=array('start_time'=>14,'target_day'=>3); } function EarliestArrival(){ $current_day=date('w'); $current_time=date('G'); //any time of the hour will be considered past the hour $prev_day=($current_day!=0) ? $current_day-1 : 6; $target=($current_time>=$this->schedule[$current_day]['start_time']) ? $this->schedule[$current_day]['target_day'] : $this->schedule[$prev_day]['target_day']; $days_needed=($current_day<=$target) ? $target-$current_day : (7-$current_day)+$target; $this->earliest_date=mktime(0,0,0,date('m'),date('d')+$days_needed,date('Y')); } function DateStillValid($shipdate){ if(!isset($this->earliest_date))$this->EarliestArrival(); $result=($this->earliest_date>$shipdate) ? false : true; return $result; } function DateInfo($datestamp){ //This functions returns an array containing info about whether a date is valid for delivery //and the CSS class for the calendar. The classes are defined in calendar.css //Currently Sunday is considered invalid and Saturday is a different class, //although for now its class is defined the same as other valid days. if(!isset($this->earliest_date))$this->EarliestArrival(); if($datestamp>=$this->earliest_date){ if(date('w',$datestamp)==6){ $result['valid']=true; $result['class']='s_valid'; }elseif(date('w',$datestamp)==0){ $result['valid']=false; $result['class']='invalid'; }else{ $result['valid']=true; $result['class']='valid'; } }else{ $result['valid']=false; $result['class']='invalid'; } return $result; } } ?> Thanks for any help you can give Jeff
  8. jeffjb

    Order Tracker New Contrib....

    yes it does. thank you very much and it works like a charm. very nice report again thank you. :D
  9. jeffjb

    Order Tracker New Contrib....

    do you have the changes off hand or were they that minor?
  10. jeffjb

    Order Tracker New Contrib....

    will this work on ms1 if I edit application_top.php instead of filename.php? or is the db structure wrong? Also If my prices change alot will this give amounts based on current price or based on the price at the time of a sale? I am currently running sales report2 and would like something with a little more meat. Thanks Jeff
  11. i thought the add color red would turn the code I changed red. this was only so you could see what I changed. Thanks again
  12. My site has been getting poeple who do the purchase without an account then when they see the shipping charge they leave. So I am trying to make my recover cart sales mod tell me if the did purchase without an account. I am trying to write an if statment that querys the customer_table/purchase_without_account. if it is one I want to echo pwa next to their name. However when in my if statment it seems to always return a 1. I can query the db directly or through php my admin and get the right return 0 on most 1 on the pwa people. Here is most of the recover_cart.php please help if you see what I am doing wrong. <?php $tdate = $_POST['tdate']; if ($_POST['tdate'] == '') $tdate = $BASE_DAYS; $ndate = seadate($tdate); $query1 = tep_db_query("select cb.customers_id cid, cb.products_id pid, cb.customers_basket_quantity qty, cb.customers_basket_date_added bdate, cus.customers_firstname fname, cus.customers_lastname lname, [COLOR=red]cus.purchased_without_account pwa,[/COLOR] cus.customers_telephone phone, cus.customers_email_address email from " . TABLE_CUSTOMERS_BASKET . " cb, " . TABLE_CUSTOMERS . " cus where cb.customers_basket_date_added >= '" . $ndate . "' and cb.customers_id = cus.customers_id order by cb.customers_basket_date_added desc, cb.customers_id "); $results = 0; $curcus = ""; $tprice = 0; $totalAll = 0; $knt = mysql_num_rows($query1); $first_line = true; for ($i = 0; $i <= $knt; $i++) { $inrec = tep_db_fetch_array($query1); [COLOR=red]if ($inrec['pwa'] = '1' ) { $PWADEL = PWA; }[/COLOR] if ($curcus != $inrec['cid']) { // output line $totalAll += $tprice; $tcart_formated = $currencies->format($tprice); $cline .= " </td> <tr> <td class='dataTableContent' align='right' colspan='8'><b>" . TABLE_CART_TOTAL . "</b>" . $tcart_formated . "</td> </tr> </tr>"; if ($curcus != "") echo $cline; // set new cline and curcus $curcus = $inrec['cid']; if ($curcus != "") { $tprice = 0; // // change the color on those we have contacted // add customer tag to customers // $fcolor = $UNCONTACTED_COLOR; $sentdate = ""; $customer = ""; $donequery = tep_db_query("select * from ". TABLE_SCART ." where customers_id = '".$curcus."'"); $emailttl = seadate($EMAIL_TTL); if (mysql_num_rows($donequery) > 0) { $ttl = tep_db_fetch_array($donequery); if ($emailttl <= $ttl['dateadded']) { $sentdate = $ttl['dateadded']; $fcolor = $CONTACTED_COLOR; } } $ccquery = tep_db_query("select * from " . TABLE_ORDERS . " where customers_id = '".$curcus."'" ); if (mysql_num_rows($ccquery) > 0) $customer = ' [<font color="' . $CURCUST_COLOR . '">' . TEXT_CURRENT_CUSTOMER . '</font>]'; $sentInfo = TEXT_NOT_CONTACTED; if ($sentdate != ''){ $sentInfo = cart_date_short($sentdate); } $cline = " <tr bgcolor=" . $fcolor . "> <td class='dataTableContent' align='center' width='1%'>" . tep_draw_checkbox_field('custid[]', $curcus) . "</td> <td class='dataTableContent' align='left' width='9%' nowrap><b>" . $sentInfo . "</b></td> <td class='dataTableContent' align='left' width='15%' nowrap> " . cart_date_short($inrec['bdate']) . "</td> <td class='dataTableContent' align='left' width='25%' nowrap><a href='" . tep_href_link(FILENAME_CUSTOMERS, 'search=' . $inrec['lname'], 'NONSSL') . "'>" . $inrec['fname'] . " " . $inrec['lname'] . "</a>".$customer."</td> <[COLOR=red]td class='dataTableContent' align='left' width='15%' nowrap><b>" . $PWADEL . "</b></td>[/COLOR] <td class='dataTableContent' align='left' colspan='2' width='25%' nowrap><a href='" . tep_href_link('mail.php', 'selected_box=tools&customer=' . $inrec['email']) . "'>" . $inrec['email'] . "</a></td> <td class='dataTableContent' align='right' colspan='2' width='15%' nowrap>" . $inrec['phone'] . "</td> </tr>"; } } // empty the shopping cart
  13. :o I am trying to right a query for the table purchased_without_account under customers. so I can tell in my sales cart mod and invoice that they purchaesed without a cart or did not complete the checkout and I need to delete the account. But can (being a complete php hack newbie) not get the right responce. can some one help here is what I have and the answer is always 1. $curcus = current customer id part of recover cart sales. $pwa_query = tep_db_query("select purchased_without_account from " . TABLE_CUSTOMERS . " where customers_id = '".$curcus."); I have also gone nuts and done this still always 1 $pwa_query = tep_db_query("select purchased_without_account from " . TABLE_CUSTOMERS . " where customers_id = '".$curcus."' and customers_default_address_id = '1'"); $pwa = tep_db_fetch_array($pwa_query); $opwa = (tep_db_output($pwa['purchased_without_account'])); thanks for any help on what I am doing wrong.
  14. Thank you Lee... This mod makes the newsletter and emails look great. that did fix my issue. Does the admin gui not pass your current user info to the files? Since my admin account has root rights I thought it could do whatever. Anyway thank you.
  15. I installed this mod and everything except the mainpage.php seems to work. When I goto admin -> define mainpage I get an error. however the user I am loged in as does have full read write access to the file. also the catalog/default.php messes my site up. I believe the two are related right? the mainpage.php defines the default.php page? thanks
×