Addition in mysql query Magento

$10-30 USD

Terminado

Publicado

hace más de 9 años

$10-30 USD

Pagado a la entrega

I have this query which fetches all customer info + billing info + payment info. I want to fetch customer password as well from magento db. So need addition of customer password column. SELECT increment_id,customer_email,[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],sfoa.country_id,[login to view URL],[login to view URL],sfop.cc_owner,sfop.cc_type,sfop.cc_exp_month,sfop.cc_exp_year,sfop.cc_secure_verify,sfop.cc_approval,sfop.cc_last4,sfop.cc_number_enc FROM `sales_flat_order` as sfo left join sales_flat_order_address as sfoa on sfoa.parent_id = sfo.entity_id left join sales_flat_order_payment as sfop on sfop.parent_id=sfo.entity_id where sfoa.address_type='billing' Need it done ASAP!

Magento

MySQL

PHP

ID del proyecto: 6938674

Información sobre el proyecto

6 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@jesus2010

Hi, I'm magento developer certified ([login to view URL]), and you can not show the field "password" exactly, but you can show "password hash" field with md5 encryptation. Thanks.

$25 USD en 1 día

3,0

(1 comentario)

2,7

6 freelancers están ofertando un promedio de $34 USD por este trabajo

@devikagupta

hello sir, i can do your project.... please accept my bid so that i can start it... i m expert in this type of project... u can also see my portfolio... please sir accept my bid.. please hope u will do i m waiting for your response.. thank you.. :)

$24 USD en 0 día

4,9

(149 comentarios)

5,6

@davaidwilliam

A proposal has not yet been provided

$25 USD en 1 día

5,0

(34 comentarios)

5,5

@amiardeshana

Hello Client, Lets complete your task immediately. I would like to take opportunity to work with you on your Magento & MYSQL requirement. Basically, I need to fetch customer password from the DB. Lets make it done quickly. We are Logic Express providing IT Services remotely for our global clients since +8yrs Our Expert Team have a strong hand on following Tech/Languages: | Twitter Bootstrap | PHP | HTML 5 | CSS 3 | AJAX | MySQL | jQuery | JSON | CMS | Designing | javascript Looking forward to discuss on scope in detail. My Skype: le_amee Thanks & Regards, Ami

$21 USD en 1 día