Закрыт

Golang Mysql and tmpl phase 3 ( small addons )

Hi, I just need some small addon to my code.

1 ist add a pre-build fun and a make this query to work on my MySQL 8 server

the idea is to have the func pass the data to my already done UI

the table is :

CREATE TABLE `maverage` (

`id` int(7) unsigned NOT NULL AUTO_INCREMENT,

`provider` varchar(35) DEFAULT NULL, /* select from benefic table */

`af1` int(7) DEFAULT NULL,

`af2` int(7) DEFAULT NULL,

`am1` int(7) DEFAULT NULL,

`am2` int(7) DEFAULT NULL,

`at1` int(7) DEFAULT NULL,

`at2` int(7) DEFAULT NULL,

`media` int(7) DEFAULT NULL, /* sum of af1 to at2 divided by 6 */

`largura` int(7) DEFAULT NULL,

`comprimento` int(7) DEFAULT NULL,

`pmc` int(7) DEFAULT '2.50', /* price per cubic meters */

`totalmedida` int(7) DEFAULT NULL, /* will be media x largura x cumprimento */

`totalprice` int(7) DEFAULT NULL, /* will be result of totalmedida x pmc

and the format needs to be lkie 1.000,00 if the result is 1000

for example. */

`dtcompra` date DEFAULT NULL,

`dtentrega` date DEFAULT NULL,

`status` varchar(15) DEFAULT NULL, /* Pago, Parcial, Em Aberto, Outro */

`obs` text,

`data_criado` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

INSERT INTO `maverage` VALUES (1, 'madeiras comp', 2.52, 2.45, 2.72, 2.65, 2.51, 2.49, 2.55, 10.50, 3.25, 2.50, 87.01, 221.87, '2020-03-03', '2020-03-05', 'Pago', ' Lenha ceca', '2020-03-05 00:00:01');

INSERT INTO `maverage` VALUES (1, 'lugar da madeira', 2.53, 2.46, 2.73, 2.66, 2.52, 2.50, 2.56, 10.20, 3.15, 2.50, 82.25, 205.62, '2020-04-05', '2020-03-07', 'Pago', ' Lenha ceca', '2020-03-06 00:00:02');

SELECT af1, af2, am1, am2, at1, at2 sum(af1 +f2 + am1 + am2 + at1 + at2') as total, sum( af1 + af2 + am1 + am2 + at1 + at2)/6 as avg from maverage group by id

I have controller and struct example as well

the Ui is done as well

Квалификация: MySQL, Golang

Показать больше awesome go, golang database best practices, sqlx, golang boilerplate, golang mysql connection pool, golang orm 2019, golang crud mysql, jinzhu, DESIGN 3 SMALL HOUSES, phase 3, Shunt Active Power Filter by using PQ theory control method for 3 Phase 3 wire system., m city phase 3, m city condos phase 3, central subway phase 3, brandywine crossing phase 3, gold line extension phase 3, pavan brundavan phase 3, golang mysql queryrow, project jasper phase 3, mysql workbench 6.3 create database

О работодателе:
( 8 отзыв(-а, -ов) ) Engenheiro Caldas, Brazil

ID проекта: #24609776

5 фрилансеров(-а) в среднем готовы выполнить эту работу за $15

abugosia

Hello, I'm Abu Gosia. I'm interesting your project very well. I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. I m quite well experienced in these j Больше

$25 USD за 1 день
(38 отзывов(-а))
5.6
bdphpguru

Dear Sir, Able to start right now. I have more than 2+ years experience in web and deskop application development using C#.Net , mysql,php. Twillio sms gateway api,paypal api several api like twitter, bitcoin. I rea Больше

$13 USD за 1 день
(38 отзывов(-а))
4.6
uga5a1795865a783

Hey,I have extensive experience in golang and mysql.I will be able to finish this with ease.I am interested to work on [login to view URL] case if you are interested as we can discuss further and close this ASAP. Thanks

$15 USD за 1 день
(2 отзывов(-а))
1.4
Illia3

Hello. I can do it for 30 mins. If you trust me, thank you. And hire me, I can start now and I can finish your project perfectly. Best Regards

$10 USD за 1 день
(1 отзыв)
0.0
namalwixis360

Hi, Seems this is very small task in basic sql. I have been in the industry last 15 years and this can be done very easily by myself free of charge. if you are interested please contact me. Thanks, Namal

$13 USD за 7 дней(-я)
(0 отзывов(-а))
0.0