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

		@@ -1,128 +1,120 @@
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	+$orderby_sql = esc_sql(sanitize_sql_orderby( "id DESC" ));
	11	+$wppm_proj_comment = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_comment where proj_id='".esc_sql($project_id)."' ORDER BY $orderby_sql LIMIT 1;");
	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	+foreach($matches as $match){
	21	+ switch($match){
	22	+ //Current User Name
	23	+ case '{user_name}':
	24	+ $str = preg_replace('/{user_name}/', $current_user_data->display_name, $str);
	25	+ break;
	26	+ // Project ID
	27	+ case '{project_id}':
	28	+ $str = preg_replace('/{project_id}/', $project_id, $str);
	29	+ break;
	30	+ // Old project Status
	31	+ case '{old_project_status}':
	32	+ $str = preg_replace('/{old_project_status}/', $this->get_old_project_status_name($project_id), $str);
	33	+ break;
	34	+ // Project Status
	35	+ case '{new_project_status}':
	36	+ $str = preg_replace('/{new_project_status}/', $this->get_new_project_status_name(sanitize_text_field($wppm_project_data['status'])), $str);
	37	+ break;
	38	+ // Project Status
	39	+ case '{project_status}':
	40	+ $str = preg_replace('/{project_status}/', $this->get_new_project_status_name(sanitize_text_field($wppm_project_data['status'])), $str);
	41	+ break;
	42	+ // Project Category
	43	+ case '{project_category}':
	44	+ if(!empty($wppm_project_data['cat_id'])){
	45	+ $str = preg_replace('/{project_category}/', $this->get_project_category_name(sanitize_text_field($wppm_project_data['cat_id'])), $str);
	46	+ }else{
	47	+ $str = "";
	48	+ }
	49	+
	50	+ break;
	51	+ // Project Name
	52	+ case '{project_name}':
	53	+ $str = preg_replace('/{project_name}/', sanitize_text_field($wppm_project_data['project_name']), $str);
	54	+ break;
	55	+ // Project Start Date
	56	+ case '{project_start_date}':
	57	+ $str = preg_replace('/{project_start_date}/', sanitize_text_field($wppm_project_data['start_date']), $str);
	58	+ break;
	59	+ // Project End Date
	60	+ case '{project_end_date}':
	61	+ $str = preg_replace('/{project_end_date}/', sanitize_text_field($wppm_project_data['end_date']), $str);
	62	+ break;
	63	+ // Assigned Users
	64	+ case '{project_assigned_users}':
	65	+ $assigned_users = $this->get_project_assigned_users_names($project_id);
	66	+ $str = preg_replace('/{project_assigned_users}/', sanitize_text_field($assigned_users), $str);
	67	+ break;
	68	+ // Previously Assigned users
	69	+ case '{previously_assigned_project_users}':
	70	+ $previously_assigned_users = $this->get_project_previously_assigned_users_names($project_id);
	71	+ $str = preg_replace('/{previously_assigned_project_users}/', sanitize_text_field($previously_assigned_users), $str);
	72	+ break;
	73	+ // Date created
	74	+ case '{date_created}':
	75	+ $str = preg_replace('/{date_created}/', get_date_from_gmt(sanitize_text_field($wppm_project_data['date_created'] )), $str);
	76	+ break;
	77	+ //Last comment user name
	78	+ case '{last_proj_comment_user_name}':
	79	+ $str = preg_replace('/{last_proj_comment_user_name}/', $this->get_last_comment_proj_user_name($project_id), $str);
	80	+ break;
	81	+ //Last comment body
	82	+ case '{proj_comment_body}':
	83	+ $flag= true;
	84	+ if(!empty($this->get_proj_comment_body($project_id))){
	85	+ $str = preg_replace('/{proj_comment_body}/', $this->get_proj_comment_body($project_id), $str);
	86	+ } else{
	87	+ $str = "";
	88	+ }
	89	+ break;
	90	+
	91	+ // Project Description
	92	+ case '{project_description}':
	93	+ $str = preg_replace('/{project_description}/', sanitize_text_field($wppm_project_data['description']), $str);
	94	+ }
	95	+}
	96	+if($flag == true){
	97	+ if(!empty($attachments)){
	98	+ foreach($attachments as $attach_id){
	99	+ $upload_dir = wp_upload_dir();
	100	+ $attach_id = esc_sql($attach_id);
	101	+ $attachment = $wpdb->get_row("select * from {$wpdb->prefix}wppm_attachments where id='".$attach_id."'");
	102	+ if(!empty($attachment)){
	103	+ $updated_time = sanitize_text_field($attachment->date_created);
	104	+ $time = strtotime(sanitize_text_field($updated_time));
	105	+ $month = date("m",$time);
	106	+ $year = date("Y",$time);
	107	+ $findStr = ".txt";
	108	+ $attachment_name = preg_replace('/' . $findStr . '/', "", sanitize_file_name($attachment->name), 1);
	109	+ $file_url = $upload_dir['basedir'] . '/wppm/'.'/'.$year.'/'.$month.'/'. $attachment_name;
	110	+ $download_url = home_url('/').'?wppm_attachment='.sanitize_text_field($attachment->id).'&pid='.sanitize_text_field($project_id).'&pac='.sanitize_text_field($auth_id);
	111	+ $attach_url[] = '<a style="text-decoration:none;" href="'.$download_url.'" target="_blank">'.sanitize_file_name($attachment->file_name).'</a>';
	112	+ }else{
	113	+ $attach_url= array();
	114	+ }
	115	+ }
	116	+ $str = $str.implode("<br>",$attach_url);
	117	+ }
	118	+}
	119	+$str = apply_filters('wppm_replace_macro',$str,$project_id);
	120	+