Geniuscoder001 Private PRoject

We need a jsp file to run this sql to get invoice numbers that have not been tracked

select trans_id from user_trans where ( approve='1' or paypal_approve='1' or google_approve='1') and DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= trans_date and (confirmation_no is null or confirmation_no='');

data will have invoice numbers

| 671767 |

| 671769 |

| 671770 |

| 671771 |

| 671772 |

| 671777 |

| 671778 |

| 671779 |

| 671781 |

| 671782 |

| 671784 |

| 671783 |

then it will call this url and get an xml response

[url removed, login to view]

where tracking number is the invoice number

then it will insert the xml data into these 2 tables

create table DHLShipment (

trans_id int not null,

trackingnumber text not null,

deliveryconfirm text not null,

address1 text not null,

address2 text,

city text not null,

state text not null,

zip text not null,

weight double not null,

shipped date not null


create table DHLEvent (

trans_id int not null,

code int not null,

eventDate datetime not null,

city text not null,

state text not null,

description text not null,

postalcode text not null,

country text not null


and update table user_trans columns - confirmation_no with <deliveryconfirm> and dhl_tracking with <trackingnumber> where

trans_id <customerconfirm>

Beceriler: JSP, XML

Daha fazlasını gör: sql get date, where is invoice?, null, jsp project, int, insert date, cellular, call tracking, sql update text, xml invoice, weight project, double api, update text sql, sql call api, update insert sql, datetime, table tracking, city country api, sql update text text, insert table jsp, update sql table xml, project jsp sql, update tracking number, project api, track project

İşveren Hakkında:
( 197 değerlendirme ) Hacienda Heights, United States

Proje NO: #694565



thanks very much

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(2 Değerlendirme)