{"id":2360,"date":"2025-03-12T11:22:44","date_gmt":"2025-03-12T15:22:44","guid":{"rendered":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/?page_id=2360"},"modified":"2025-12-08T08:20:16","modified_gmt":"2025-12-08T13:20:16","slug":"modeles-de-requetes-module-facturation","status":"publish","type":"page","link":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/requetes\/modeles-de-requetes-module-facturation\/","title":{"rendered":"Mod\u00e8les de requ\u00eates &#8211; Module Facturation"},"content":{"rendered":"<div id=\"pl-2360\"  class=\"panel-layout\" ><div id=\"pg-2360-0\"  class=\"panel-grid panel-no-style\" ><div id=\"pgc-2360-0-0\"  class=\"panel-grid-cell\" ><div id=\"panel-2360-0-0-0\" class=\"so-panel widget widget_text panel-first-child\" data-index=\"0\" >\t\t\t<div class=\"textwidget\"><p>Vous trouverez ci-dessous les mod\u00e8les de requ\u00eates principalement bas\u00e9es sur les donn\u00e9es du module Facturation.<\/p>\n<\/div>\n\t\t<\/div><div id=\"panel-2360-0-0-1\" class=\"so-panel widget widget_lsow-accordion panel-last-child\" data-index=\"1\" ><div\n\t\t\t\n\t\t\tclass=\"so-widget-lsow-accordion so-widget-lsow-accordion-default-d75171398898-2360\"\n\t\t\t\n\t\t>\n<div class=\"lsow-accordion style1\" data-toggle=\"false\" data-expanded=\"false\"><div class=\"lsow-panel\" id=\"\"><div class=\"lsow-panel-title\">Req 011 - Sommaire des AVF<\/div><div class=\"lsow-panel-content\"><ul>\n<li>Description: Liste des Avis de Facturation (AVF) dont la date de facturation se situe dans une p\u00e9riode donn\u00e9e.<\/li>\n<li>Param\u00e8tres:\n<ul>\n<li>Instance (c'est-\u00e0-dire la(es) plateforme(s) ou service(s) pour lesquels on veut obtenir les donn\u00e9es)<\/li>\n<li>Date de d\u00e9but de la p\u00e9riode pour laquelle on veut les AVF<\/li>\n<li>Date de fin de la p\u00e9riode pour laquelle on veut les AVF<\/li>\n<\/ul>\n<\/li>\n<li>Onglets:\n<ul>\n<li>N\/A<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div><\/div><!-- .lsow-panel --><div class=\"lsow-panel\" id=\"\"><div class=\"lsow-panel-title\">Req 006 - Sommaire des mandats<\/div><div class=\"lsow-panel-content\"><ul>\n<li>Description: Liste des mandats, des services et des requ\u00e9rants qui y sont associ\u00e9s pour une p\u00e9riode donn\u00e9e. Cette requ\u00eate permet d'extraire les donn\u00e9es sur les mandats <strong>non facturables.<\/strong><\/li>\n<li>Param\u00e8tres:\n<ul>\n<li>Instance (c'est-\u00e0-dire la(es) plateforme(s) ou service(s) pour lesquels on veut obtenir les donn\u00e9es)<\/li>\n<li>Date de d\u00e9but de la p\u00e9riode pour laquelle on veut les mandats.<\/li>\n<li>Date de fin de la p\u00e9riode pour laquelle on veut les mandats.<\/li>\n<\/ul>\n<\/li>\n<li>Onglets:\n<ul>\n<li>Mandats: pr\u00e9sente les mandats pour lesquels il y a eu des heures faites dans la p\u00e9riode indiqu\u00e9e en param\u00e8tres.<\/li>\n<li>Services: pr\u00e9sente les activit\u00e9s saisies dans le calendrier pendant la p\u00e9riode indiqu\u00e9e en param\u00e8tres.<\/li>\n<li>Requ\u00e9rants: pr\u00e9sente les requ\u00e9rants des mandats pour lesquels il y a eu des heures faites dans la p\u00e9riode indiqu\u00e9e en param\u00e8tres.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Des heures doivent avoir \u00e9t\u00e9 r\u00e9alis\u00e9es pour que le mandat sorte dans les r\u00e9sultats de la requ\u00eate.<\/p>\n<\/div><\/div><!-- .lsow-panel --><\/div><!-- .lsow-accordion --><\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Vous trouverez ci-dessous les mod\u00e8les de requ\u00eates principalement bas\u00e9es sur les donn\u00e9es du module Facturation.<\/p>\n","protected":false},"author":88,"featured_media":0,"parent":814,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/pages\/2360"}],"collection":[{"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/users\/88"}],"replies":[{"embeddable":true,"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/comments?post=2360"}],"version-history":[{"count":4,"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/pages\/2360\/revisions"}],"predecessor-version":[{"id":2511,"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/pages\/2360\/revisions\/2511"}],"up":[{"embeddable":true,"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/pages\/814"}],"wp:attachment":[{"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/media?parent=2360"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/temp.crchudequebec.ca\/extranet\/agora\/wp-json\/wp\/v2\/tags?post=2360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}