{"id":3461,"date":"2018-02-02T08:12:24","date_gmt":"2018-02-02T07:12:24","guid":{"rendered":"http:\/\/www.blue-bears.com\/blog\/?p=3461"},"modified":"2018-02-02T09:38:27","modified_gmt":"2018-02-02T08:38:27","slug":"developpement-crm-web-open-source","status":"publish","type":"post","link":"http:\/\/www.blue-bears.com\/blog\/?p=3461","title":{"rendered":"D\u00e9veloppement CRM Web Open Source"},"content":{"rendered":"<p>Faire D\u00e9velopper le CRM en Open Source et le mettre \u00e0 disposition des ALTER EGO.<br \/>\nLa derni\u00e8re version \u00e0 disposition des membres du groupe de d\u00e9veloppement (ceux qui paient)<br \/>\nL&rsquo;avant derni\u00e8re \u00e0 disposition de tout le monde.<!--more--><\/p>\n<h4>Architecture :<\/h4>\n<ul>\n<li>Serveur Linux \/ Apache \/ PHP \/ MySQL<\/li>\n<li>Hebergement : PHPNet de pr\u00e9f\u00e9rence mais portable sur OVH<\/li>\n<li>Pattern : lequel ? =&gt; Orient\u00e9 Vue Model Controler<\/li>\n<li>Webdev BPVF en MOE<\/li>\n<li>D\u00e9ploiement GITHub.<\/li>\n<\/ul>\n<h4>Cahier des charges :<\/h4>\n<ul>\n<li>Contraintes :\n<ul>\n<li>Rapidit\u00e9 de r\u00e9ponse<\/li>\n<li>S\u00e9curit\u00e9 =&gt; donn\u00e9es clients \u00ab\u00a0sensibles CNIL\u00a0\u00bb (Adresses, Tel, Mail, CR, Mail &#8230;) mais pas d&rsquo;info bancaires ou de paiement.<\/li>\n<li>Contr\u00f4le d\u2019acc\u00e8s.<\/li>\n<li>Tra\u00e7abilit\u00e9 :\n<ul>\n<li>Log des modifications<\/li>\n<\/ul>\n<\/li>\n<li>Taille estim\u00e9e (300M0) :\n<ul>\n<li>Table EVENTS : Tous les \u00e9v\u00e8nements + mails e tous les clients =&gt; 1 000 EVENTS * 10 000 clients * 30 champs dont 3 \u00ab\u00a0longs\u00a0\u00bb<\/li>\n<li>Table CLIENTS : 10 000 * 50 champs<\/li>\n<li>Table PROGRAMMES : 2 000 programmes * 50 champs dont 2 longs (description) au moins.<\/li>\n<li>Table LOTS : (2000 programmes * 200 lots) * 50 champs<\/li>\n<li>Table AGENCES : 300 * 20 champs<\/li>\n<li>Table COLLABORATEURS : 5 000 * 20 champs<\/li>\n<li>Table USERS<\/li>\n<li>Table STATIC : tous les param\u00e8tres<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Fonctionnalit\u00e9s :\n<ul>\n<li>Accessibilit\u00e9 :\n<ul>\n<li>Un mode Admin =&gt; tout =&gt; dont USERS\/STATICS&#8230;.<\/li>\n<li>Un Mode \u00c9diteur =&gt; modification\/suppression CLIENTS\/EVENTS\/LOTS\/PROGRAMMES<\/li>\n<li>Un mode User =&gt; Lecture seule des tables CLIENTS\/EVENTS\/LOTS\/PROGRAMMES<\/li>\n<\/ul>\n<\/li>\n<li>Export :\n<ul>\n<li>export de requ\u00eates sous forme de tables accessibles depuis le web en vue d&rsquo;int\u00e9gration dans de l&rsquo;Excel ou de l&rsquo;Access. =&gt; contr\u00f4le d&rsquo;acc\u00e8s par cookies ? Log sur le poste en web =&gt; d\u00e9p\u00f4t cookie. L&rsquo;URL appel\u00e9e depuis le poste doit alors int\u00e9grer une cl\u00e9 calcul\u00e9e \u00e0 partir du cookie.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h4>D\u00e9veloppeur :<\/h4>\n<ul>\n<li>ECOMSOFT\n<ul>\n<li>D\u00e9veloppe pour des Assoc, etc&#8230; d\u00e9veloppement Agile<\/li>\n<li><a href=\"https:\/\/www.ecomsoft.fr\/developpement-dapplications-et-de-logiciels-sur-mesure\/\">https:\/\/www.ecomsoft.fr\/developpement-dapplications-et-de-logiciels-sur-mesure\/<\/a><\/li>\n<\/ul>\n<\/li>\n<li><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Faire D\u00e9velopper le CRM en Open Source et le mettre \u00e0 disposition des ALTER EGO. La derni\u00e8re version \u00e0 disposition des membres [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-3461","post","type-post","status-publish","format-standard","hentry","category-informatique"],"_links":{"self":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3461"}],"version-history":[{"count":3,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3461\/revisions"}],"predecessor-version":[{"id":3465,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3461\/revisions\/3465"}],"wp:attachment":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3461"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}