Raga urge aiutino
Mi stò raggomitolando su me stesso,

Dovrei creare una tabella con il target di visita per singola filiale, ma non capisco come fare visto che la logica contempla qualche condizione, spiego in dettaglio.

Semplifico molto le cose, diciamo che sono in possesso dei seguenti dati:
[list=1][*]Filiali; elenco delle filiali con la relativa quantità di clienti da visitare [*]Users; numero di personale preposto alle visite suddiviso per filialie di appartenenza [*]Calendario; tabella con le date dal quale estrapolare le week[/list=a]

Quindi, la tabella dei target che vorrei creare dovrebbe dirmi quanti clienti può visitare ognuna filiale, considerando appunto la forza lavoro ( numero di personale; user ) e considerando di non andare oltre la 26^ week dell'anno, cercando inoltre di non assegnare valori sotto l'unità, ( intendo 0,1 ; ovviamente se faccio una semplice divisione otterrò numeri decimali sotto lo zero, questo vorrei evitarlo )

in pratica vorrei avere una tabella finale con i seguenti campi;
[list=1][*]id_target[*]Filiale; codice della filiale [*]week; numero della week dell'anno[*]totale_visite; totale delle visite che può fare la filiale [/list=a]

ovviamente ci saranno delle filiali che avranno le ultime week senza valore perchè avranno terminato le visite prima della 26^ week

posto il dump delle tabelle, mi date una mano ? thanks

codice:
-- Database: `target`

CREATE TABLE IF NOT EXISTS `cal` (
  `data` date NOT NULL,
  KEY `data` (`data`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `cal` (`data`) VALUES
('2011-05-01'),
('2011-05-02'),
('2011-05-03'),
('2011-05-04'),
('2011-05-05'),
('2011-05-06'),
('2011-05-07'),
('2011-05-08'),
('2011-05-09'),
('2011-05-10'),
('2011-05-11'),
('2011-05-12'),
('2011-05-13'),
('2011-05-14'),
('2011-05-15'),
('2011-05-16'),
('2011-05-17'),
('2011-05-18'),
('2011-05-19'),
('2011-05-20'),
('2011-05-21'),
('2011-05-22'),
('2011-05-23'),
('2011-05-24'),
('2011-05-25'),
('2011-05-26'),
('2011-05-27'),
('2011-05-28'),
('2011-05-29'),
('2011-05-30'),
('2011-05-31'),
('2011-06-01'),
('2011-06-02'),
('2011-06-03'),
('2011-06-04'),
('2011-06-05'),
('2011-06-06'),
('2011-06-07'),
('2011-06-08'),
('2011-06-09'),
('2011-06-10'),
('2011-06-11'),
('2011-06-12'),
('2011-06-13'),
('2011-06-14'),
('2011-06-15'),
('2011-06-16'),
('2011-06-17'),
('2011-06-18'),
('2011-06-19'),
('2011-06-20'),
('2011-06-21'),
('2011-06-22'),
('2011-06-23'),
('2011-06-24'),
('2011-06-25'),
('2011-06-26'),
('2011-06-27'),
('2011-06-28'),
('2011-06-29'),
('2011-06-30'),
('2011-07-01'),
('2011-07-02'),
('2011-07-03'),
('2011-07-04'),
('2011-07-05'),
('2011-07-06'),
('2011-07-07'),
('2011-07-08'),
('2011-07-09'),
('2011-07-10'),
('2011-07-11'),
('2011-07-12'),
('2011-07-13'),
('2011-07-14'),
('2011-07-15'),
('2011-07-16'),
('2011-07-17'),
('2011-07-18'),
('2011-07-19'),
('2011-07-20'),
('2011-07-21'),
('2011-07-22'),
('2011-07-23'),
('2011-07-24'),
('2011-07-25'),
('2011-07-26'),
('2011-07-27'),
('2011-07-28'),
('2011-07-29'),
('2011-07-30'),
('2011-07-31'),
('2011-08-01'),
('2011-08-02'),
('2011-08-03'),
('2011-08-04'),
('2011-08-05'),
('2011-08-06'),
('2011-08-07'),
('2011-08-08'),
('2011-08-09'),
('2011-08-10'),
('2011-08-11'),
('2011-08-12'),
('2011-08-13'),
('2011-08-14'),
('2011-08-15'),
('2011-08-16'),
('2011-08-17'),
('2011-08-18'),
('2011-08-19'),
('2011-08-20'),
('2011-08-21'),
('2011-08-22'),
('2011-08-23'),
('2011-08-24'),
('2011-08-25'),
('2011-08-26'),
('2011-08-27'),
('2011-08-28'),
('2011-08-29'),
('2011-08-30'),
('2011-08-31'),
('2011-09-01'),
('2011-09-02'),
('2011-09-03'),
('2011-09-04'),
('2011-09-05'),
('2011-09-06'),
('2011-09-07'),
('2011-09-08'),
('2011-09-09'),
('2011-09-10'),
('2011-09-11'),
('2011-09-12'),
('2011-09-13'),
('2011-09-14'),
('2011-09-15'),
('2011-09-16'),
('2011-09-17'),
('2011-09-18'),
('2011-09-19'),
('2011-09-20'),
('2011-09-21'),
('2011-09-22'),
('2011-09-23'),
('2011-09-24'),
('2011-09-25'),
('2011-09-26'),
('2011-09-27'),
('2011-09-28'),
('2011-09-29'),
('2011-09-30'),
('2011-10-01'),
('2011-10-02'),
('2011-10-03'),
('2011-10-04'),
('2011-10-05'),
('2011-10-06'),
('2011-10-07'),
('2011-10-08'),
('2011-10-09'),
('2011-10-10'),
('2011-10-11'),
('2011-10-12'),
('2011-10-13'),
('2011-10-14'),
('2011-10-15'),
('2011-10-16'),
('2011-10-17'),
('2011-10-18'),
('2011-10-19'),
('2011-10-20'),
('2011-10-21'),
('2011-10-22'),
('2011-10-23'),
('2011-10-24'),
('2011-10-25'),
('2011-10-26'),
('2011-10-27'),
('2011-10-28'),
('2011-10-29'),
('2011-10-30'),
('2011-10-31'),
('2011-11-01'),
('2011-11-02'),
('2011-11-03'),
('2011-11-04'),
('2011-11-05'),
('2011-11-06'),
('2011-11-07'),
('2011-11-08'),
('2011-11-09'),
('2011-11-10'),
('2011-11-11'),
('2011-11-12'),
('2011-11-13'),
('2011-11-14'),
('2011-11-15'),
('2011-11-16'),
('2011-11-17'),
('2011-11-18'),
('2011-11-19'),
('2011-11-20'),
('2011-11-21'),
('2011-11-22'),
('2011-11-23'),
('2011-11-24'),
('2011-11-25'),
('2011-11-26'),
('2011-11-27'),
('2011-11-28'),
('2011-11-29'),
('2011-11-30'),
('2011-12-01'),
('2011-12-02'),
('2011-12-03'),
('2011-12-04'),
('2011-12-05'),
('2011-12-06'),
('2011-12-07'),
('2011-12-08'),
('2011-12-09'),
('2011-12-10'),
('2011-12-11'),
('2011-12-12'),
('2011-12-13'),
('2011-12-14'),
('2011-12-15'),
('2011-12-16'),
('2011-12-17'),
('2011-12-18'),
('2011-12-19'),
('2011-12-20'),
('2011-12-21'),
('2011-12-22'),
('2011-12-23'),
('2011-12-24'),
('2011-12-25'),
('2011-12-26'),
('2011-12-27'),
('2011-12-28'),
('2011-12-29'),
('2011-12-30'),
('2011-12-31');

CREATE TABLE IF NOT EXISTS `clienti` (
  `id_clienti` mediumint(8) unsigned zerofill NOT NULL auto_increment,
  `Filiale` varchar(5) NOT NULL,
  `Tot` int(11) NOT NULL,
  PRIMARY KEY  (`id_clienti`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;


INSERT INTO `clienti` (`id_clienti`, `Filiale`, `Tot`) VALUES
(00000001, 'Fil1', 100),
(00000002, 'Fil2', 30),
(00000003, 'Fil3', 150),
(00000004, 'Fil4', 60);


CREATE TABLE IF NOT EXISTS `users` (
  `id_user` mediumint(8) unsigned zerofill NOT NULL auto_increment,
  `Filiale` varchar(5) NOT NULL,
  `Tot` int(11) NOT NULL,
  PRIMARY KEY  (`id_user`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

INSERT INTO `users` (`id_user`, `Filiale`, `Tot`) VALUES
(00000001, 'Fil1', 3),
(00000002, 'Fil2', 1),
(00000003, 'Fil3', 130),
(00000004, 'Fil4', 50);