David R. L. C. freelancer experto en Tiendas virtuales (ecommerce), ERP, PostgresSQL

David R. L. C.

Si existe la posibilidad, es posible.

0 / 5

Mexico

IT & Programación

Habilidades (Máximo: 5)
¿Qué es posición de perfil bronze?

Bronze es el segundo nivel de los freelancers de Workana. A medida que consigan más logros y ganen más proyectos, irán progresando hacia los niveles superiores. Leer más

Sobre mí
Deportista, amante de la TI, autentico, amoroso y creativo.
Esto me lleva a hacer mi trabajo único, con pasion y totalmente ingenioso.
Historia laboral
Mr. Fix
Creacion de software para diagnostico de equipos reparados, basado en scripts de linux e interfas hecha en tcl-tk, el mismo se ejecutaba sobre ubuntfix, una distribucion linux basada en ubuntu hecha a medida y funcional e instalable dese usb.
https://www.youtube.com/watch?v=8GLBym7i63k
ejemplo de un script:
#!/bin/sh

echo "El sistema tomara datos del equipo y guardara en un archivo datos.txt"
echo "por parte de Mr.Fix"

cd /tmp
echo "Espera un momento estoy recopilando informacion de este equipo" | festival --tts --language spanish
echo  \\n > espacio
echo "En este documento encontrará las características y estado general de su equipo, cualquier duda al respecto de la información que aquí se muestra, favor de preguntar a su agente mr. Fix." > intro
echo "Los datos del equipo que aquí se muestran son únicamente informativos, no tienen ningún valor legal y se entregan con el único fin de mantenerlo informado del completo estado en que se encuentra su equipo, así como sus componentes, Mr. Fix no se hace responsable por fallas futuras." > legales
echo Bios > 0
sudo dmidecode --type 0 | grep -e "Vendor" -e "Version" -e "Date" -e "Size" >> 0
echo Equipo > 1
sudo dmidecode --type 1 | grep -e "Manufacturer" -e "Product" -e "Version" -e "Serial" -e "UUID" -e "SKU" -e "Family" >> 1
echo Tarjeta Madre > 2
sudo dmidecode --type 2 | grep -e "Manufacturer" -e "Product" -e "Version" -e "Serial" >> 2
echo Bateria > 22
acpi >> 22
acpi -V | grep -e "Adapter" -e "Thermal" >> 22
echo Vida útil de la batería en % si es menor al 20% se recomienda remplazar la batería >> 22
acpi -V | grep -e "last full" >> 22
sudo dmidecode --type 22 | grep -e "Location" -e "Manufacturer" -e "Serial" -e "Name" -e "Chemistry" -e "Design" >> 22
echo Memoria Ram > 16
cat /proc/meminfo | grep -e "MemTotal" >> 16
sudo dmidecode --type 16 | grep -e "Maximum"  >> 16
echo Procesador > hw
hwinfo --cpu | grep -e "Model" >> hw
sudo dmidecode --type processor | grep -e "Processor" -e "Socket" -e "Family" -e "Manufacturer" -e "ID" -e "Version" -e "Voltage" -e "Clock" -e "Speed" >> hw
echo Video >> hw
hwinfo --gfxcard | grep -e "Model" -e "Vendor" -e "SubVendor" >> hw
echo Sonido >> hw
hwinfo --sound | grep -e "Model" >> hw
cat sonido >> hw
echo Red >> hw
hwinfo --netcard | grep -e "Model" >> hw
cat wifi >> hw
echo Disco Duro >> hw
hwinfo --disk | grep -e "Model" >> hw
echo Capacidad >> hw
sudo fdisk -l | grep "Disco" >> hw
cat disco >> hw
echo Unidad Optica >> hw
hwinfo --cdrom | grep -e "Model" -e "Features" >> hw
echo Camara Web >> hw
hwinfo --short | grep -e "webcam" -e "Camera" -e "Webcam" >> hw
cat webcam >> hw
sudo dmidecode --type 17 | grep -e "Bank" -e "Type" -e "Size" -e "Speed" > 17
date > horaf
acpi >> horaf
cat intro espacio hora 1 0 2 16 17 hw 22 espacio teclado mouse espacio temperaturas espacio comentarios espacio horaf espacio legales > ~/Escritorio/datos.txt
gedit ~/Escritorio/datos.txt

Bermac S.A. de C.V.
Migracion de windows a linux, soporte tecnico remoto, mantenimiento y respponsable de openbravo 2.5, llevandolo a version comunidad.

ejemplo de algunos scripts echos a Bermac
este era cuando algun documento se quedaba procesando y trababa el resto de las operaciones en el pos.
#!/bin/bash



psql -c "update c_bpartner set em_be_bunit_org_id='7329A2B88EEE42A5957201097B066B14' where em_be_bunit_org_id is null;" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_receivable_acct ='D24D39925EFA4B48A96498ED11675E82' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '7329A2B88EEE42A5957201097B066B14';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_receivable_acct ='C6653BAAA1C540C18983902C74E2F7C3' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '89B3A15A26674309B09C6180ACBA2EE3';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_receivable_acct ='5801F53D9B3342D88C00C710F971AE88' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '52E6F614D8494F4FBCACE8624746041E';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_receivable_acct ='AF6A1DB4557340F7AE0193BB27707D1F' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '977FE937C0F4428A9CEB164E08077CC5';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_receivable_acct ='9961C1EE47134D4C8884A98BB826EF1D' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '3A7B4604A4C743758BEB5BBE9DA315EC';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_receivable_acct ='5348D15283CA4DE4B0BCF52EA1FC930B' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = 'B474EE8A028D4B798D1A1ACFE80BA119';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_receivable_acct ='88186785A83D4C538ACBA768B79F729F' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '0DACCB58E5BA4486B0BCDD448885CB3D';" -d ob_bermac -h localhost -U postgres -p 5832



psql -c "update c_bp_customer_acct set c_prepayment_acct ='8FAF5A82B7EF4684B0553D2D5F91A25B' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '7329A2B88EEE42A5957201097B066B14';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_prepayment_acct ='8D5B73875B6642EE8A44BAEB7520EDA9' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '89B3A15A26674309B09C6180ACBA2EE3';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_prepayment_acct ='24ED7413906C4A4A97680EAE4C5EC369' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '52E6F614D8494F4FBCACE8624746041E';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_prepayment_acct ='AD61CD75AF1348BFAD3559862FA8C695' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '977FE937C0F4428A9CEB164E08077CC5';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_prepayment_acct ='94EB725CCB46451FBB3571DCA6D26025' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '3A7B4604A4C743758BEB5BBE9DA315EC';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_prepayment_acct ='1B8D5ED72A6B4D52BF26F58F7F7650DC' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = 'B474EE8A028D4B798D1A1ACFE80BA119';" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update c_bp_customer_acct set c_prepayment_acct ='FFA32F6AD197448C91BC6FF0A0E9B909' FROM public.c_bpartner WHERE c_bpartner.c_bpartner_id = c_bp_customer_acct.c_bpartner_id AND c_bpartner.em_be_bunit_org_id = '0DACCB58E5BA4486B0BCDD448885CB3D';" -d ob_bermac -h localhost -U postgres -p 5832


psql -c "update c_invoice set processing='N' where processing='Y' and dateinvoiced < current_date - 1;" -d ob_bermac -h localhost -U postgres -p 5832

psql -c "update fin_payment set processing='N' where processing='Y' and paymentdate < current_date - 1;" -d ob_bermac -h localhost -U postgres -p 5832

Habilitar y desabilitar usuarios por cron a cierto horario, afectaba a los que en comentarios tubieran la leyenda "horario"

#!/bin/bash
psql -c "update ad_user set isactive ='Y' where comments LIKE '%horario%';" -d ob_bermac -h localhost -U postgres -p 5832

#!/bin/bash
psql -c "update ad_user set isactive ='N' where comments LIKE '%horario%';" -d ob_bermac -h localhost -U postgres -p 5832

Actualmente manejo odoo 10 y lo estoy implementando en microempresas.
para pos e inventarios, y algunas como e-commerce

manejo de bash linux, administracion remota, virtualbox, teamviewer.
configuracion de routers y puertos.
Contratar

Rankeado: No está rankeado

Posición del perfil: Bronze

Último login: Hace 3 meses

Registrado: Hace 4 meses