Optimaler Lagerweg - PHP / Mysql

Annullerat Publicerat 6 år sedan Betalades vid leverans
Annullerat Betalades vid leverans

Hallo,

wir suchen jemanden der uns ein Script erstellt, dieses Script soll brauch kein Interface o.Ä. - es reicht eine PHP Function die aufgerufen wird.

Es geht um eine Lager-Pickliste

Es soll uns die "besten Lagerplätze" für eine Packliste raus suchen.

D.h. wir möchten so wenig unterschiedliche Lagerplätze wie möglich auf der Packliste stehen haben.

Wir stellen 1 Datenbank zur Verfügung die wie folgt aufgebaut ist:

CREATE TABLE `products_ids` (

`id` int(11) NOT NULL,

`products_id` int(11) NOT NULL,

`attribute_id` int(11) NOT NULL,

`kennung` varchar(50) NOT NULL,

`status` enum('Bestand','Verkauft') NOT NULL,

`time` int(20) NOT NULL,

`lagerplatz` varchar(10) NOT NULL,

`ek` double(6,2) NOT NULL,

`vk` double(6,2) NOT NULL,

`bestellnr` int(11) NOT NULL,

`gruppierung` varchar(100) NOT NULL,

`zu_voroderid` int(11) NOT NULL,

`alter` int(20) NOT NULL,

`bearbeitet_von` int(11) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `products_ids`

ADD PRIMARY KEY (`id`),

ADD KEY `id` (`id`),

ADD KEY `products_id` (`products_id`),

ADD KEY `attribute_id` (`attribute_id`);

ALTER TABLE `products_ids`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

in dieser Datenbank sind alle Artikel enthalten die derzeit gelagert sind.

Wir übergeben jetzt z.b. ein Array in PHP mit folgenden Werten

$products = array(

array("13653","81088"),

array("13653","81089"),

array("13653","81093"),

array("13653","81088"),

);

d.h. wir suchen

1x product_id = 13653 and attribute_id=81088 and status='bestand' and lagerplatz!='vororder'

1x product_id = 13653 and attribute_id=81089 and status='bestand' and lagerplatz!='vororder'

1x product_id = 13653 and attribute_id=81093 and status='bestand' and lagerplatz!='vororder'

1x product_id = 13653 and attribute_id=81088 and status='bestand' and lagerplatz!='vororder'

---

ja auch doppelte Einträge können dir vorkommen.

Wenn wir jetzt einen Lagerort haben wo alle 4 Artikel in einem Karton (Lagerort) vorhanden sind möchte ich genau diesen in die DB gespeichert haben.

D.h. am Ende sollten so wenig unterschiedliche Lagerplätze in der Datenbank stehen wie nur möglich.

Kann dies einer umsetzen?

Översättare (tyska) MySQL PHP

Projekt-id: #15207301

About the project

21 offerter Distansprojekt Aktivt 6 år sedan

21 frilansare har lagt bud på i genomsnitt €178 för det här jobbet

extreamcode

HI Sir/Madam, I can assist you with "Optimaler Lagerweg - PHP / Mysql", I have experience working with "similar Development". Let's have a quick chat to discuss it further. I have been in this "Development" field f Mer

€246 EUR inom 11 dagar
(78 omdömen)
7.6
abdulghaffar11

Hi, its pretty simple for me but I have few questions to ask, knock me for further discussion, PLEASE DON'T AWARD PROJECT BEFORE DISCUSSION. Thank You!

€100 EUR inom 3 dagar
(87 omdömen)
6.2
Websitemaestro

Hi, Thanks for the opportunity. I have completed sucessfull project in past and worked on different segments for mobile apps and web admin panel Please spare a moment to discuss this project. so i can clea Mer

€155 EUR inom 7 dagar
(75 omdömen)
6.4
miracitech37

hello we have expertise in a website . we have developed we have 100 of website ping me on chat I will be explained more about my experience I do not have much space to write I have 10 years of experience Mer

€155 EUR inom 3 dagar
(40 omdömen)
6.1
artifexonline

Hi, I have reviewed your requirement and I can do this job as per your requirement. We have huge expertise in WORDPRESS ,Payment gateway, Laravel, Node.Js , React.Js, CakePHP, Codeigniter, Angular.js, Bootstrap, AP Mer

€155 EUR inom 3 dagar
(33 omdömen)
5.8
vineetvrm05

Hi, I know I can definitely make it work, I have developed more than 1000 of WP themes so far you can ask me any question of your choice regarding the work and I can surely answer it. German, MySQL, PHP / Full sta Mer

€166 EUR inom 3 dagar
(29 omdömen)
5.3
BeautiCG

how are you,sir? I am a professional developer who has rich experience in this field. If you contact me, you and i will all be happy. Thank you for your reply in advance. ProjectName:Optimaler Lagerweg - PHP / Mysql Mer

€155 EUR inom 1 dag
(15 omdömen)
4.8
caperaservices

I'm a web and app developer with 7 years experience in PHP, MySQL, CSS3, HTML5,android and WordPress, WP plugins, and 3rd party API shopping engines, etc.

€155 EUR inom 3 dagar
(9 omdömen)
4.2
varinderkaurcode

yes after go through your job details I assure to you that I am complete your work using my development skills with perfection and complete it in your timeline . I am a Senior PHP Developer with lot of experience i Mer

€244 EUR inom 3 dagar
(2 omdömen)
2.0
ashagami

Hello I am ready to start this work from now. I have more than 5 years of professional developing experience and advanced computer skills. I have done the projects in core php, codeignitor, Javascript, Symfony PHP Mer

€122 EUR inom 3 dagar
(0 omdömen)
0.0