washem

the compound pricing is wrong when using the click to pay button. Regular price
Add to cart/checkoput seems ok compound price
screenshots below

View post on imgur.com

any tips on a query that simply generates a single result where an field =”x”?

SELECT submit_time AS ‘Submitted’,
max(if(field_name=’text’, field_value, null )) AS ‘text’,
max(if(field_name=’How much laundry do you have?’, field_value, null )) AS ‘How much laundry do you have?’,
max(if(field_name=’basketsnumber’, field_value, null )) AS ‘basketsnumber’,
max(if(field_name=’How much ironing do you have?’, field_value, null )) AS ‘How much ironing do you have?’,
max(if(field_name=’shirtimage’, field_value, null )) AS ‘shirtimage’,
max(if(field_name=’shirtsnumber’, field_value, null )) AS ‘shirtsnumber’,
max(if(field_name=’Estimate’, field_value, null )) AS ‘Estimate’,
max(if(field_name=’Email Address’, field_value, null )) AS ‘Email Address’,
max(if(field_name=’GretText’, field_value, null )) AS ‘GretText’,
max(if(field_name=’First Name’, field_value, null )) AS ‘First Name’,
max(if(field_name=’Surname’, field_value, null )) AS ‘Surname’,
max(if(field_name=’Mobile number’, field_value, null )) AS ‘Mobile number’,
max(if(field_name=’Pickup date’, field_value, null )) AS ‘Pickup date’,
max(if(field_name=’Pickup time’, field_value, null )) AS ‘Pickup time’,
max(if(field_name=’Delivery date’, field_value, null )) AS ‘Delivery date’,
max(if(field_name=’Delivery time’, field_value, null )) AS ‘Delivery time’,
max(if(field_name=’Fantastic, let\’s continue (1/3) >>’, field_value, null )) AS ‘Fantastic, let\’s continue (1/3) >>’,
max(if(field_name=’OrderNumber’, field_value, null )) AS ‘OrderNumber’,
max(if(field_name=’Select Your Level of Care’, field_value, null )) AS ‘Select Your Level of Care’,
max(if(field_name=’Total Care’, field_value, null )) AS ‘Total Care’,
max(if(field_name=’Pre Wash Garment Check’, field_value, null )) AS ‘Pre Wash Garment Check’,
max(if(field_name=’Pre Wash Stain Removal’, field_value, null )) AS ‘Pre Wash Stain Removal’,
max(if(field_name=’Separate Whites & Colours’, field_value, null )) AS ‘Separate Whites & Colours’,
max(if(field_name=’Whiter Whites Wash’, field_value, null )) AS ‘Whiter Whites Wash’,
max(if(field_name=’Total’, field_value, null )) AS ‘Total’,
max(if(field_name='<< Previous page’, field_value, null )) AS ‘<< Previous page’,
max(if(field_name=’Next (2/3) >>’, field_value, null )) AS ‘Next (2/3) >>’,
max(if(field_name=’Pickup Information’, field_value, null )) AS ‘Pickup Information’,
max(if(field_name=’Pick Up Address’, field_value, null )) AS ‘Pick Up Address’,
max(if(field_name=’I will be in attendance’, field_value, null )) AS ‘I will be in attendance’,
max(if(field_name=’Driver Notes’, field_value, null )) AS ‘Driver Notes’,
max(if(field_name=’Laundry Packaging’, field_value, null )) AS ‘Laundry Packaging’,
max(if(field_name=’How is your laundry packaged for pick up?’, field_value, null )) AS ‘How is your laundry packaged for pick up?’,
max(if(field_name=’total+packaging’, field_value, null )) AS ‘total+packaging’,
max(if(field_name=’Terms TExt’, field_value, null )) AS ‘Terms TExt’,
max(if(field_name=’I agree to the terms and conditions’, field_value, null )) AS ‘I agree to the terms and conditions’,
max(if(field_name='<< Previous’, field_value, null )) AS ‘<< Previous’,
max(if(field_name=’Finalise >>’, field_value, null )) AS ‘Finalise >>’,
max(if(field_name=’stripe_id’, field_value, null )) AS ‘stripe_id’,
max(if(field_name=’stripe_amount’, field_value, null )) AS ‘stripe_amount’,
max(if(field_name=’stripe_created’, field_value, null )) AS ‘stripe_created’,
max(if(field_name=’fillalldetailstxt’, field_value, null )) AS ‘fillalldetailstxt’,
max(if(field_name=’Submitted Login’, field_value, null )) AS ‘Submitted Login’,
max(if(field_name=’Submitted From’, field_value, null )) AS ‘Submitted From’,
GROUP_CONCAT(if(file is null or length(file) = 0, null, field_name)) AS ‘fields_with_file’
FROM wp_cf7dbplugin_submits
WHERE form_name = ‘Washem Purchase v2.1’
GROUP BY submit_time
ORDER BY submit_time DESC
LIMIT 0,100

adding

and field_value = 100

or if I used ‘Orderznumber’=109

nothing happens?

returns nulls with ordernumber 100?