← All changes | includes/replace_macro.php +114 -128 5.0.9 → 3.0.0 View file →

		@@ -1,128 +1,114 @@
1		-<?php
2		-if ( ! defined( 'ABSPATH' ) ) {
3		- exit; // Exit if accessed directly
4		-}
5		-
6		-global $current_user, $wppmfunction,$wpdb;
7		-$current_user_data = get_userdata($current_user->ID);
8		-$project_id = intval(sanitize_text_field($project_id));
9		-$wppm_project_data = $wppmfunction->get_project($project_id);
10		-$orderby_sql = (sanitize_sql_orderby( "id DESC" ));
11		-$wppm_proj_comment = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project_comment where proj_id=%d ORDER BY $orderby_sql LIMIT 1",$project_id));
12		-$attachments = array();
13		-$auth_id = $wppmfunction->get_project_meta($project_id,'project_auth_code',true);
14		-if(!empty($wppm_proj_comment)){
15		- $attachments = explode(',',$wppm_proj_comment->attachment_ids);
16		-}
17		-preg_match_all("/{[^}]*}/" ,$str,$matches);
18		-$matches = array_unique($matches[0]);
19		-$flag =false;
20		-$page_setting = get_option( 'wppm-page-settings' );
21		-$view = $page_setting['project-url-page'];
22		-foreach($matches as $match){
23		- switch($match){
24		- //Current User Name
25		- case '{user_name}':
26		- $str = preg_replace('/{user_name}/', $current_user_data->display_name, $str);
27		- break;
28		- // Project ID
29		- case '{project_id}':
30		- $str = preg_replace('/{project_id}/', $project_id, $str);
31		- break;
32		- // Old project Status
33		- case '{old_project_status}':
34		- $str = preg_replace('/{old_project_status}/', $this->get_old_project_status_name($project_id), $str);
35		- break;
36		- // Project Status
37		- case '{new_project_status}':
38		- $str = preg_replace('/{new_project_status}/', $this->get_new_project_status_name(sanitize_text_field($wppm_project_data['status'])), $str);
39		- break;
40		- // Project Status
41		- case '{project_status}':
42		- $str = preg_replace('/{project_status}/', $this->get_new_project_status_name(sanitize_text_field($wppm_project_data['status'])), $str);
43		- break;
44		- // Project Category
45		- case '{project_category}':
46		- if(!empty($wppm_project_data['cat_id'])){
47		- $str = preg_replace('/{project_category}/', $this->get_project_category_name(sanitize_text_field($wppm_project_data['cat_id'])), $str);
48		- }else{
49		- $str = "";
50		- }
51		-
52		- break;
53		- // Project Name
54		- case '{project_name}':
55		- $str = preg_replace('/{project_name}/', sanitize_text_field($wppm_project_data['project_name']), $str);
56		- break;
57		- // Project Start Date
58		- case '{project_start_date}':
59		- $str = preg_replace('/{project_start_date}/', sanitize_text_field($wppm_project_data['start_date']), $str);
60		- break;
61		- // Project End Date
62		- case '{project_end_date}':
63		- $str = preg_replace('/{project_end_date}/', sanitize_text_field($wppm_project_data['end_date']), $str);
64		- break;
65		- // Assigned Users
66		- case '{project_assigned_users}':
67		- $assigned_users = $this->get_project_assigned_users_names($project_id);
68		- $str = preg_replace('/{project_assigned_users}/', sanitize_text_field($assigned_users), $str);
69		- break;
70		- // Previously Assigned users
71		- case '{previously_assigned_project_users}':
72		- $previously_assigned_users = $this->get_project_previously_assigned_users_names($project_id);
73		- $str = preg_replace('/{previously_assigned_project_users}/', sanitize_text_field($previously_assigned_users), $str);
74		- break;
75		- // Date created
76		- case '{date_created}':
77		- $str = preg_replace('/{date_created}/', get_date_from_gmt(sanitize_text_field($wppm_project_data['date_created'] )), $str);
78		- break;
79		- //Last comment user name
80		- case '{last_proj_comment_user_name}':
81		- $str = preg_replace('/{last_proj_comment_user_name}/', $this->get_last_comment_proj_user_name($project_id), $str);
82		- break;
83		- //Last comment body
84		- case '{proj_comment_body}':
85		- $flag= true;
86		- if(!empty($this->get_proj_comment_body($project_id))){
87		- $str = preg_replace('/{proj_comment_body}/', $this->get_proj_comment_body($project_id), $str);
88		- } else{
89		- $str = "";
90		- }
91		- break;
92		-
93		- // Project Description
94		- case '{project_description}':
95		- $str = preg_replace('/{project_description}/', sanitize_text_field($wppm_project_data['description']), $str);
96		- break;
97		- case '{project_url}':
98		- $project_url = '<a class="wppm_link" href="' . $this->get_project_url($project_id,$view) . '" target="_blank">' . $this->get_project_url($project_id,$view) . '</a>';
99		- $str = preg_replace('/{project_url}/', $project_url, $str);
100		- break;
101		-
102		- }
103		-}
104		-if($flag == true){
105		- if(!empty($attachments)){
106		- foreach($attachments as $attach_id){
107		- $upload_dir = wp_upload_dir();
108		- $attach_id = absint($attach_id);
109		- $attachment = $wpdb->get_row($wpdb->prepare("select * from {$wpdb->prefix}wppm_attachments where id=%d",$attach_id));
110		- if(!empty($attachment)){
111		- $updated_time = sanitize_text_field($attachment->date_created);
112		- $time = strtotime(sanitize_text_field($updated_time));
113		- $month = wp_date("m",$time);
114		- $year = wp_date("Y",$time);
115		- $findStr = ".txt";
116		- $attachment_name = preg_replace('/' . $findStr . '/', "", sanitize_file_name($attachment->name), 1);
117		- $file_url = $upload_dir['basedir'] . '/wppm/'.'/'.$year.'/'.$month.'/'. $attachment_name;
118		- $download_url = home_url('/').'?wppm_attachment='.sanitize_text_field($attachment->id).'&pid='.sanitize_text_field($project_id).'&pac='.sanitize_text_field($auth_id);
119		- $attach_url[] = '<a style="text-decoration:none;" href="'.$download_url.'" target="_blank">'.sanitize_file_name($attachment->file_name).'</a>';
120		- }else{
121		- $attach_url= array();
122		- }
123		- }
124		- $str = $str.implode("<br>",$attach_url);
125		- }
126		-}
127		-$str = apply_filters('wppm_replace_macro',$str,$project_id);
128		-
	1	+<?php
	2	+if ( ! defined( 'ABSPATH' ) ) {
	3	+ exit; // Exit if accessed directly
	4	+}
	5	+
	6	+global $current_user, $wppmfunction,$wpdb;
	7	+$current_user_data = get_userdata($current_user->ID);
	8	+$project_id = intval(sanitize_text_field($project_id));
	9	+$wppm_project_data = $wppmfunction->get_project($project_id);
	10	+$wppm_proj_comment = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_comment where proj_id='".$project_id."' ORDER BY id DESC LIMIT 1;");
	11	+$attachments = array();
	12	+$auth_id = $wppmfunction->get_project_meta($project_id,'project_auth_code',true);
	13	+if(!empty($wppm_proj_comment)){
	14	+ $attachments = explode(',',$wppm_proj_comment->attachment_ids);
	15	+}
	16	+preg_match_all("/{[^}]*}/" ,$str,$matches);
	17	+$matches = array_unique($matches[0]);
	18	+$flag =false;
	19	+foreach($matches as $match){
	20	+ switch($match){
	21	+ //Current User Name
	22	+ case '{user_name}':
	23	+ $str = preg_replace('/{user_name}/', $current_user_data->display_name, $str);
	24	+ break;
	25	+ // Project ID
	26	+ case '{project_id}':
	27	+ $str = preg_replace('/{project_id}/', $project_id, $str);
	28	+ break;
	29	+ // Old project Status
	30	+ case '{old_project_status}':
	31	+ $str = preg_replace('/{old_project_status}/', $this->get_old_project_status_name($project_id), $str);
	32	+ break;
	33	+ // Project Status
	34	+ case '{new_project_status}':
	35	+ $str = preg_replace('/{new_project_status}/', $this->get_new_project_status_name(sanitize_text_field($wppm_project_data['status'])), $str);
	36	+ break;
	37	+ // Project Status
	38	+ case '{project_status}':
	39	+ $str = preg_replace('/{project_status}/', $this->get_new_project_status_name(sanitize_text_field($wppm_project_data['status'])), $str);
	40	+ break;
	41	+ // Project Category
	42	+ case '{project_category}':
	43	+ if(!empty($wppm_project_data['cat_id'])){
	44	+ $str = preg_replace('/{project_category}/', $this->get_project_category_name(sanitize_text_field($wppm_project_data['cat_id'])), $str);
	45	+ }else{
	46	+ $str = "";
	47	+ }
	48	+
	49	+ break;
	50	+ // Project Name
	51	+ case '{project_name}':
	52	+ $str = preg_replace('/{project_name}/', sanitize_text_field($wppm_project_data['project_name']), $str);
	53	+ break;
	54	+ // Project Start Date
	55	+ case '{project_start_date}':
	56	+ $str = preg_replace('/{project_start_date}/', sanitize_text_field($wppm_project_data['start_date']), $str);
	57	+ break;
	58	+ // Project End Date
	59	+ case '{project_end_date}':
	60	+ $str = preg_replace('/{project_end_date}/', sanitize_text_field($wppm_project_data['end_date']), $str);
	61	+ break;
	62	+ // Assigned Users
	63	+ case '{project_assigned_users}':
	64	+ $assigned_users = $this->get_project_assigned_users_names($project_id);
	65	+ $str = preg_replace('/{project_assigned_users}/', sanitize_text_field($assigned_users), $str);
	66	+ break;
	67	+ // Previously Assigned users
	68	+ case '{previously_assigned_project_users}':
	69	+ $previously_assigned_users = $this->get_project_previously_assigned_users_names($project_id);
	70	+ $str = preg_replace('/{previously_assigned_project_users}/', sanitize_text_field($previously_assigned_users), $str);
	71	+ break;
	72	+ // Date created
	73	+ case '{date_created}':
	74	+ $str = preg_replace('/{date_created}/', get_date_from_gmt(sanitize_text_field($wppm_project_data['date_created'] )), $str);
	75	+ break;
	76	+ //Last comment user name
	77	+ case '{last_proj_comment_user_name}':
	78	+ $str = preg_replace('/{last_proj_comment_user_name}/', $this->get_last_comment_proj_user_name($project_id), $str);
	79	+ break;
	80	+ //Last comment body
	81	+ case '{proj_comment_body}':
	82	+ $flag= true;
	83	+ $str = preg_replace('/{proj_comment_body}/', $this->get_proj_comment_body($project_id), $str);
	84	+ break;
	85	+
	86	+ // Project Description
	87	+ case '{project_description}':
	88	+ $str = preg_replace('/{project_description}/', sanitize_text_field($wppm_project_data['description']), $str);
	89	+ }
	90	+}
	91	+if($flag == true){
	92	+ if(!empty($attachments)){
	93	+ foreach($attachments as $attach_id){
	94	+ $upload_dir = wp_upload_dir();
	95	+ $attachment = $wpdb->get_row("select * from {$wpdb->prefix}wppm_attachments where id='".$attach_id."'");
	96	+ if(!empty($attachment)){
	97	+ $updated_time = sanitize_text_field($attachment->date_created);
	98	+ $time = strtotime(sanitize_text_field($updated_time));
	99	+ $month = date("m",$time);
	100	+ $year = date("Y",$time);
	101	+ $findStr = ".txt";
	102	+ $attachment_name = preg_replace('/' . $findStr . '/', "", sanitize_file_name($attachment->name), 1);
	103	+ $file_url = $upload_dir['basedir'] . '/wppm/'.'/'.$year.'/'.$month.'/'. $attachment_name;
	104	+ $download_url = home_url('/').'?wppm_attachment='.sanitize_text_field($attachment->id).'&pid='.sanitize_text_field($project_id).'&pac='.sanitize_text_field($auth_id);
	105	+ $attach_url[] = '<a style="text-decoration:none;" href="'.$download_url.'" target="_blank">'.sanitize_file_name($attachment->file_name).'</a>';
	106	+ }else{
	107	+ $attach_url= array();
	108	+ }
	109	+ }
	110	+ $str = $str.implode("<br>",$attach_url);
	111	+ }
	112	+}
	113	+$str = apply_filters('wppm_replace_macro',$str,$project_id);
	114	+