[SOLVED] Customization file upload 1.7

[dakendalliii]

Hey all,

I'm developing a new 1.7 shop that is going to sell virtual product.  We need the customer to upload a picture and then forward that picture to another server for processing.  I have created a module to perform the forwarding procedure, but I can't determine which uploaded file (which has an encoded name) is associated with the logged in customer (there will be no "guest" customers).  Does anyone know how to identify the file that is uploaded with a specific order/customer?

Thank you!!!!

Dave

[Janett]

Customized data are stored in customized_data table.

Uploaded file are data with "type" = 0 (Constant value is Product::CUSTOMIZE_FILE )

So you can find the customization associated with the id_cart and id_product

SELECT cd.value AS file
FROM ps_customization AS c
INNER JOIN ps_customized_data AS cd ON (cd.id_customization = c.id_customization)
WHERE cd.type = 0
AND c.id_product = 19
AND c.id_cart = 6

Should return something like "b4b22ae6de73dafc74fae848b22e4715", that's the filename

If you have multiple customization fields of type upload you have to target on it specifically to retrieve one value. So add ps_customization_field in the query to be sure to retrieve the value for the right field. Customization Field associated can be find with "index" of ps_customized_data value (Yes that's weird)

Edited March 24, 2019 by Janett (see edit history)

[dakendalliii]

Janett,

That's exactly the information I was looking for!

Thanks for your help and I will mark the post resolved

[Douglas Leal]

Em 23/03/2019 em 9:14 PM, dakendalliii disse:

Hey all,

I'm developing a new 1.7 shop that is going to sell virtual product.  We need the customer to upload a picture and then forward that picture to another server for processing.  I have created a module to perform the forwarding procedure, but I can't determine which uploaded file (which has an encoded name) is associated with the logged in customer (there will be no "guest" customers).  Does anyone know how to identify the file that is uploaded with a specific order/customer?

Thank you!!!!

Dave

Hi dakendalliii,

Can you give me more information about the module you created? I need a similar solution. I need product customization to securely accept other file extensions besides jpg, png and gif that is allowed by prestashop.