Revision 2773beb1
Von Moritz Bunkus vor fast 18 Jahren hinzugefügt
SL/IS.pm | ||
---|---|---|
978 | 978 |
# save AR record |
979 | 979 |
$query = qq|UPDATE ar set |
980 | 980 |
invnumber = '$form->{invnumber}', |
981 |
ordnumber = '$form->{ordnumber}',
|
|
982 |
quonumber = '$form->{quonumber}',
|
|
983 |
cusordnumber = '$form->{cusordnumber}',
|
|
981 |
ordnumber = '$form->{ordnumber}',
|
|
982 |
quonumber = '$form->{quonumber}',
|
|
983 |
cusordnumber = '$form->{cusordnumber}',
|
|
984 | 984 |
transdate = '$form->{invdate}', |
985 | 985 |
customer_id = $form->{customer_id}, |
986 | 986 |
amount = $amount, |
987 | 987 |
netamount = $netamount, |
988 | 988 |
paid = $form->{paid}, |
989 |
datepaid = $datepaid,
|
|
990 |
duedate = $duedate,
|
|
989 |
datepaid = $datepaid,
|
|
990 |
duedate = $duedate,
|
|
991 | 991 |
deliverydate = $deliverydate, |
992 |
invoice = '1',
|
|
993 |
shippingpoint = '$form->{shippingpoint}',
|
|
994 |
shipvia = '$form->{shipvia}',
|
|
995 |
terms = $form->{terms},
|
|
996 |
notes = '$form->{notes}',
|
|
997 |
intnotes = '$form->{intnotes}',
|
|
998 |
taxincluded = '$form->{taxincluded}',
|
|
999 |
curr = '$form->{currency}',
|
|
1000 |
department_id = $form->{department_id},
|
|
1001 |
payment_id = $form->{payment_id},
|
|
992 |
invoice = '1',
|
|
993 |
shippingpoint = '$form->{shippingpoint}',
|
|
994 |
shipvia = '$form->{shipvia}',
|
|
995 |
terms = $form->{terms},
|
|
996 |
notes = '$form->{notes}',
|
|
997 |
intnotes = '$form->{intnotes}',
|
|
998 |
taxincluded = '$form->{taxincluded}',
|
|
999 |
curr = '$form->{currency}',
|
|
1000 |
department_id = $form->{department_id},
|
|
1001 |
payment_id = $form->{payment_id},
|
|
1002 | 1002 |
type = '$form->{type}', |
1003 |
language_id = $form->{language_id},
|
|
1004 |
taxzone_id = $form->{taxzone_id},
|
|
1005 |
shipto_id = $form->{shipto_id},
|
|
1006 |
delivery_customer_id = $form->{delivery_customer_id},
|
|
1007 |
delivery_vendor_id = $form->{delivery_vendor_id},
|
|
1008 |
employee_id = $form->{employee_id},
|
|
1003 |
language_id = $form->{language_id},
|
|
1004 |
taxzone_id = $form->{taxzone_id},
|
|
1005 |
shipto_id = $form->{shipto_id},
|
|
1006 |
delivery_customer_id = $form->{delivery_customer_id},
|
|
1007 |
delivery_vendor_id = $form->{delivery_vendor_id},
|
|
1008 |
employee_id = $form->{employee_id},
|
|
1009 | 1009 |
storno = '$form->{storno}', |
1010 | 1010 |
cp_id = $form->{contact_id} |
1011 | 1011 |
WHERE id = $form->{id} |
Auch abrufbar als: Unified diff
Tabs in Query entfernt.