{"action":"created","issue":{"url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item/issues/61","repository_url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item","labels_url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item/issues/61/labels{/name}","comments_url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item/issues/61/comments","events_url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item/issues/61/events","html_url":"https://github.com/OpenBudget/budgetkey-app-generic-item/issues/61","id":300185755,"node_id":"MDU6SXNzdWUzMDAxODU3NTU=","number":61,"title":"Create a Central Tenders/RFI/Group Agreement Page for open (new/updated) tenders","user":{"login":"noamoss","id":3581741,"node_id":"MDQ6VXNlcjM1ODE3NDE=","avatar_url":"https://avatars0.githubusercontent.com/u/3581741?v=4","gravatar_id":"","url":"https://api.github.com/users/noamoss","html_url":"https://github.com/noamoss","followers_url":"https://api.github.com/users/noamoss/followers","following_url":"https://api.github.com/users/noamoss/following{/other_user}","gists_url":"https://api.github.com/users/noamoss/gists{/gist_id}","starred_url":"https://api.github.com/users/noamoss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/noamoss/subscriptions","organizations_url":"https://api.github.com/users/noamoss/orgs","repos_url":"https://api.github.com/users/noamoss/repos","events_url":"https://api.github.com/users/noamoss/events{/privacy}","received_events_url":"https://api.github.com/users/noamoss/received_events","type":"User","site_admin":false},"labels":[{"id":849222277,"node_id":"MDU6TGFiZWw4NDkyMjIyNzc=","url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item/labels/on%20hold","name":"on hold","color":"8db72a","default":false},{"id":768085758,"node_id":"MDU6TGFiZWw3NjgwODU3NTg=","url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item/labels/open-procure","name":"open-procure","color":"1ab2c3","default":false},{"id":844869351,"node_id":"MDU6TGFiZWw4NDQ4NjkzNTE=","url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item/labels/prioritised","name":"prioritised","color":"ededed","default":false}],"state":"open","locked":false,"assignee":{"login":"akariv","id":265333,"node_id":"MDQ6VXNlcjI2NTMzMw==","avatar_url":"https://avatars3.githubusercontent.com/u/265333?v=4","gravatar_id":"","url":"https://api.github.com/users/akariv","html_url":"https://github.com/akariv","followers_url":"https://api.github.com/users/akariv/followers","following_url":"https://api.github.com/users/akariv/following{/other_user}","gists_url":"https://api.github.com/users/akariv/gists{/gist_id}","starred_url":"https://api.github.com/users/akariv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akariv/subscriptions","organizations_url":"https://api.github.com/users/akariv/orgs","repos_url":"https://api.github.com/users/akariv/repos","events_url":"https://api.github.com/users/akariv/events{/privacy}","received_events_url":"https://api.github.com/users/akariv/received_events","type":"User","site_admin":false},"assignees":[{"login":"akariv","id":265333,"node_id":"MDQ6VXNlcjI2NTMzMw==","avatar_url":"https://avatars3.githubusercontent.com/u/265333?v=4","gravatar_id":"","url":"https://api.github.com/users/akariv","html_url":"https://github.com/akariv","followers_url":"https://api.github.com/users/akariv/followers","following_url":"https://api.github.com/users/akariv/following{/other_user}","gists_url":"https://api.github.com/users/akariv/gists{/gist_id}","starred_url":"https://api.github.com/users/akariv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akariv/subscriptions","organizations_url":"https://api.github.com/users/akariv/orgs","repos_url":"https://api.github.com/users/akariv/repos","events_url":"https://api.github.com/users/akariv/events{/privacy}","received_events_url":"https://api.github.com/users/akariv/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2018-02-26T10:34:16Z","updated_at":"2018-06-15T05:53:19Z","closed_at":null,"author_association":"NONE","body":"(Invisoin link: https://projects.invisionapp.com/d/main#/console/7587193/276178413/preview )\r\n\r\n![image](https://user-images.githubusercontent.com/3581741/36676957-a6d6cbc4-1b15-11e8-992e-fc752b2b9123.png)\r\n\r\n\r\nOpen Office Tender (`WHERE tender_type = 'central' AND decision='בתוקף'`)\r\n\r\ndynamic values:\r\n-------------\r\n\r\n|No. | data source | label | value / logic | comments |\r\n|---|---|---|---|---|\r\n1 | any of the fields |none| if a value changed during  `TODAY <= LAST_UPDATE_DATE + 7 days`value should be `עודכן!`, if `TODAY <= START_DATE + 7 ` value should be `חדש!` |  do not use the `decision` field value here, as it is not reflecting what we intend to show with this label. | Don't use the raw value of the `decision` field, as it does not consist the required logic! |\r\n2 | `decision` | none | `מכרז פתוח`: based on the  `decision` field: if `decision` == `בתוקף` ||\r\n3 | `LAST_UPDATE_DATE` | `עדכון אחרון` | date | dd.mm.yyyy |\r\n4 | `START_DATE` | `פרסום ראשון` | date | dd.mm.yyyy |\r\n5 | `page_title` (transformed) | | take out the 'מכרז XXXX:', we should transform other types of tenders titles (RFI or Group Agreements) | BOLD |\r\n6 | `decision` | none |  based on the  `decision` בםמאקמא || \r\n7 | | none | | `מנהל הרכש הממשלתי` | | \r\n8 | `quarterly_contract_spending_reports.supplier_name` | none | A. if the `tender_id` appears in `quarterly_contract_spending_reports.manof_ref` and `count('supplier_name') == 1`, display `supplier_name`). B. if `count('supplier_name') > 2, display `[num] ספקים`.  C. Otherwise, leave empty | \r\n9a | `quarterly_contract_spending_reports.executed`, `quarterly_contract_spending_reports.volume`| | pie chart || \r\n9b | `quarterly_contract_spending_reports.executed`, `quarterly_contract_spending_reports.volume` | 'עד כה בוצעו...% מתוך:` | `exectued` / `volume` | dd% (round result). Notice this formula should relate to ALL relevant suppliers (using `manof_ref`) |\r\n9c | `quarterly_contract_spending_reports.executed` | none | sum of all `exectued` values for the relevant `manof_ref` | add NIS symbol to value|\r\n10 | `SUBJECTS` | | label per each value. Each label should be linked to a search results page of procurement_tenders from the same topic | \r\n11 | 'description' | תיאור | | |\r\n12a | `tender_id`| מספר מנו\"ף | `tender_id` | |\r\n12b | `REGULATION` | סוג: | if RFI --> `בקשת מידע`, if 'מכרז'--> מכרז מרכזי', if 'הסכם מסגרת' --> `הסכם מסגרת` | |\r\n12c | `CLAIM_DATE` | מועד סגירה: ... בשעה... | | dd.mm.yyyy + HH:MM: | \r\n12d| `CONTACT` | אנשי קשר: | | email adresses should be clickable and open user's email client|\r\n13a | actionable A # | | | to be handled on a follow #51 |\r\n13b | actionable B # | | | to be handled on a follow #51 |\r\n14 | (table intro) | table headers : `הזוכים במכרז`, ` סכום ההתקשרות`, `עד כה שולם` | values in this block are to be calculated by the intersection between current `tender_id` and `quarterly_contract_spending_reports.manof_ref`. Table should be sorted by the `value` amount (13b) in a decreasing order (biggest value, first row) | \r\n14a | `quarterly_contract_spending_reports.supplier_name` | | | in the future it would be linked to future entity page, currently nothing special | \r\n14b | `quarterly_contract_spending_reports.volume`| none, add a NIS symbol | sum of `quarterly_contract_spending_reports.volume` of the concrete supllier under the concrete `manof_ref` | don't round result, display real number (up to 2 digits after demical point)  | \r\n14c | `quarterly_c`quarterly_contract_spending_reports.executed`| none, add a NIS symbol | sum of `quarterly_contract_spending_reports.executed` of the concrete supllier under the concrete `manof_ref` | don't round result, display real number (up to 2 digits after demical point) | \r\n14d | | link to the relevant התקשרות page| | \r\n15 | (table intro) | table shows chronological history of the tender, in a reversed order. Two type of updates to be included: tender status change (bolded), payment (taken from the quarterly report) (bolded row), uploading/updating file (normal text for the entrie row) | |\r\n15a |`quarterly_c`quarterly_contract_spending_reports.volume`, `quarterly_c`quarterly_contract_spending_reports.executed` | no headers | pie chart of the `executed` out of the total `volume` | the pie chart refers to the tender's total exectued out of the total approved values, not to be confused with 13 above  | \r\n15b | (update date -- from either  `quarterly_c`quarterly_contract_spending_reports` or `procurement_tenders` | | if date == Today -->  `היום`, if Today - date <= 7 --> `ימים x לפני`, if Today- date < 4 weeks, divide days number by 7 -->  `לפני כ-x שבועות`, otherwise: raw date (DD.MM.YYYY) | |\r\n15c | `quarterly_contract_spending_report.PAGE_URL` or `quarterly_contract_spending_reports.REPORT-URL`| don't show address, just display the icon with a relevant link | | to be opened in a new tab|\r\n15d | update message | | |needs to set logic to be handled in a separate issue, to be hanled in #52 | \r\n16 | grid intro, based on `procurement_tenders.DOCUMENTS` | `הוראות שעה וקבצים מצורפים` | | |\r\n16a | `update_time` | none | (update date -- from either `quarterly_contract_spending_reports` or `procurement_tenders`) if date == Today -->  `היום`, if Today - date <= 7 --> `ימים x לפני`, if Today- date < 4 weeks, divide days number by 7 -->  `לפני כ-x שבועות`, otherwise: raw date (DD.MM.YYYY) ||\r\n16b | icon + file name |  | icon to be set by the file type extention (doc/pdf/xls/csv), each element should be linked to the `link` address. If the number of elements is bigger than 3, start a new row of elements |\r\n"},"comment":{"url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item/issues/comments/397520882","html_url":"https://github.com/OpenBudget/budgetkey-app-generic-item/issues/61#issuecomment-397520882","issue_url":"https://api.github.com/repos/OpenBudget/budgetkey-app-generic-item/issues/61","id":397520882,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NzUyMDg4Mg==","user":{"login":"akariv","id":265333,"node_id":"MDQ6VXNlcjI2NTMzMw==","avatar_url":"https://avatars3.githubusercontent.com/u/265333?v=4","gravatar_id":"","url":"https://api.github.com/users/akariv","html_url":"https://github.com/akariv","followers_url":"https://api.github.com/users/akariv/followers","following_url":"https://api.github.com/users/akariv/following{/other_user}","gists_url":"https://api.github.com/users/akariv/gists{/gist_id}","starred_url":"https://api.github.com/users/akariv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akariv/subscriptions","organizations_url":"https://api.github.com/users/akariv/orgs","repos_url":"https://api.github.com/users/akariv/repos","events_url":"https://api.github.com/users/akariv/events{/privacy}","received_events_url":"https://api.github.com/users/akariv/received_events","type":"User","site_admin":false},"created_at":"2018-06-15T05:53:19Z","updated_at":"2018-06-15T05:53:19Z","author_association":"MEMBER","body":"@noamoss released from hold?"}}
{"actor":{"display_login":"akariv"}}